ORA-42023: compatibility of AQ table must be release 8.1.x or later
Cause: An attempt was made to perform online redefinition on an AQ table that was created with compatibility prior to release 8.1.x.
Action: Ensure that the AQ table is created with the COMPATIBLE parameter set to release 8.1.x or later before attempting online redefinition.
ORA-42024
Custom Search


More Oracle errors
DIA-48242Fields that are NOT NULL can not use surrogates
ORA-16068redo log file activation identifier mismatch
ORA-38432EVALUATE operator only allowed on an expression column
ORA-32013failure in verifying parameters from the restored SPFILE
QSM-02063aggregate function in mv
PCC-00087EXEC SQL TYPE statement not allowed for this host language
ORA-02724osnpbr: cannot send break message to orapop
DIA-48184OS seek system call failure
ORA-30677session is already connected to a debugger
ORA-41643invalid attribute for the "string" element in the rule condition
ORA-33278(DBERR09) Analytic workspace string cannot be attached in RW or EXCLUSIVE mode until the changes made and updated in MULTI mode are committed or rolled back.
PCC-00026Invalid host variable "string" at line number in file string
ORA-33296(DBERR21) Analytic workspace string can only be attached RO while tablespace string is READONLY.
ORA-27469string is not a valid string attribute
PCB-00205Cannot use PIC N or PIC G variable in PL/SQL when NLS_LOCAL=YES
RMAN-06769length of password must be greater than zero
ORA-16232adding Logical Standby skip entry for table string.string
ORA-17503ksfdopn:string Failed to open file string
ORA-01142cannot end online backup - none of the files are in backup
ORA-47302error creating Role string, string




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-42023compatibility of AQ table must be release 8.1.x or later