Using database link

From: Michael L. Hostbaek <carlos_at_pez.dk>
Date: 14 Apr 2003 12:02:06 GMT
Message-ID: <slrnb9l8pu.ud6.carlos@freebsdcluster.dk>

Group,

As suggested in the group, I am tryin to get data from one oracle server to another by creating a database link - and insert it directly to the new database.

I tried creating the link with my normal "work" user, but I did not seem to have sufficient priviliges to do so. So I logged in a system and did:

create database link oldora.mydomain.com connect to orauser identified by orapass using 'MY_DB';

That seemed to work allright, however I cannot seem to find any of my created tables ??
WHen doing :
select count(*) from users_at_oldora.mydomain.com I get the following error:
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from OLDORA.MYDOMAIN.COM

I can only see the following tables:
SQL> select table_name from all_tables_at_oldora.mydomain.com;

TABLE_NAME

---

DUAL
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP
AUDIT_ACTIONS
PSTUBTBL
DEF$_TEMP$LOB
OGIS_SPATIAL_REFERENCE_SYSTEMS
MD$DICTVER
CS_SRS
HELP Can anyone tell me how to see the rest of the tables ?

Thanks.

/mich

-- 
Regards,
Michael L. Hostbaek
-= So long, and thanks for all the fish.. =-

Received on Mon Apr 14 2003 - 07:02:06 CDT