ORA-22339: cannot alter to not final since its attribute column is substitutable
Cause: An attempt was made to alter a type to not final when its embedded attribute is defined as substitutable in some tables. Note, this is a restriction in 9.0 version because when a type is altered to not final, column of that type is set to not substitutable at all levels; thus, it is an error if one of its embedded attribute column is already marked substitutable.
Action: Recreate the table and specify NOT SUBSTITUTABLE AT ALL LEVELS for all columns of non final type. Then resubmit the ALTER TYPE statement.
ORA-22340
Custom Search


More Oracle errors
NZE-28790NLS string open failure
ORA-27153wait operation failed
ORA-53036An internal table for the mapping document (string) is empty.
ORA-12019master table is a synonym to a remote object
ORA-12153TNS:not connected
ORA-55315batch load attempt failed: string
ORA-08431raw data missing zero as defined in picture
ORA-23537function or procedure string is not allowed to be invoked from this site.
ORA-09841soacon: Name translation failure.
LSX-00102duplicate element "~S"
ORA-29830operator does not exist
TNS-00106Failed to open log file
IMP-00040FILESIZE does not match the value used for export: string
RMAN-06193connected to target database (not started)
ORA-13656The parameter was not found in directive string.
ORA-00028your session has been killed
PLS-00678RETURN statement not allowed inside Compound Triggers
ORA-27486insufficient privileges
TNS-01151Missing listener name, string, in LISTENER.ORA
ORA-15503cannot startup instance when procedures in "DBMS_WORKLOAD_CAPTURE" or "DBMS_WORKLOAD_REPLAY" are in the middle of their execution




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-22339cannot alter to not final since its attribute column is substitutable