ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace obj

ORA-33922: (MAKEDCL35) You cannot define a surrogate of
dimension workspace object because it is a time dimension.

Question Posted / guest

1 Answers
3253 Views
I also Faced
E-Mail Answers

ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a ..

Answer / guest

Cause: The user attemped to define a surrogate on a
dimension that has type DAY, WEEK, MONTH, or YEAR.

Action: Do not attempt to define a surrogate on this 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-31057: Display Name of the element being inserted is null

1 Answers

ORA-17508: I/O request buffer ptr is not alligned

1 Answers

ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.

1 Answers

ORA-30054: invalid upper limit snapshot expression

1 Answers

ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.

1 Answers

ORA-02799: Unable to arm signal handler

1 Answers

ORA-02833: Server was unable to close file

1 Answers

DRG-10102: mandatory argument missing: string

1 Answers

ORA-31428: no publication contains all the specified columns

1 Answers

ORA-22860: object type expected

1 Answers

ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

1 Answers

SQL-02119: Invalid HSTDEF argument

1 Answers

For more Oracle Errors Interview Questions Click Here