ORA-30731: scope constraint not allowed on nested table column when the nested table is being created
Cause: An attempt was made to define a scope constraint on a nested table column when the nested table is being created.
Action: Do not specify a scope constraint on a nested table column when creating it. Instead, specify it using the ALTER TABLE statement.
ORA-30732
Custom Search


More Oracle errors
PCB-00558Invalid external datatype specified in EXEC SQL VAR statement
ORA-12430invalid privilege number
SQL*Loader-00801all INTO TABLE clauses must have the same options (string)
PLS-00203function DECODE must be called with at least 3 non-boolean arguments
PROC-00106Unidentified component error
RMAN-20045must specify FORMAT for BACKUP INCREMENTAL FROM SCN command
ORA-15078ASM diskgroup was forcibly dismounted
VID-00713internal error while parsing video data
ORA-38480creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
ORA-56722I/O request limit exceeded - call aborted
NNL-00306Server setting all statistic counters to zero
TNS-01157Can only listen on number addresses - ignoring string
PLS-00706Exception string cannot be used as prefix of a selected component
QSM-01064query has a fixed table or view
OCI-31161element or attribute "string" cannot be stored out of line
O2F-00318Error writing to the OUTTYPE file
RMAN-06551error while looking up datafile copy for file number: string
ORA-01167two files are the same file/group number or the same file
QSM-01006query rewrite disabled for this query block
ORA-16056backup control file archival requires proper syntax




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-30731scope constraint not allowed on nested table column when the nested table is being created