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 2972

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

1 3214

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

1 4393

SQL*Loader-00817: error dropping directory object string

1 2875

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

1 3225

SQL*Loader-00821: switching to GENERATE_ONLY

1 3168

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

1 3573

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

1 2960

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

1 3264

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

1 3101

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

1 2910

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

1 3365

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

1 2965

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

1 2746

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

1 3133

Un-Answered Questions { Database Errors }

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

2855

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

3906

How to view the error log for any specific instance?

2531

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2847

What is live lock, deadlock and what is Lock escalation?

2494

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

2576

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

2170

[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

2769

mount: mount to NFS server failed: System Error: Connection timed out

3703

why we are using shift key in unix shell script

3227

write a database figure to implement the master detained relationship.

3007

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

2798

NZE-28868: Peer certificate chain check failed.

2859

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

8871

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

3435

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