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-00303: Non-hex character encountered where hex char expected

1 4090

SQL*Loader-00304: Illegal combination of non-alphanumeric characters

1 9324

SQL*Loader-00305: More than one end of file character encountered

1 2822

SQL*Loader-00306: Token longer than max allowable length of number chars

1 3241

SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

1 3838

SQL*Loader-00308: %s SQL string of column string must be in double quotes.

1 2984

SQL*Loader-00309: No SQL string allowed as part of string field specification

1 9151

SQL*Loader-00350: Syntax error at line number.

1 3801

SQL*Loader-00401: End field position number must be greater than or equal to start number

1 8528

SQL*Loader-00402: Unable to determine length of column string from specification

1 3127

SQL*Loader-00403: Referenced column string not present in table string.

1 2940

SQL*Loader-00404: Column string present more than once in string's INTO TABLE block.

1 4606

SQL*Loader-00405: Need termination delim with optional enclosure delim: column string table string

1 3815

SQL*Loader-00406: If data is all generated, number to load cannot be ALL

1 8417

SQL*Loader-00407: If data is all generated, number to skip is meaningless

1 2702

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

1672

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

2151

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

2518

ORA-26027: unique index string.string partition string initially in unusable state

6741

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

3150

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2530

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

1741

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.

1645

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2633

What is Mutex error in Triggers?

3059

what is new g/l functionality

2609

IMG-02003: 2FF03 - incorrect color histogram feature specification

1704

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

1962

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

2426

write a database figure to implement the master detained relationship.

2931

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