create a database link without modifying tnsnames.ora
Date: Wed, 23 Jan 2002 07:07:50 GMT
Message-ID: <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 !