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-22868: table with LOBs contains segments in different tablespaces

1 9285

ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 3004

ORA-22870: ALTER TYPE with REPLACE option a non-object type

1 3192

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 2937

ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

1 2903

ORA-22873: primary key not specified for primary key based object table

1 2870

ORA-22874: attribute "string" is not part of the type "string"

1 2915

ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

1 2932

ORA-22876: this user-defined type is not allowed or it cannot be used in this context

1 2950

ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column

1 5430

ORA-22878: duplicate LOB partition or subpartition specified

1 3297

ORA-22879: cannot use the LOB INDEX clause for partitioned tables

1 7727

ORA-22880: invalid REF

1 2908

ORA-22881: dangling REF

1 7970

ORA-22882: object creation failed

1 3110

Un-Answered Questions { Database Errors }

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

2741

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2231

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2731

ORA-26032: index string.string loading aborted after string keys

2107

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

2155

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

1710

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

2804

ORA-26095: unprocessed stream data exists

3573

When do you get "getwmicomexception"?

2682

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

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

2434

write a database figure to implement the master detained relationship.

2936

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

2665

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.

1652

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

1620

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