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

DGM-16991: More than one resources have name "string".

1 Answers  


SQL*Loader-00901: Error logging on to ORACLE:

1 Answers  


ORA-08311: sllfop: bad value for maxrecsize

1 Answers  


ORA-04061: existing state of string has been invalidated

1 Answers  


ORA-27473: argument string does not exist

1 Answers  






ORA-33218: (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.

1 Answers  


RMAN-06007: target database not mounted and db_name not set in init.ora

1 Answers  


ORA-13900: missing or invalid parameter string

1 Answers  


ORA-12680: Native services disabled but required

1 Answers  


NID-00111: Oracle error reported from target database while executing string string

1 Answers  


ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-32055: invalid file type

1 Answers  


Categories