ORA-30341: dropped level has references



ORA-30341: dropped level has references..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-03278: duplicate ALLOCATE EXTENT option specification

1 Answers  


ORA-13829: SQL profile named string already exists

1 Answers  


PROT-00707: Cluster registry integrity check failed

1 Answers  


ORA-32126: Cannot perform operations on a null REF

1 Answers  


ORA-32008: error while processing parameter update at instance string

1 Answers  






LPX-00017: ~1sNodeName: <~2S>

1 Answers  


RMAN-06601: new RMAN configuration parameters:

1 Answers  


ORA-24185: Transformation string.string, does not exist

1 Answers  


PLS-01714: ANSI expects a column name not a literal value here

1 Answers  


ORA-24354: number fetched too large to fit in COBOL display type buffer.

1 Answers  


TNS-01074: Error listening on: string

1 Answers  


ORA-28181: proxy 'string' failed to enable one or more of the specified initial roles for client 'string'

1 Answers  


Categories