Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-22868: table with LOBs contains segments in different tablespaces

1 7234

ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 1725

ORA-22870: ALTER TYPE with REPLACE option a non-object type

1 1960

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 1744

ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

1 1619

ORA-22873: primary key not specified for primary key based object table

1 1645

ORA-22874: attribute "string" is not part of the type "string"

1 1659

ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

1 1595

ORA-22876: this user-defined type is not allowed or it cannot be used in this context

1 1669

ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column

1 3935

ORA-22878: duplicate LOB partition or subpartition specified

1 1890

ORA-22879: cannot use the LOB INDEX clause for partitioned tables

1 6115

ORA-22880: invalid REF

1 1561

ORA-22881: dangling REF

1 5782

ORA-22882: object creation failed

1 1705


Post New Oracle Errors Questions






Un-Answered Questions { Oracle Errors }

ORA-26095: unprocessed stream data exists

2128


NZE-28868: Peer certificate chain check failed.

1822


ORA-26079: file "string" is not part of table string.string

1110


ORA-16626: failed to enable specified object

1271


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

842






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

1845


ORA-26028: index string.string initially in unusable state

2829


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

6644


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

1331


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1368


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

1817


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

1875


ORA-26032: index string.string loading aborted after string keys

1179


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

1751


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

1017