ORA-33003: (XSAGDIMDROP) workspace object, to be transformed
during data load, must be a base dimension and not otherwise
referenced in the AGGMAP.



ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimen..

Answer / guest

Cause: The user tried to specify a dimension in a
dataflow-related clause in an aggmap which is already in
another RELATION statement, DIMENSION statement, or possibly
dimensioning the AGGMAP, or they specified a composite or
conjoint dimension, or an object which is not a dimension

Action: Remove the conflicting reference or specify a valid
object

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00036: INTCTL: error reading from Navigator or Connection Manager error files

1 Answers  


RMAN-06528: CHANGE ... KEEP not supported for BACKUPPIECE

1 Answers  


ORA-02439: Unique index on a deferrable constraint is not allowed

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


ORA-31696: unable to export/import string using client specified string method

1 Answers  


RMAN-06061: WARNING: skipping archivelog compromises recoverability

1 Answers  


ORA-13910: Parameter string cannot be NULL.

1 Answers  


RMAN-07509: List of Cataloged Files

1 Answers  


ORA-13006: the specified cell number is invalid

1 Answers  


ORA-38427: attribute string does not exist

1 Answers  


ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release

1 Answers  


SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

1 Answers  


Categories