Re: Dblink in Oracle10g

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