Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-16167: LGWR network server could not switch to non-blocking mode

1 Answers  


SQL*Loader-00522: lfiopn failed for file (string)

1 Answers  


ORA-15026: disk 'string' is not an ASM disk

1 Answers  


ORA-25409: failover happened during the network operation,cannot continue

1 Answers  


ORA-25329: AQ array operations not allowed on 8.0 queues

1 Answers  






ORA-09910: Unable to find ORACLE password file entry for user.

2 Answers  


ORA-06020: NETASY: initialisation failure

1 Answers  


RMAN-06106: this command requires that target database be mounted

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


TNS-12236: TNS:protocol support not loaded

1 Answers  


SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads

1 Answers  


ORA-27001: unsupported device type

1 Answers  






Categories