Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't see remote table

Re: Can't see remote table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Nov 2005 06:24:27 -0800
Message-ID: <1131719067.154129.287080@g14g2000cwa.googlegroups.com>


Andy, what kind of db link are you using in each case? There are several different ways to define db links: connected user, fixed user, and current user. There are also public and private db links.

How you set up your link matters. A public link in one case and a private link in the other could be responsible. In the case of a fixed link object privileges are a likely culpert.

If you connect as system on database TC1 can system desc the TC_002.CLASS table?

HTH -- Mark D Powell -- Received on Fri Nov 11 2005 - 08:24:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US