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-30029: no active undo tablespace assigned to instance

1 Answers  


LFI-01508: access() failed.

1 Answers  


PCC-02354: A file included with #include may not contain SQL statements

1 Answers  


ORA-23432: master site string already exists

1 Answers  


ORA-01125: cannot disable media recovery - file string has online backup set

1 Answers  






RMAN-06146: changes found for file number beyond offline SCN

1 Answers  


ORA-13191: failed to read SDO_ORDCNT value

1 Answers  


PCB-00204: Group items cannot be used except in INTO or VALUES clause

1 Answers  


ORA-13190: recursive SQL fetch failed

1 Answers  


ORA-13192: failed to read number of element rows

1 Answers  


QSM-01081: no primary key or row id found for table, string, in MV, string

1 Answers  


EXP-00024: Export views not installed, please notify your DBA

1 Answers  


Categories