This discussion is archived
4 Replies Latest reply: Nov 7, 2013 10:53 PM by RStein RSS

Alter table move - ORA-21700: object does not exist or is marked for delete

RStein Newbie
Currently Being Moderated

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

  • 1. Re: Alter table move - ORA-21700: object does not exist or is marked for delete
    sb92075 Guru
    Currently Being Moderated

    RStein wrote:

     

    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

     

    Either Oracle is mistaken, or you are..

    post SQL & results that shows table actually exists.

    If Oracle reports error when none should exist, you will need to submit a Bug Report.

     

    post complete results from SQL below

     

    SELECT * FROM V$VERSION;

  • 2. Re: Alter table move - ORA-21700: object does not exist or is marked for delete
    RStein Newbie
    Currently Being Moderated

    Thanks for your answer.

     

    Here's output:

    BANNER                                                                        

    --------------------------------------------------------------------------------

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production    

    PL/SQL Release 11.2.0.3.0 - Production                                          

    CORE 11.2.0.3.0 Production                                                        

    TNS for Linux: Version 11.2.0.3.0 - Production                                  

    NLSRTL Version 11.2.0.3.0 - Production

  • 3. Re: Alter table move - ORA-21700: object does not exist or is marked for delete
    TSharma-Oracle Guru
    Currently Being Moderated

    If you are sure your object name is right, this could be the corruption in the data dictionary. I have also seen several bugs regarding this error specially table made with type column. You should contact oracle support.

  • 4. Re: Alter table move - ORA-21700: object does not exist or is marked for delete
    RStein Newbie
    Currently Being Moderated

    Alright, I will create a SR.

     

    Thank you for your help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points