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-12453: label string already exists

1 Answers  


ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables

1 Answers  


LRM-00107: parameter name abbreviation 'string' is not unique

1 Answers  


ORA-12988: cannot drop column from table owned by SYS

2 Answers   eSys,


RMAN-10027: could not locate network layer context

1 Answers  






ORA-01658: unable to create INITIAL extent for segment in tablespace string

1 Answers  


ORA-31219: DBMS_LDAP: PL/SQL - Invalid LDAP notypes.

1 Answers  


PLS-00338: unable to resolve "string" as a column or row expression

1 Answers  


ORA-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero

1 Answers  


ORA-30071: conversion between datetime/interval and string fail

1 Answers  


PLS-00498: illegal use of a type before its declaration

1 Answers  


DRG-11217: INSO safe callout failed

1 Answers  


Categories