Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-24017: cannot enable enqueue on QUEUE, string is an exception queue

1 7635

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

1 4459

ORA-24019: identifier for string too long, should not be greater than string characters

1 5350

ORA-24020: Internal error in DBMS_AQ_IMPORT_INTERNAL, string

1 2743

ORA-24021: queue table definition not imported for string.string

1 3475

ORA-24022: the specified parameters has no effect on the queue

1 3034

ORA-24023: Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]

1 2461

ORA-24024: Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]

1 2507

ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 3270

ORA-24026: operation failed, queue string.string has errors

1 2670

ORA-24027: AQ HTTP propagation encountered error, status-code string, string

1 2172

ORA-24028: cannot create a reciever non-repudiable single consumer queue

1 2157

ORA-24029: operation not allowed on a single-consumer queue

1 3275

ORA-24030: Only one of rule or rule-set must be specified

1 2480

ORA-24031: invalid value, string should be non-NULL

1 2824


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

1711


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2325


NZE-28868: Peer certificate chain check failed.

2263


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

1376


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2317






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

1286


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

2313


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

1199


ORA-16626: failed to enable specified object

1771


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

2252


NZE-28890: Entrust Login Failed

1409


ORA-26094: stream format error: input column overflow

2250


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

1881


ORA-26084: direct path context already finished

1483


[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

2287