Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Oracle Errors Interview Questions
Questions Answers Views Company eMail

ORA-02449: unique/primary keys in table referenced by foreign keys

1 3260

ORA-02450: Invalid hash option - missing keyword IS

1 2103

ORA-02451: duplicate HASHKEYS specification

1 1818

ORA-02452: invalid HASHKEYS option value

1 2176

ORA-02453: duplicate HASH IS specification

1 1917

ORA-02454: Number of hash keys per block (string) exceeds maximum of string

1 2140

ORA-02455: The number of cluster key column must be 1

1 2034

ORA-02456: The HASH IS column specification must be NUMBER(*,0)

1 1983

ORA-02457: The HASH IS option must specify a valid column

1 1828

ORA-02458: HASHKEYS must be specified for a HASH CLUSTER

1 1800

ORA-02459: Hashkey value must be a positive integer

1 1745

ORA-02460: Inappropriate index operation on a hash cluster

1 2221

ORA-02461: Inappropriate use of the INDEX option

1 2920

ORA-02462: Duplicate INDEX option specified

1 2085

ORA-02463: Duplicate HASH IS option specified

1 1765

Post New Oracle Errors Questions

Un-Answered Questions { Oracle Errors }

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


ORA-26094: stream format error: input column overflow


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


IMP-00064: Definition of LOB was truncated by export


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.


NZE-28890: Entrust Login Failed


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


ORA-26095: unprocessed stream data exists


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


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


[ERROR] [main 11:01:20] ( Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] ( ORA-02275: such a referential constraint already exists in the table


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


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


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


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?