Oracle Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Errors Interview Questions

Questions Answers Views Company eMail

SQL*Loader-00934: Incorrect data file string specified for table string

1 2663

SQL*Loader-00935: Error verifying required option for parallel load.

1 3291

SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

1 3663

SQL*Loader-00938: partition load requested and string has enabled triggers or constraints

1 3052

SQL*Loader-00939: OCI error while string for table string partition string

1 3018

SQL*Loader-00940: UPI error while setting NCHAR bind attributes for column string table string

1 3208

SQL*Loader-00941: Error during describe of table string

1 6206

SQL*Loader-00942: partition string not part of table string

1 3065

SQL*Loader-00943: incorrect datafile string specified for table string partition string

1 2766

SQL*Loader-00944: error preparing insert statement for table string.

1 3162

SQL*Loader-00945: record size number too large for direct path

1 2755

SQL*Loader-00946: OCI error while string for table string subpartition string

1 2812

SQL*Loader-00947: subpartition load requested and string has enabled triggers or constraints

1 3506

SQL*Loader-00948: subpartition string not part of table string

1 2943

SQL*Loader-00949: incorrect datafile string specified for table string subpartition string

1 2687

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

1574

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

2689

ORA-26094: stream format error: input column overflow

2747

NZE-28868: Peer certificate chain check failed.

2749

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

2696

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

3110

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

1903

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

2112

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

1905

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

2358

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

3816

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.

2820

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

3328

NZE-28890: Entrust Login Failed

1818

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

2063

For More Un-Answered { Oracle Errors } Questions Click Here