Hello,
I try to move a table to another tablespace with following SQL:
ALTER TABLE XXX_XX.S2T_COMP_NAMEGROUP MOVE TABLESPACE XXX_ARCH COMPRESS; -- as system
and I'm getting this error:
Error starting at line 1 in command:
ALTER TABLE XXX_XX.S2T_COMP_NAMEGROUP MOVE TABLESPACE XXX_ARCH COMPRESS
Error report:
SQL Error: ORA-21700: object does not exist or is marked for delete
21700. 00000 - "object does not exist or is marked for delete"
*Cause: User attempted to perform an inappropriate operation to
an object that is non-existent or marked for delete.
Operations such as pinning, deleting and updating cannot be
applied to an object that is non-existent or marked for delete.
*Action: User needs to re-initialize the reference to reference an
existent object or the user needs to unmark the object.
I could not find anything helpful about this error message.
Thanks in advance for your help.
Raphael