PLS-00506: User Defined Constrained Subtypes are disallowed
Cause: An attempt was made to define a constrained subtype, but only unconstrained subtypes are allowed in this release of PL/SQL. For example, the following type definition is illegal: SUBTYPE Acronym IS VARCHAR2(5); -- illegal
Action: Remove the illegal type constraint.
PLS-00507
Custom Search


More Oracle errors
ORA-19773must specify change tracking file name
ORA-30567name already used by an existing log group
ORA-27469string is not a valid string attribute
ORA-02259duplicate UNIQUE/PRIMARY KEY specifications
ORA-38420invalid stored attribute sub-expression: string
ORA-30389the source statement is not compatible with the destination statement
ORA-10644SYSTEM tablespace cannot be default temporary tablespace
PLS-00510Float cannot have scale
ORA-09870spini: failure initializing maximum number of open files.
ORA-39024wrong schema specified for job
ORA-40201invalid input parameter string
QSM-01031materialized view, string, is stale in TRUSTED integrity mode
ORA-01666control file is for a standby database
ORA-02443Cannot drop constraint - nonexistent constraint
ORA-38487FUNCTION/PACKAGE/TYPE "string" not allowed in the expression
ORA-23497repgroup name cannot be null
ORA-02427create view failed
ORA-01655unable to extend cluster string.string by string in tablespace string
NCR-03006NCRO: Invalid operation
ORA-07843sllfcl: LIB$FREE_VM failure




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
PLS-00506User Defined Constrained Subtypes are disallowed