Re: create a database link without modifying tnsnames.ora

Sneering at developers is easy.
I have seen a two day delay between requesting an simple upload and compile of a form and the response to that request. (From the DBA). Guess what that does to any kind of planning.... Makes you wonder if DBA's do their planning on a per-second-base.... Hey, see this! Sneering at DBA's is not that hard too ;-)
Generalisation makes life a lot more simple. It has some disadvantages too.....

Marc

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0201230208.55dbc41b_at_posting.google.com...
> 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 !
>
> Using hardcoded ip adresses is not recommended.
> As the *database server* is handling database links there is *NO WAY
> AT ALL* you can do this *WITHOUT* involving your DBA.
> Developers usually never plan anything, so why do you think you have
> to wait?
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Jan 24 2002 - 08:49:28 CET