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-01586: database must be mounted EXCLUSIVE and not open for this operation

1 7321

ORA-01588: must use RESETLOGS option for database open

1 5636

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

3 21113

ORA-01590: number of segment free list (string) exceeds maximum of string

1 3239

ORA-01591: lock held by in-doubt distributed transaction string

1 3992

ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 3200

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 3308

ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

1 3632

ORA-01595: error freeing extent (string) of rollback segment (string))

1 5419

ORA-01596: cannot specify system in string parameter

1 3105

ORA-01597: cannot alter system rollback segment online or offline

1 4868

ORA-01598: rollback segment 'string' is not online

1 3920

ORA-01599: failed to acquire rollback segment (string), cache space is full

1 3975

ORA-01600: at most one "string" in clause "string" of string

1 2719

ORA-01601: illegal bucket size in clause "string" of string

1 3142

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

ORA-26095: unprocessed stream data exists

3642

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

4042

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2867

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

2758

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

2235

NZE-28890: Entrust Login Failed

1932

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

6794

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

1669

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

3440

IMP-00070: Lob definitions in dump file are inconsistent with database.

1801

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

3229

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

1823

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.

2948

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

1990

NZE-28868: Peer certificate chain check failed.

2868

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