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-22923: amount of data specified in streaming LOB write is 0

1 Answers  


ORA-13118: invalid node_id [string]

1 Answers  


ORA-28168: attempted to grant password-protected role

1 Answers  


PLS-00391: undefined column 'string' in UPDATE statement

1 Answers  


DRG-10311: remote send not supported

1 Answers  


RMAN-05511: Datafile string skipped by request

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


ORA-16610: one or more resources have warnings

1 Answers  


ORA-30367: a JOIN KEY clause is required

1 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  


ORA-25101: duplicate REBUILD option specification

1 Answers  


ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

1 Answers  


Categories