Re: Get list of aval Databases (from tnsnames?)

From: <mikkro_at_hbsi.com>
Date: Sat, 12 Dec 1998 02:31:57 GMT
Message-ID: <74skit$q9i$1@nnrp1.dejanews.com>

In article <74pg76$4gg$1_at_nnrp1.dejanews.com>, fisher_keith_at_hotmail.com wrote:
> Hi. I need a way to get a list of all aval databases on the client. I can read
> the tnsnames.ora but this seems a bit tedius, plus it is not always located in
> the same place from pc to pc. Is there a function I can call to return back a
> list? Thanx!
> Keith
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

There are tables assoicate with sys/system/internal that determine and detail everything about a particular database instance. Generally it is considered a security flaw for anyone to lookup information within the database. Hence the existance of a sys user who can.

Generally, the way one gets these names is talk to the DBA in charge of the system or the owner of the database. They may or may not want you to have access.

--
Michael Krolewski
mikkro_at_hbsi.com
All opinions are my own, and do not represent my employer.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 11 1998 - 20:31:57 CST