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-00564: illegal hexadecimal literal specified for record delimiter

1 3676

SQL*Loader-00565: unexpected error during skip .

1 3377

SQL*Loader-00566: partial record found at end of datafile

1 11857

SQL*Loader-00600: Bind size of number bytes increased to number bytes to hold 1 row.

1 3208

SQL*Loader-00601: For INSERT option, table must be empty. Error on table string

1 13562

SQL*Loader-00602: Maximum converted length number of column string is too big for bind array

1 3037

SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 2889

SQL*Loader-00604: Error occurred on an attempt to commit

1 6189

SQL*Loader-00605: Non-data dependent ORACLE error occurred -- load discontinued.

2 7263

SQL*Loader-00606: Object string in INTO TABLE clause is not a local table

1 5550

SQL*Loader-00607: partition not empty for INSERT option; table string, partition string

1 2782

SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 2739

SQL*Loader-00609: value used for ROWS parameter changed from number to number

1 13734

SQL*Loader-00620: Initial enclosure character not found

1 5760

SQL*Loader-00621: Field in data file exceeds maximum length

1 6295

Un-Answered Questions { Database Errors }

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

1633

why we are using shift key in unix shell script

3094

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.

2759

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

8768

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

2755

write a database figure to implement the master detained relationship.

2893

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

1706

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

3330

How will you Handle Error in SQL SERVER 2008?

2352

NZE-28868: Peer certificate chain check failed.

2749

ORA-26084: direct path context already finished

1888

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

1909

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

2476

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

2065

[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

2686

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