Have a look at another database on the network from local

[dps]

Hello,

I have had a local database created on me machine using Personal Oracle Edition for my own benefit and practising etc.

My question is whether there is a method of being able to look at objects (tables, columns etc) which reside on a nother datasbe on the netwrk??

In DBA studio or like tool you cannot set up a database tree with configuration detaisl derived from the tnsnames file from that instance which exists on the network as you'll geta message saying - need the appropraiet privs.

Any help?

 

[jaggiebunnet]

You could use a dblink which will allow you to login remotely from another database. have a look at

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements10a.htm#27775

 

[dps]

Thanks for that but I did think of using that and got the follwoig

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

 

[SantaMufasa]

DPS,

Check to see if your construction of the database link appears similar to this working example of a DB-link-CREATE statement:

create database link whatever connect to dontdrop identified by dontdrop using 'FOS9204';

Database link created.

select * from dummy@whatever;

X
--------------------
This is dummy data

1 row selected.

In the above example, the components are:

create database link <name_you_create_for_link>
connect to <remote_user_name>
identified by <remote_user's_password>
using '<tnsnames.ora_entry_that_points_to_remote_instance>';

If comparing the above code does not resolve the problem, please post the code you used to create the db link along with an excerpt from your tnsnames.ora which provides the TNS connection information for your remote instance.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:35 (29Jul04) UTC (aka "GMT" and "Zulu"), 10:35 (29Jul04) Mountain Time)

 

[dps]

Thanks for that - just come back from holidays.

I shall dig it out and have another bash at it.

 

[dps]

I have got it working!!