DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Can't see ONE particular table using a DB link

  1. 04-23-2002, 04:53 AM #1
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I have a public database link to our production database. Using this link I can 'see' all the application tables except one in particular.

    I get...

    ERROR at line 1:
    ORA-00942: table or view does not exist
    ORA-02063: preceding line from ORACLE

    Is there anything in this table's make-up I can look at to show why its different from all the other tables?

    I'm using 8.1.5 on NT4
    Reply With Quote Reply With Quote
  2. 04-23-2002, 05:28 AM #2
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Maybe the owner is not the same?

    Cheers

    Angel
    Reply With Quote Reply With Quote
  3. 04-23-2002, 05:34 AM #3
    Umesh_Shar
    Umesh_Shar is offline Junior Member
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    33
    Or May be a public synonym is missing for this particular table

    Regards,
    Umesh Sharoff
    Reply With Quote Reply With Quote
  4. 04-23-2002, 05:36 AM #4
    oravijay
    oravijay is offline Senior Member
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Check whether the table which you r trying to access thru the database link exists
    in the remote database.

    Vijay.
    Say No To Plastics
    Reply With Quote Reply With Quote
  5. 04-23-2002, 06:28 AM #5
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    SHOOT THE DEVELOPERS

    The table wasn't part of a DB Role that my DB link CONNECT TO username was granted.

    Sorry folks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width