Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-19777: ASM file string cannot be proxy backed up.

1 2580

ORA-19800: Unable to initialize Oracle Managed Destination

1 7705

ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

1 3563

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 5297

ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)

1 7374

ORA-19804: cannot reclaim string bytes disk space from string limit

1 5247

ORA-19805: recid string of string is about to be deleted or resized

1 2504

ORA-19806: cannot make duplex backups in recovery area

2 11640

ORA-19808: recovery destination parameter mismatch

1 5073

ORA-19809: limit exceeded for recovery files

1 2931

ORA-19810: Cannot create temporary controlfile file string in DB_RECOVERY_FILE_DEST

1 9156

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 5711

ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 2578

ORA-19813: cannot have unavailable file string in DB_RECOVERY_FILE_DEST

1 3516

ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.

1 3231


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2308


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

1288


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

1559


ORA-26095: unprocessed stream data exists

2803


ORA-26082: load of overlapping segments on table string.string is not allowed

1376






ORA-26084: direct path context already finished

1483


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

1474


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

1713


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2299


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

8067


IMP-00064: Definition of LOB was truncated by export

5889


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

1885


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

2620


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

2139


NZE-28868: Peer certificate chain check failed.

2265