ORA-02440: Create as select with referential constraints not allowed
Cause: create table foo (... ref. con. ...) as select ...;
Action: Create the table as select, then alter the table to add the constraints afterwards.
ORA-02441
Custom Search


More Oracle errors
PGU-00136bad variable specification
DIA-48433Unknown help topic
ORA-24503codepoint length overflows for piecewise operation
ORA-07214slgunm: uname error, unable to get system information.
ORA-46102Privilege string aggregated in security class string is not found
ORA-22928invalid privilege on directories
CLSR-00517Failed to register a service name
ORA-00209control file blocksize mismatch, check alert log for more info
ORA-32135Cannot assign FILEs
RMAN-06743specification does not match any backup set in the repository
ORA-19643datafile string: incremental-start SCN is too recent
ORA-13603The specified parameter string cannot be fetched as a numeric value for task or object string.
ORA-25472maximum open iterators exceeded
ORA-42006dependent object registration not supported during a partition redefinition
RMAN-04031initialization parameters used for automatic instance: string
ORA-27465invalid value string for attribute string
ORA-32346ON COMMIT materialized view refresh caused changes to the master table/materialized view
ORA-12023missing index on materialized view "string"."string"
ORA-26010Column string in table string is NOT NULL and is not being loaded
ORA-02045too many local sessions participating in global transaction




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-02440Create as select with referential constraints not allowed