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

ORA-29290: invalid offset specified for seek

1 Answers  


RMAN-06431: recovery catalog created

1 Answers  


QSM-00518: Java is not enabled. Please execute INITJVM.SQL and INITQSMA.SQL

1 Answers  


ORA-40219: apply result table string is incompatible with current operation

1 Answers  


DGM-16948: Can not proceed to switchover. Primary is still "string".

1 Answers  






ORA-16114: applying DDL transaction with commit SCN string

1 Answers  


ORA-10640: Operation not permitted during SYSTEM tablespace migration

1 Answers  


ORA-26710: incompatible version marker encountered during Capture

1 Answers  


RMAN-08102: channel string: located backup piece: string

1 Answers  


LPX-00019: property "~s" unknown

1 Answers  


ORA-30084: invalid data type for datetime primary with time zone modifier

1 Answers  


ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

1 Answers   Oracle,


Categories