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 3501

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

1 5280

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

1 5056

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

1 4134

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

1 3825

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

1 3080

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

1 3072

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

1 2932

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

1 5372

ORA-38767: flashback retention target parameter mismatch

1 4831

ORA-38768: resizing datafile string failed

1 3497

ORA-38769: FLASHBACK DATABASE failed after modifying data.

1 6398

ORA-38770: FLASHBACK DATABASE failed during recovery.

1 5479

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

1 3565

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

1 2832

Un-Answered Questions { Database Errors }

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

2229

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.

1697

How to view the error log for any specific instance?

2534

ORA-16516: The current state is invalid for the attempted operation.

8875

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...

2661

hp asking for replication floppy to do reinstall 25254 server assistant

2961

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.

2573

IMP-00070: Lob definitions in dump file are inconsistent with database.

1796

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

1986

What severity level errors are managed in TRY-CATCH block?

2264

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

3224

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2517

ORA-16626: failed to enable specified object

2272

RMAN-05017: no copy of datafile number found to recover

2465

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

2857

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