Re: Dblink in Oracle10g

From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 18 Nov 2008 11:45:46 -0600 (CST)

Hey Bradd,

While not exactly a workaround, here's one scripting method that might help:

http://asktoad.com/DWiki/doku.php/howto_create_dblinks_database_links_in_another_schema

(or http://tinyurl.com/ToadDBLinks for the long URL impaired email)

I used Toad to do this, but I suppose one could use an inferior product...   ;)

Rich

> I should have stated it was my opinion that it seems cleaner to me. I
> already have DataPump set up on my databases. I believe it would also take
> care of any 'become user' issues when doing the import rather than having to
> code 'connect' statements for the private database links. (If there is a
> better way to do this part, I'd love to see how that is done!!!)


--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Dblink in Oracle10g
From: Joel.Patterson

References:
- Dblink in Oracle10g
  - From: Nagaraj S
- Re: Dblink in Oracle10g
  - From: Bradd Piontek
- Re: Dblink in Oracle10g
  - From: Dan Norris
- Re: Dblink in Oracle10g
  - From: Bradd Piontek

Re: Dblink in Oracle10g

Other related posts: