Re: create a database link without modifying tnsnames.ora

You could use the 'copy' functionality, which is client based, while a db-link is server based.

"MJWood" <maryjanewood_at_hotmail.com> wrote in message news:k7ns4u40gqmg9rl4vddrrp2egulp5bgl1l_at_4ax.com...
> Hi all,
>
> I have the ip address, port number, database name, login name and
> password of several Oracle databases. I usually write java program to
> do all my job bacause a simple url can connect all these databases
> easily, e.g. DriverManager.getConnection
> ('jdbc:oracle:thin:_at_123.123.123.123:1521:ORCL', 'name', 'pwd')
> will be enough to create a connection. Then I can get data from one
> database, modify it and transfer to another database. It is slow, but
> always works.
>
> Now I am asked to write some PL/SQL for similar batch processing. I
> need to create some database links but I want to do it dynamically. I
> don't want to modify the tnsnames.ora nor bother our DBA to create a
> link for me (it will take forever to wait...).
>
> Anyone knows a convenient way to do it ? Any suggestion is welcome !
>
Received on Wed Jan 23 2002 - 09:15:01 CET