Can't see remote table

From: Andy Kent <andykent.bristol1095_at_virgin.net>
Date: 11 Nov 2005 06:04:11 -0800
Message-ID: <1131717851.098430.245630@o13g2000cwo.googlegroups.com>

Accessing table CLASS1 on instance TC6 over dblink TC6. The table exists in both schemas TC_0002 and TC_0005.

If I connect to instance TC6 as SYS AS SYSDBA, both DESC TC_0002.CLASS1 and DESC TC_0005.CLASS1 work.

Trying to do it over the dblink though, as SYSTEM on the connected instance, DESC TC_0005.CLASS1_at_TC6 works but DESC TC_0002.CLASS1_at_TC1 gets "ORA-04043: object tc_0002.class1 does not exist".

Any clues anyone?

9ir2 on W2k using SQL*Worksheet from OEM 9.0.1.

Thanks

Andy Received on Fri Nov 11 2005 - 08:04:11 CST