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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.

1 2860

ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated

1 2671

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

1 3683

ORA-33332: (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.

1 2782

ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.

1 2992

ORA-33338: (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.

1 3281

ORA-33425: (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.

1 2877

ORA-33427: (EIFMAKEF16) CAUTION: NTEXT object workspace object will be exported with type TEXT.

1 2744

ORA-33429: (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.

1 2808

ORA-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.

1 2935

ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.

1 2749

ORA-33447: (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.

1 3085

ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.

1 3162

ORA-33449: (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.

1 2733

ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.

1 3618

Un-Answered Questions { Database Errors }

ORA-26084: direct path context already finished

1994

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

2028

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

2494

what is the instrument that used in Mechanical Energy??

2731

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

2658

NZE-28868: Peer certificate chain check failed.

2860

NZE-28890: Entrust Login Failed

1916

When do you get "getwmicomexception"?

2731

2798

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

1727

ORA-26095: unprocessed stream data exists

3633

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2517

why we are using shift key in unix shell script

3227

How will you Handle Error in SQL SERVER 2008?

2439

IMP-00064: Definition of LOB was truncated by export

6464

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