ORA-34210: (MXCHGDCL18) You cannot change workspace object
to a dimension composite because one or more surrogates has
been defined for it.



ORA-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or ..

Answer / guest

Cause: The user attempted to redefine a conjoint dimension
as a composite, but the conjoint has one or more surrogates
defined. A dimension that has surrogates cannot be redefined
as a composite.

Action: Either delete all surrogates for the dimension, or
do not attempt to redefine the dimension as a composite.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  


ORA-32151: Environment not specified

1 Answers  


ORA-02757: osnfop: fork_and_bind failed

1 Answers  


DRG-11533: improper value of column string

1 Answers  


ORA-25962: join index prevents multitable insert or merge

1 Answers  


ORA-02314: illegal use of type constructor

1 Answers  


ORA-02816: Unable to kill a process

1 Answers  


DRG-12509: length of the stop word string exceeded the limit of string bytes

1 Answers  


DRG-10528: primary keys of type string are not allowed

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-01493: invalid SAMPLE size specified

1 Answers  


ORA-00234: error in identifying or opening snapshot or copy controlfile

1 Answers  


Categories