ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string

Cause: User specified a dimension composite, conjoint, or partition template in a place where that kind of dimension is not allowed. For instance, a relation cannot be dimensioned by a composite, and only a variable can dimensioned by a partition template

Action: Usually, the offending dimension can be replaced with its bases. For instance, a relation cannot be dimensioned by a a composite of PRODUCT and GEOG, but it can be dimensioned by both PRODUCT and GEOG instead

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34279: (MXDCL37) CONCAT can only be used when defining a DIMENSION

Cause: The CONCAT keyword was used incorrectly

Action: Retry the command without the CONCAT keyword

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension

Cause: The user attempted to use NUMBER(Precision) or NUMBER(Precision, Scale) as the datatype in a definition for some object other than a DIMENSION or VARIABLE, such as a FORMULA or PROGRAM. This error can also be produced in cases where a NUMBER data type is not allowed at all

Action: Use the NUMBER type without specifying a precision or scale. If a NUMBER data type is not allowed at all, this fix will only change the exception message to something more specific

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34260: (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead

Cause: The user attempted to use a COMPOSITE in the dimension list of an object that does not allow for such dimensions

Action: Use the base dimensions of the COMPOSITE in the dimension list

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE

Cause: User supplied the COMPRESSED keyword when defining an object that was not a COMPOSITE

Action: If the intent is to create a compressed composite, make sure that the object type is COMPOSITE. Otherwise, remove the COMPRESSED keyword from the command string and rerun

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34183: (MXCHGDCL22) Partition number already exists

Cause: User attempted to ADD a partition that already existed to a partitioned variable

Action: None required - the partition already exists

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE

Cause: User specified an object that is not a partitioned variable in a place where a partitioned variable is required

Action: Supply the name of a partitioned variable

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34179: (MXCHGDCL20) workspace object is not a PARTITION TEMPLATE

Cause: User specified an object that is not a partition template where a partition template is required

Action: Supply the name of a partition template

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it

Cause: User attempted to CHGDFN DELETE a partition template, but some partitioned variable had data in the partition specified for deletion

Action: Drop the partitions that are causing the problem, then retry

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/