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
IMP-00061Warning: Object type "string"."string" already exists with a different identifier
RMAN-12020error on step filtered for normal output string
ORA-14610Lob attributes not specified for lob column string for subpartition string
LPX-00002out of memory
ORA-18002the specified outline does not exist
ORA-54538unexpected gtype
ORA-02855Number of requests is less than the number of slaves
RMAN-06426RECOVERY_CATALOG_OWNER role must be granted to user string
PLS-00521ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.
ORA-13793invalid comparison metric
ORA-22902CURSOR expression not allowed
ORA-01186file string failed verification tests
ORA-14455attempt to create referential integrity constraint on temporary table
ORA-14096tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
ORA-29471DBMS_SQL access denied
ORA-16569Data Guard configuration is not enabled
ORA-23309object string.string of type string exists
ORA-23447missing user parameter value
ORA-23614Script string does not exist
DRG-51023stemmer file cannot be opened




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