Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-01487: packed decimal number too large for supplied buffer

1 3649

ORA-01488: invalid nibble or byte in the input data

1 7642

ORA-01489: result of string concatenation is too long

1 7379

ORA-01490: invalid ANALYZE command

1 8808

ORA-01491: CASCADE option not valid

1 2381

ORA-01492: LIST option not valid

1 2186

ORA-01493: invalid SAMPLE size specified

1 3592

ORA-01494: invalid SIZE specified

1 2186

ORA-01495: specified chain row table not found

1 5232

ORA-01496: specified chain row table form incorrect

1 3750

ORA-01497: illegal option for ANALYZE CLUSTER

1 2370

ORA-09870: spini: failure initializing maximum number of open files.

1 1792

ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 2259

ORA-09872: TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.

1 1995

ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.

1 2642


Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

1237


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

1883


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

1472


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

1653


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

1286






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

1520


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

2255


[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-26028: index string.string initially in unusable state

3400


ORA-26094: stream format error: input column overflow

2252


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

8065


ORA-26084: direct path context already finished

1483


ORA-16627: No standby databases support the overall protection mode.

3556


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

2299