Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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.