ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
Cause: An attempt was made to use the SQL command DROP TABLE for change tables, but DROP TABLE is not supported for change tables.
Action: Use the DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE procedure instead of the DROP TABLE command.
ORA-31497
Custom Search


More Oracle errors
ORA-09712orasrv: log archiver already connected.
ORA-39143dump file "string" may be an original export dump file
ORA-54521inner ring is not inside or is touching outer ring more than once
RMAN-08599channel string: throttle time: string
RMAN-03002failure of string command at string
PCC-00024Indicator variable "string" has wrong type or length at line number in file string
PLS-00528The parameters to an ORDER function must have IN mode
ORA-25238too many recipients specified for message destination string
ORA-24357internal error while converting from to OCIDate.
ORA-19172FORG0008: both arguments to fn:dateTime have a specified timezone
ORA-14031partitioning column may not be of type LONG or LONG RAW
RMAN-06401database is already started
RMAN-06105duplicate qualifier found in LIST command: string
AMD-00118output file "string" already exists
OCI-30935XML maxoccurs value (string) exceeded
ORA-28651Primary index on IOTs can not be marked unusable
RMAN-06952database needs to be restarted
ORA-12326database string is closing immediately; no operations are permitted
ORA-30442can not find the definition for filter string
TNS-12154TNS:could not resolve the connect identifier specified




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-31496must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables