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-24019: identifier for string too long, should not be greater than string characters

1 Answers  


NZE-29195: CRL is expired

1 Answers  


PCC-02040: CMD-LINE: Option selected, but no value provided

1 Answers  


PLS-00902: A READ-ONLY bind variable used in OUT or IN-OUT context

1 Answers  


ORA-01952: system privileges not granted to 'string'

1 Answers  






ORA-16012: Archive log standby database identifier mismatch

1 Answers  


ORA-01324: cannot add file string due to DB_ID mismatch

1 Answers  


ORA-24000: invalid value string, string should be of the form [SCHEMA.]NAME

1 Answers  


ORA-25230: invalid value string, WAIT should be non-negative

1 Answers  


KUP-04043: table column not found in external source: string

1 Answers  


NNL-01070: System parameter file name: string

1 Answers  


TNS-04050: Invalid specification for gateway ID.

1 Answers  


Categories