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-30735: cannot create multiple subtables of the same type under a supertable

1 2748

ORA-30736: objects in a table or view hierarchy have to be in the same schema

1 2828

ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

1 2746

ORA-30738: object "string" does not exist in schema "string"

1 2848

ORA-30739: cannot drop a table that has subtables

2 3619

ORA-30740: cannot grant UNDER privilege on this object

1 3952

ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege

1 3501

ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 5338

ORA-30743: "string" is not an object view

1 3218

ORA-30744: "string" is not an object table

1 3063

ORA-30745: error occured while trying to add column "string" in table "string"

1 3292

ORA-30746: error occured while trying to drop column "string" in table "string"

1 3128

ORA-30747: cannot create substitutable tables or columns of non final type string.string

1 2694

ORA-30748: column string already enabled to store objects of type string.string

1 2779

ORA-30749: column string not enabled to store objects of type string.string

1 2994

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3085

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

2167

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

1630

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

1698

What is the use of NOLOCK locking hint?

1800

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

1785

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

2127

ORA-26094: stream format error: input column overflow

2825

what is new g/l functionality

2633

hp asking for replication floppy to do reinstall 25254 server assistant

2906

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

2661

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

8835

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?

2735

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.

2555

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2890

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