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-01140: cannot end online backup - all files are offline or readonly

1 3019

ORA-01141: error renaming data file string - new file 'string' not found

1 4289

ORA-01142: cannot end online backup - none of the files are in backup

1 6061

ORA-01143: cannot disable media recovery - file string needs media recovery

1 6248

ORA-01144: File size (string blocks) exceeds maximum of string blocks

2 8957

ORA-01145: offline immediate disallowed unless media recovery enabled

1 9741

ORA-01146: cannot start online backup - file string is already in backup

1 5432

ORA-01147: SYSTEM tablespace file string is offline

1 8991

ORA-01149: cannot shutdown - file string has online backup set

2 13070

ORA-01150: cannot prevent writes - file string has online backup set

1 4658

ORA-01151: use media recovery to recover block, restore backup if needed

1 5998

ORA-01152: file string was not restored from a sufficiently old backup

2 7256

ORA-01153: an incompatible media recovery is active

1 6016

ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 6764

ORA-01155: the database is being opened, closed, mounted or dismounted

1 8458

Un-Answered Questions { Database Errors }

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6721

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

2715

what is new g/l functionality

2677

IMP-00064: Definition of LOB was truncated by export

6473

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

1769

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

2668

What is SCD (Slowly Changing Dimensions)? What are its types?

2720

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.

2580

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.

2948

What is the use of NOLOCK locking hint?

1837

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

2500

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

1736

why we are using shift key in unix shell script

3237

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

8882

ORA-26084: direct path context already finished

1999

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