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

Database Errors Interview Questions

Questions Answers Views Company eMail

SQL*Loader-00812: error creating internal table: string

1 2917

SQL*Loader-00813: error dropping internal table: string

1 3132

SQL*Loader-00816: error creating temporary directory object string for file string

1 4306

SQL*Loader-00817: error dropping directory object string

1 2821

SQL*Loader-00820: cannot create where clause with range for table string

1 3160

SQL*Loader-00821: switching to GENERATE_ONLY

1 3092

SQL*Loader-00822: operation not supported on external organized table

1 3509

SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables

1 2885

SQL*Loader-00901: Error logging on to ORACLE:

1 3196

SQL*Loader-00902: Error opening cursor: [number]

1 3048

SQL*Loader-00903: Database must be at least version number.number.number.number.number for direct path

1 2833

SQL*Loader-00904: You cannot used the direct path when linked with v5 of the database

1 3283

SQL*Loader-00905: Error parsing SQL statement for upi: [number]

1 2905

SQL*Loader-00906: Error executing SQL statement for upi: [number]

1 2689

SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used

1 3064

Un-Answered Questions { Database Errors }

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

3993

How to view the error log for any specific instance?

2486

what is the instrument that used in Mechanical Energy??

2683

What is SCD (Slowly Changing Dimensions)? What are its types?

2666

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1683

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1656

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

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

2107

NZE-28868: Peer certificate chain check failed.

2803

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2213

What is Mutex error in Triggers?

3071

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

8820

What is the meaning of lock escalation and why/how to stop this?

2658

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

2742

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

1620

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