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

ORA-29517: recursive resolution failed for a referenced class

1 Answers  


ORA-30011: Error simulated: psite=string, ptype=string

1 Answers  


ORA-03132: two-task default value overflow

1 Answers  


ORA-23343: no match for specified conflict resolution information

1 Answers  


DRG-10853: Catsearch does not support this operator

1 Answers  






QSM-02033: no filter conditions are present in the WHERE clause

1 Answers  


ORA-01426: numeric overflow

1 Answers  


ORA-14157: invalid subpartition name

1 Answers  


ORA-30552: The package/procedure/function cannot be changed

1 Answers  


ORA-16150: FINISH recovery performed on another, older standby database

1 Answers  


RMAN-06190: PL/SQL package string.string version string in string database is not current

1 Answers  


ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page

1 Answers  


Categories