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-22279: cannot perform operation with LOB buffering enabled

1 3330

ORA-22280: no more buffers available for operation

1 2861

ORA-22281: cannot perform operation with an updated locator

1 4632

ORA-22282: non-contiguous append to a buffering enabled LOB not allowed

1 3087

ORA-22283: filename contains characters that refer to parent directory

1 3543

ORA-22285: non-existent directory or file for string operation

1 3782

ORA-22286: insufficient privileges on file or directory to perform string operation

1 6402

ORA-22287: invalid or modified directory occurred during string operation

1 3349

ORA-22288: file or LOB operation string failed string

1 5900

ORA-22289: cannot perform string operation on an unopened file or LOB

Virtusa,

1 11479

ORA-22290: operation would exceed the maximum number of opened files or LOBs

1 6694

ORA-22291: Open LOBs exist at transaction commit time

1 4668

ORA-22292: Cannot open a LOB in read-write mode without a transaction

1 3978

ORA-22293: LOB already opened in the same transaction

1 8716

ORA-22294: cannot update a LOB opened in read-only mode

1 3223

Un-Answered Questions { Database Errors }

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

2457

What severity level errors are managed in TRY-CATCH block?

2225

[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

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

ORA-26027: unique index string.string partition string initially in unusable state

6747

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

2666

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

1683

hp asking for replication floppy to do reinstall 25254 server assistant

2886

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

8820

IMP-00064: Definition of LOB was truncated by export

6415

ORA-16626: failed to enable specified object

2218

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

2155

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

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

2213

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