Oracle Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle Errors Interview Questions

Questions Answers Views Company eMail

ORA-30735: cannot create multiple subtables of the same type under a supertable

1 2736

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

1 2813

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

1 2731

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

1 2837

ORA-30739: cannot drop a table that has subtables

2 3588

ORA-30740: cannot grant UNDER privilege on this object

1 3927

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

1 3474

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

1 5317

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

1 3186

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

1 3045

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

1 3261

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

1 3111

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

1 2673

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

1 2751

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

1 2975

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

2155

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

3993

ORA-26030: index string.string had string partitions made unusable due to:

1941

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

3171

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

8820

ORA-26095: unprocessed stream data exists

3578

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

6747

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.

2870

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3385

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

2107

ORA-26094: stream format error: input column overflow

2808

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

ORA-26084: direct path context already finished

1949

IMP-00064: Definition of LOB was truncated by export

6415

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2705

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