ORA-34296: (MXDCL36) A NUMBER dimension must be defined with
a fixed precision and scale, using the form
NUMBER(precision) or NUMBER(precision, scale).



ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the..

Answer / guest

Cause: The user attempted to define a NUMBER dimension
without specifying a precision. The proper format for
declaring a number dimension is NUMBER(Precision) or
NUMBER(Precision, Scale). NUMBER with no precision or scale
is not allowed.

Action: Use NUMBER(Precision) or NUMBER(Precision, Scale) to
specify the datatype of a NUMBER dimension.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00823: boundary queue pop failed

1 Answers  


ORA-37116: OLAP API table function error: (string)

1 Answers  


LPX-00230: invalid character ~1u (~2x) found in a Name or Nmtoken

1 Answers  


RMAN-00571: ===========================================================

1 Answers   HCL,


TNS-12202: TNS:internal navigation error

1 Answers  






TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


QSM-02009: non-inner join

1 Answers  


ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

1 Answers  


ORA-14518: partition contains rows corresponding to values being dropped

1 Answers  


SQL*Loader-00403: Referenced column string not present in table string.

1 Answers  


ORA-12471: Specified compartment or group is not authorized for user

1 Answers  


O2I-00126: You must specify an INTYPE file with SCHEMA_NAMES=FROM_INTYPE

1 Answers  


Categories