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-02404: specified plan table not found

2 7699

ORA-02420: missing schema authorization clause

1 13061

ORA-02421: missing or invalid schema authorization identifier

1 10348

ORA-02422: missing or invalid schema element

1 5625

ORA-02423: schema name does not match schema authorization identifier

1 3275

ORA-02424: potential circular view references or unknown referenced tables

1 3102

ORA-02425: create table failed

1 3855

ORA-02426: privilege grant failed

1 3002

ORA-02427: create view failed

1 3702

ORA-02428: could not add foreign key reference

1 3126

ORA-02429: cannot drop index used for enforcement of unique/primary key

1 8202

ORA-02430: cannot enable constraint (string) - no such constraint

1 7462

ORA-02431: cannot disable constraint (string) - no such constraint

1 13559

ORA-02432: cannot enable primary key - primary key not defined for table

1 4046

ORA-02433: cannot disable primary key - primary key not defined for table

1 4585

Un-Answered Questions { Database Errors }

ORA-26095: unprocessed stream data exists

3638

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.

2575

When do you get "getwmicomexception"?

2731

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

2696

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

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

3225

NZE-28890: Entrust Login Failed

1924

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

1731

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

2299

IMP-00064: Definition of LOB was truncated by export

6465

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

2253

[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

2775

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

2177

write a database figure to implement the master detained relationship.

3009

ORA-26028: index string.string initially in unusable state

3914

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