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-29882: insufficient privileges to execute indextype

1 Answers  


NNO-00625: overriding auto-refresh of name "string", type "string", refresh in number seconds

1 Answers  


PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

1 Answers  


RMAN-20030: resync in progress

1 Answers  


ORA-06956: Failed to get local host name

1 Answers  






ORA-29871: invalid alter option for a domain index

1 Answers  


RMAN-06178: datafile number not processed because file is offline

1 Answers  


ORA-27015: skgfcls: failed to close the file

1 Answers  


TNS-00043: The CMANAGER has active connections, do you still want to stop it (y/n)?

1 Answers  


ORA-02029: missing FILE keyword

1 Answers  


ORA-07562: sldext: extension must be 3 characters

1 Answers  


NNL-00271: Default domain is now "string"

1 Answers  


Categories