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

RMAN-06026: some targets not found - aborting restore

1 Answers  


ORA-36990: (XSRELGID07) %a workspace object The level relation %1p should be dimensioned by a level dimension.

1 Answers  


RMAN-06500: skipping backupset key string; already backed up string time(s)

1 Answers  


ORA-02308: invalid option string for object type column

1 Answers  


PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

1 Answers  






QSM-02037: cannot evaluate constant expression at compile time

1 Answers  


RMAN-06498: skipping datafile string; already backed up string time(s)

1 Answers  


ORA-13200: internal error [string] in spatial indexing.

1 Answers  


ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.

1 Answers  


ORA-31099: XDB Security Internal Error

1 Answers  


RMAN-08059: media recovery failed

1 Answers  


ORA-07759: slemtr: invalid destination

1 Answers  


Categories