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

NZE-28814: Cannot convert a number in Oracle format to native format.

1 Answers  


RMAN-20504: corruption list not found in recovery catalog

1 Answers  


TNS-12647: Authentication required

1 Answers  


RMAN-06008: connected to recovery catalog database

1 Answers  


PCC-02418: Array size mismatch between Object and REF host variables

1 Answers  


NNL-00530: quit|exit : exit the names control program

1 Answers  


NNL-00353: Not allowed

1 Answers  


TNS-00237: Failed to refuse connection

1 Answers  


ORA-00166: remote/local nesting level is too deep

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  


ORA-22977: missing or invalid attribute

1 Answers  


ORA-30360: REF not supported with query rewrite

1 Answers  


Categories