1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

OCI-21700: object does not exist or is marked for delete Synonym issue in Oracle 11g

Discussion in 'SQL PL/SQL' started by SBH, Oct 6, 2010.

  1. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    Hi All,

    I came across strange issue on basic nature of Synonyms in Oracle 11g. Below is the scenario

    I have two users U1 and U2, in the same database.
    Schema Objects of U1 and U2 are on different tablespace, not on SYSTEM. I can refer and access any valid U1 object in U2 as U1.object_name or with synonym. But whenever I refer, I get error "OCI-21700: object does not exist or is marked for delete".

    I have tested this with both private and public synonyms in U2. I have granted ALL access from U1 on the objects.

    Please help me on this.

    SBH
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: OCI-21700: object does not exist or is marked for delete Synonym issue in Oracle

    Post exactly what you did to create the synonyms; also post the tablespace access granted to both users.