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 |
ORA-01501: CREATE DATABASE failed
ORA-22316: input type is not a collection type
ORA-02247: no option specified for ALTER SESSION
ORA-01279: db_files too large
ORA-06109: NETTCP: message receive failure
PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header
ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"
DRG-50910: max documents requested string outside valid range 1 to 65535
ORA-38489: predicate table creation failed due to: ORAstring
ORA-23448: duplicate user parameter value
ORA-01970: You must specify a database name for CREATE CONTROLFILE
ORA-10563: Test recovery had to corrupt data block (file# string, block# string) in order to proceed