ORA-02440: Create as select with referential constraints not
allowed



ORA-02440: Create as select with referential constraints not allowed..

Answer / guest

Cause: create table foo (... ref. con. ...) as select ...;

Action: Create the table as select, then alter the table to
add the constraints afterwards.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NPL-00313: requested form string does not match actual form string

1 Answers  


PLS-01701: Illegal syntax in ROLLBACK WORK statement

1 Answers  


RMAN-06432: recovery catalog dropped

1 Answers  


ORA-30156: Out of disk space

1 Answers  


ORA-26053: Row was not loaded due to conversion error.

1 Answers  






ORA-32153: Environment not specified

1 Answers  


ORA-16194: Modifying DB_UNIQUE_NAME requires SID='*' qualifier

1 Answers  


CLSR-01006: Unable to process instance shutdown

1 Answers  


ORA-22800: invalid user-defined type

1 Answers  


RMAN-06525: RMAN retention policy is set to none

1 Answers  


LPX-00001: NULL pointer

1 Answers  


QSM-02063: aggregate function in mv

1 Answers  


Categories