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-16232: adding Logical Standby skip entry for table string.string

1 Answers  


ORA-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.

1 Answers  


ORA-13115: [string]_EDGE$ table does not exist

1 Answers  


NID-00305: Datafile string - already changed

1 Answers  


ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object.

1 Answers  






ORA-01873: the leading precision of the interval is too small

1 Answers  


ORA-09741: spwat: error waiting for a post.

1 Answers  


PCB-00701: MAX OCCURRANCES must be between 1 and 65535

1 Answers  


ORA-16083: LogMiner session has not been created

1 Answers  


ORA-14625: subpartition contains rows corresponding to values being dropped

1 Answers  


ORA-10655: Segment can be shrunk

1 Answers  


ORA-37020: (XSMULTI01) Analytic workspace string is not in MULTI mode.

1 Answers  


Categories