Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-38758: cannot flashback data file string; restored since last recovery

1 3449

ORA-38759: Database must be mounted EXCLUSIVE and not open.

1 5219

ORA-38760: This database instance failed to turn on flashback database

1 4984

ORA-38761: thread string redo log sequence number string could not be accessed

1 4073

ORA-38762: thread string redo log with scn string could not be found

1 3779

ORA-38763: flashback not started; enabled threads have changed

1 3021

ORA-38764: flashback not started; datafile string enabled threads are different

1 3007

ORA-38765: Flashed back database cannot be opened read-only.

1 2867

ORA-38766: cannot flashback data file string; file resized smaller

1 5316

ORA-38767: flashback retention target parameter mismatch

1 4765

ORA-38768: resizing datafile string failed

1 3433

ORA-38769: FLASHBACK DATABASE failed after modifying data.

1 6322

ORA-38770: FLASHBACK DATABASE failed during recovery.

1 5413

ORA-38771: unnamed datafile(s) added to controlfile by flashback recovery

1 3480

ORA-38772: cannot add datafile 'string' - file could not be created

1 2767

Un-Answered Questions { Database Errors }

IMP-00064: Definition of LOB was truncated by export

6428

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1667

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2737

hp asking for replication floppy to do reinstall 25254 server assistant

2901

When do you get "getwmicomexception"?

2690

ORA-26084: direct path context already finished

1957

ORA-26029: index string.string partition string initially in unusable state

2165

ORA-26076: cannot set or reset value after direct path structure is allocated

1976

IMG-02003: 2FF03 - incorrect color histogram feature specification

1721

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2613

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2816

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2812

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2547

ORA-26030: index string.string had string partitions made unusable due to:

1949

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3183

For More Un-Answered { Database Errors } Questions Click Here