Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Instances
In article <37C49551.77B7D5C8_at_doitnow.com>, srfuller_at_doitnow.com says...
>
>This is a multi-part message in MIME format.
>--------------5E4CE48EE9CB5D6A85A563B4
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>How can i pull data across multiple instances and databases?
The quick answer is database links. You make sure you have entries in tnsnames.ora (assuming you're using sqlnet over tcp/ip) for all the servers you want to work with, including your own. Then create your db links with "create database link [linkname] connect to [username] identified by [password] using ["sqlnet_entry_name" (quotes around this are required)];"
If you leave off the "connect to [] identified by []" part you will connect to the remote db as your current userid/password.
After you get the db links made, you can connect to the remote dbs with "connect [username]@[sqlnet_entry_name]" or get data directly with "select [] from [schema.tablename]@[db_link_name]". Pay attention to your instance versions; sqlplus 8x will talk with 7x dbs, but sqlplus 7x won't talk with 8x dbs. An 8x listener will serve both 7x and 8x, but 7x won't handle 8x.
Hope this helps.
--
Jamie Schrumpf http://home.earthlink.net/~moncomincReceived on Wed Aug 25 1999 - 23:23:36 CDT