ORA-30341: dropped level has references
Cause: An attempt was made to drop a level using the default or RESTRICT option in a dimension while references to that level remain in the dimension. References can occur in hierarchies and attributes within the dimension.
Action: First remove any referenes to the level prior to dropping it, or specify the CASCADE option with the DROP LEVEL clause.
ORA-30342
Custom Search


More Oracle errors
DRG-11127inconsistent index policy with trained rule
DRG-10501invalid stopword: string
ORA-42002partition "string" of table "string"."string" not being redefined
ORA-15083failed to communicate with ASMB background process
KUP-04030invalid numeric data
DGM-16900Unable to initialize client
AMD-00112PROCEDURE string, invalid mode
RMAN-06721could not normalize path for file: "string"
ORA-38620DT expressions in input cursor do not have an alias name
ORA-30680debugger connection handshake failed
PLS-00509Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field
TNS-00251Failure in nstest:
ORA-39040Schema expression "string" must identify exactly one schema.
QSM-01021materialized view, string, not found in the hint list
ORA-31439subscription is already active
ORA-23494too many rows for destination "string"
TNS-04086Invalid value for the event string.
ORA-13974string with name "string" already exists
ORA-54017UPDATE operation disallowed on virtual columns
ORA-36018(XSHIERCK02) The format of the HIERCHECK command is: HIERCHECK relation [STATUS|NOSTATUS|valueset] [MULTIPATH] [CONSISTENT] [BALANCED levelrelation] Or HIERCHECK aggmap [MULTIPATH] [CONSISTENT]




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-30341dropped level has references