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

ORA-01298: conflicting dictionary option

1 Answers  


ORA-25472: maximum open iterators exceeded

1 Answers  


PLS-00710: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared here

1 Answers  


NID-00331: The following datafiles are disabled:

1 Answers  


ORA-26011: Cannot load type string into column string in table string

1 Answers  






PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  


KUP-04017: OS message: string

1 Answers  


ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'

1 Answers  


QSM-01042: anchor and matching join arc check failed for string

1 Answers  


RMAN-08546: channel string: autobackup found in the recovery area

1 Answers  


NNO-00053: duplicate domain description for domain "string"

1 Answers  


NZE-29046: Session is resumable.

1 Answers  


Categories