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-00501: Unable to read file (string)

1 3129

SQL*Loader-00502: unable to open data file 'string' for field string table string

1 3064

SQL*Loader-00503: Error appending extension to file (string)

1 10299

SQL*Loader-00504: Error skipping records in file (string)

1 2856

SQL*Loader-00505: error reading LOBFILE

1 2893

SQL*Loader-00506: formatting error reading SDF or LOBFILE string for column string in table string

1 3284

SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

1 3203

SQL*Loader-00508: record formating error in data file string

1 2960

SQL*Loader-00509: System error: string

1 3244

SQL*Loader-00510: Physical record in data file (string) is longer than the maximum(number)

1 5634

SQL*Loader-00511: Unable to initialize read functions

1 2941

SQL*Loader-00512: Unable to free read buffer

1 3256

SQL*Loader-00513: Unable to close file (string)

1 2738

SQL*Loader-00514: Error getting elapsed time

1 2567

SQL*Loader-00515: Error getting CPU time

1 3535

Un-Answered Questions { Database Errors }

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

1620

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

2410

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2805

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

3171

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

2643

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

2658

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

2434

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

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2705

what is the instrument that used in Mechanical Energy??

2683

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

NZE-28868: Peer certificate chain check failed.

2803

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.

2870

How will you Handle Error in SQL SERVER 2008?

2403

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

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