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-01774: Dump undo option specified more than once

1 3440

ORA-01776: cannot modify more than one base table through a join view

1 9101

ORA-01779: cannot modify a column which maps to a non key-preserved table

1 7238

ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 3360

ORA-01782: UNRECOVERABLE cannot be specified for a cluster or clustered table

1 3284

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

1 3356

ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

1 3382

ORA-01792: maximum number of columns in a table or view is 1000

1 4788

ORA-01799: a column may not be outer-joined to a subquery

1 8873

ORA-01804: failure to initialize timezone information

2 18373

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

2 7688

ORA-01854: julian date must be between 1 and 5373484

1 12030

ORA-01858: a non-numeric character was found where a numeric was expected

1 5542

ORA-01859: a non-alphabetic character was found where an alphabetic was expected

1 3140

ORA-01861: literal does not match format string

1 6806

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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

6747

NZE-28890: Entrust Login Failed

1882

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

[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

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

1747

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2805

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

3993

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

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

8820

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

1710

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

2410

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

2733

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

3385

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

2155

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2232

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