Re: Can't see remote table

If TC6 and TC1 are different databases then you need two database links. You can write one query that references multiple remote objects on multiple remote databases. The remote objects you reference can themselves be references to remote objects at still other databases. You can use either kind of link: current user or fixed in any case.

With a fixed link the Oracle username must be defined on the remote target instance and have the necessary object privilege to access the target object. Each link could use a different Oracle user.

With a current user link the current Oracle user must be defined on each remote database with the same password as on the local database and again the user must have the necessary object privilege.

The last 4 or 5 chapters of the version 9+ and 10g DBA Administration manuals cover distributed processing. You can find more details there.

HTH -- Mark D Powell -- Received on Fri Nov 11 2005 - 14:30:49 CST