only one database in oracle server, see v$database view
sybrandb wrote:
> dalu.gelu_at_gmail.com wrote:
> > Hi,
> >
> > could u help me, what is the sql command to list all existing databases
> > in a oracle server?
>
> Please read the Oracle Concepts Manual.
> There are Instances and Databases and Schemas.
> There is no such thing as multiple databases in a single instance.
> There are multiple schemas! (select distinct owner from dba_tables)
> Multiple instances can only be listed on O/S level.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Fri Dec 29 2006 - 02:36:57 CST
