ORA-01752: cannot delete from view without exactly one key-preserved table
Cause: The deleted table had

- no key-preserved tables,

- more than one key-preserved table, or

- the key-preserved table was an unmerged view.

Action: Redefine the view or delete it from the underlying base tables.
ORA-01754
Custom Search


More Oracle errors
ORA-09804Class conversion from binary to ORACLE failed.
ORA-22620buffer size too small to hold the value
ORA-33078(XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
PGU-41020invalid CALL definition cname specified
ORA-28008invalid old password
RMAN-08023channel string: restored backup piece string
ORA-39931XML Schema string Owner: string not fully contained in the transportable set.
ORA-15084ASM disk "string" is offline and cannot be dropped.
ORA-14061data type or length of an index partitioning column may not be changed
IMP-00083dump file does not contain an incremental export
ORA-13510invalid RETENTION string, must be in the range (string, string)
LFI-01500Error condition on call to OSD function string.
ORA-02766Invalid maximum of request descriptors
ORA-14701partition-extended name or bind variable must be used for DMLs on tables partitioned by the System method
ORA-16586cannot change database property with EDIT INSTANCE command
DRG-10762index owner does not have access to procedure string
ORA-27126unable to lock shared memory segment in core
ORA-19816WARNING: Files may exist in string that are not known to database.
DIA-48180OS open system call failure
ORA-06917CMX: error in data read (too many bytes read)




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-01752cannot delete from view without exactly one key-preserved table