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-07327: smpdal: attempt to destroy pga when it was not mapped.

1 3114

ORA-07339: spcre: maximum number of semaphore sets exceeded.

1 3049

ORA-07345: The datafile name must not contain the string '..'.

1 5537

ORA-07346: slnrm: normalized file name is too long

1 3351

ORA-07390: sftopn: translate error, unable to translate file name.

1 3599

ORA-07391: sftopn: fopen error, unable to open text file.

3 19270

ORA-07392: sftcls: fclose error, unable to close text file.

1 7353

ORA-07393: unable to delete text file

1 3451

ORA-07394: unable to append string to text file

1 2937

ORA-07400: slemtr: translated name for the message file is too long.

1 3117

ORA-07401: sptrap: cannot restore user exception handlers.

1 3054

ORA-07402: sprst: cannot restore user signal handler.

1 2776

ORA-07403: sfanfy: db_writers parameter not valid.

1 2751

ORA-07404: sfareq: Timeout occurred waiting for request to complete.

1 2687

ORA-07406: slbtpd: invalid number.

1 3128

Un-Answered Questions { Database Errors }

When do you get "getwmicomexception"?

2682

ORA-16627: No standby databases support the overall protection mode.

3993

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.

2539

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

1710

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

3169

hp asking for replication floppy to do reinstall 25254 server assistant

2886

why we are using shift key in unix shell script

3167

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

1681

[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

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

2643

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2723

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

1620

What is Mutex error in Triggers?

3069

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2733

RMAN-05017: no copy of datafile number found to recover

2410

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