ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be
resynced without modified object workspace object because
they share a modified composite dimension.



ORA-37027: (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object works..

Answer / guest

Cause: When one resyncs an object that is dimensioned by a
composite dimension, the composite dimension is resynced
automatically, dropping all new tuples. This cannot be done,
however, if the automatic resync of the composite dimension
might cause data in an object that shares the composite
dimension to become NA.

Action: Resync both objects together. ALternatively, you can
try to acquire the other object (that will ensure that the
composite dimension is locked in the latest generation and
will not be resynced when resyncning the first object),
resync the first object, and release the other object.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00400: DBNEWID - Completed with errors.

1 Answers  


ORA-21526: initialization failed

1 Answers  


RMAN-12000: execution layer initialization failed

1 Answers  


TNS-01181: Internal registration connection limit reached

1 Answers  


ORA-31091: empty string specified as a SQL name

1 Answers  






ORA-06710: TLI Driver: send interrupt break message failed

1 Answers  


ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 Answers  


ORA-02750: osnfsmmap: cannot open shared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  


NZE-29193: no CRL found using CRLDP mechanism

1 Answers  


O2I-00121: No value was specified for the CODE option

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


ORA-03291: Invalid truncate option - missing STORAGE keyword

1 Answers  


Categories