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-12901: default temporary tablespace must be of TEMPORARY type

1 8066

ORA-12902: default temporary tablespace must be SYSTEM or of TEMPORARY type

1 4011

ORA-12910: cannot specify temporary tablespace as default tablespace

1 7134

ORA-12911: permanent tablespace cannot be temporary tablespace

1 9378

ORA-12912: Dictionary managed tablespace specified as temporary tablespace

1 3227

ORA-12913: Cannot create dictionary managed tablespace

1 5675

ORA-12914: Cannot migrate tablespace to dictionary managed type

2 3924

ORA-12915: Cannot alter dictionary managed tablespace to read write

1 3994

ORA-12916: Cannot use default permanent tablespace with this release

1 6091

ORA-12918: Invalid tablespace type for default permanent tablespace

1 4607

ORA-12919: Can not drop the default permanent tablespace

1 11738

ORA-12920: database is already in force logging mode

1 8396

ORA-12921: database is not in force logging mode

1 3586

ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 3925

ORA-12923: tablespace string is in force logging mode

1 2791

Un-Answered Questions { Database Errors }

what is new g/l functionality

2611

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

2155

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

2801

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

1966

why we are using shift key in unix shell script

3165

what is the instrument that used in Mechanical Energy??

2680

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

1708

ORA-16626: failed to enable specified object

2218

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.

2799

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

1617

NZE-28890: Entrust Login Failed

1882

IMP-00064: Definition of LOB was truncated by export

6413

ORA-26030: index string.string had string partitions made unusable due to:

1941

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

2739

ORA-26079: file "string" is not part of table string.string

1958

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