1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category
Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-08109: nosort is not a supported option for online index build

 1 3029

ORA-08111: a partitioned index may not be coalesced as a whole

 1 3155

ORA-08112: a composite partition may not be coalesced as a whole

 1 2449

ORA-08113: composite partition index may not be compressed

 1 2453

ORA-08114: can not alter a fake index

 1 5566

ORA-08115: can not online create/rebuild this index type

 1 4386

ORA-08116: can not acquire dml enough lock(S mode) for online index build

 1 3434

ORA-08117: Index Organized Table operation released its block pin

 1 2601

ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)

 1 2121

ORA-08119: The new initrans will make the index too big

 1 2550

ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

 1 4071

ORA-08175: discrete transaction restriction violated (string)

 1 3388

ORA-08176: consistent read failure; rollback data not available

 1 9600

ORA-08177: can't serialize access for this transaction

 1 3293

ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

 1 6351

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

NZE-28868: Peer certificate chain check failed.

2267

ORA-26076: cannot set or reset value after direct path structure is allocated

1480

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

2862

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

6165

ORA-26094: stream format error: input column overflow

2256




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

1889

IMP-00064: Definition of LOB was truncated by export

5893

[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

2292

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.

2331

ORA-26084: direct path context already finished

1488

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

2321

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

1203

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

2306

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?

2317

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

8075

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