Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    5

    Unanswered: Desc table_name doesnot show up

    Hi,
    I have created a database link to connect to remote DB and created a synonym to access the table across the DB link.

    I am able to view the data when I give a select * from table_name;
    but when I execute desc table_name I get the error message the table or object does not exists.

    SQL> desc concen_list
    ERROR:
    ORA-04043: object "REPORT_RULES"."CONCEN_LIST" does not exist

  2. #2
    Join Date
    Feb 2009
    Posts
    36
    ORA-04043: object string does not exist
    Cause: An object name was specified that was not recognized by the system. There are several possible causes:
    - An invalid name for a table, view, sequence, procedure, function, package, or package body was entered. Since the system could not recognize the invalid name, it responded with the message that the named object does not exist.

    - An attempt was made to rename an index or a cluster, or some other object that cannot be renamed.

    Action: Check the spelling of the named object and rerun the code. (Valid names of tables, views, functions, etc. can be listed by querying the data dictionary.)


    may it can help u

  3. #3
    Join Date
    Feb 2009
    Posts
    36
    hii
    may be You don't have select privileges for those tables.

  4. #4
    Join Date
    Feb 2009
    Posts
    5
    but
    desc concen_list@DBLINK
    gives the valid output.
    but
    desc concen_list
    gives the error message
    where concen_list is the synonym accessing through DB_LINK

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What is the version of the database you are running the DESC on and the version of the database linked server. DESC doesn't work between certain versions.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Quote Originally Posted by gowrish_j
    but
    desc concen_list@DBLINK
    gives the valid output.
    but
    desc concen_list
    gives the error message
    where concen_list is the synonym accessing through DB_LINK
    try this :

    sql> create synonym concen_list for concen_list@DBLINK;

    sql> desc concen_list;

    I tested it in oracle 10g and work fine ....
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

Posting Permissions

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