Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-01678: parameter string must be pairs of pattern and replacement strings

1 6221

ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 2763

ORA-01680: unable to extend LOB segment by string in tablespace string

1 2706

ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 2648

ORA-01682: read-only DB cannot allocate temporary space in tablespace string

1 3269

ORA-01683: unable to extend index string.string partition string by string in tablespace string

1 7174

ORA-01684: max # extents (string) reached in table string.string partition string

1 2980

ORA-01685: max # extents (string) reached in index string.string partition string

1 2712

ORA-01686: max # files (string) reached for the tablespace string

1 6411

ORA-01687: specified logging attribute for tablespace 'string' is same as the existing

1 3272

ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 7736

ORA-01689: syntax error in clause "string" of string

1 2315

ORA-01690: sort area size too small

1 9015

ORA-01691: unable to extend lob segment string.string by string in tablespace string

1 4878

ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string

1 6267


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

1200


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

2299


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2862


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

1713


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

1473






ORA-26095: unprocessed stream data exists

2803


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

3403


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

2321


[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


ORA-26084: direct path context already finished

1483


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

8067


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.

2329


NZE-28890: Entrust Login Failed

1409


NZE-28868: Peer certificate chain check failed.

2265


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

2255