circular path of synonym
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: circular path of synonym

Hybrid View

  1. #1
    Join Date
    Dec 2002
    Location
    India
    Posts
    34

    circular path of synonym

    Hi ,

    I am facing with the problem

    SQL> desc dd_ec_le1_dates;
    SP2-0749: Cannot resolve circular path of synonym "dd_ec_le1_dates"

    If i use this statement

    select count(*) from table_name

    then i get the following error
    ERROR at line 1:
    ORA-00942: table or view does not exist

    I am accessing this table from different schema.

    for this problem i have dropped the public synonym for this table recreated it still the problem persists..

    what is the problem i am unable to access the table even though i have created a public synonym?

    Thanks
    Sridhar

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You most likely have a synonym that never resolves back to an actual object.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2002
    Location
    India
    Posts
    34
    AS i have mentioned there was a Public synonym i have dropped and re created the public synonym .. the problem still persists

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    what does
    select * from all_synonyms
    show?

    who is the owner of that table/view? What is the command you are using to create a SYNONYM for that table? does the synonym reference go away from all_synonyms tables once you drop the synonym? This is all I could think. No idea what else is goping wrong here.
    -- Dilip

  5. #5
    Join Date
    Dec 2002
    Location
    India
    Posts
    34
    Originally posted by patel_dil
    what does
    select * from all_synonyms
    show?

    who is the owner of that table/view? What is the command you are using to create a SYNONYM for that table? does the synonym reference go away from all_synonyms tables once you drop the synonym? This is all I could think. No idea what else is goping wrong here.
    I can see the synonym in all_synonyms

    I have created the table in a different schema

    The command used for creating the synonym is
    "CREATE PUBLIC SYNONYM FOR

    It goes away from all_synonyms when i dropped the synonym..

  6. #6
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Try just creating the Synonym for the user who needs access to that table. Avoid creating PUBLIC synonyms, atleast till your problem is resolved. and please post complete syntax.
    -- Dilip

  7. #7
    Join Date
    May 2003
    Location
    hyderabad, India
    Posts
    10
    Initially, login as the owner of the table and grant access to the user in whose schema the synonyms are to be created.

    *********************************************************
    connect as the synonym owner
    Create synonym synonym_name for schema.tablename;

    select * from synonym_name;

    *********************************************************

    Hope this will solve the problem.

    Tks

    Partha

    (Njoy DBAing)

  8. #8
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    simple steps..here
    connect owner/password;

    @create table/procedure hello..

    grant execute on hello to 2user;

    connect 2user/password;

    create synonym hello for owner.hello;

    exec hello;

    hope it makes you better

    Thanks.
    Thanigaivasan.

  9. #9
    Join Date
    Dec 2002
    Location
    India
    Posts
    34
    The work around is
    Dropping the Table and public synonym and recreating all

    why does the error comes and what is the solution ?
    Last edited by ksridhar; 05-07-2003 at 05:23 AM.

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by ksridhar
    The work around is
    Dropping the Table and public synonym and recreating all

    why does the error comes and what is the solution ?
    The error comes because your synonym does not resolve to an object. The solution is to understand what you are doing before you go creating public synonyms all over the place.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width