ORA-30371: column cannot define a level in more than one
dimension



ORA-30371: column cannot define a level in more than one dimension..

Answer / guest

Cause: A column was used in the definition of a level after
it had already been used to define a level in a different
dimension.

Action: Reorganize dimension levels and hierarchies into a
single dimension such that no column is used to define
levels in different dimensions. There is no limit on the
number of levels or hierarchies you can place in a
dimension. A column can be used to define any number of
levels provided all such levels are in the same dimension
and provided no two levels contain identical sets of columns.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00150: warning: invalid hint list, no hints loaded

1 Answers  


DRG-10301: timed out waiting for responses from servers

1 Answers  


ORA-01189: file is from a different RESETLOGS than previous files

1 Answers  


PLS-00540: object not supported in this context.

1 Answers  


DRG-50805: failed to close cursor

1 Answers  






RMAN-05009: Block Media Recovery requires Enterprise Edition

1 Answers  


PCC-02401: Host variable arrays of this type are currently not supported

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


SQL*Loader-00958: Error popping data relocation address stack

1 Answers  


ORA-32604: invalid REBUILD option

1 Answers  


ORA-14409: inserted partition key is outside specified subpartition

1 Answers  


ORA-25107: duplicate TABLESPACE option specification

1 Answers  


Categories