Re: Getting a Database List
Date: Sat, 27 Jul 2002 04:43:50 GMT
Message-ID: <ayp09.50621$uh7.6650_at_sccrnsc03>
You're both wrong. SQL server supports up to 32000 datbases per instance.
Each DB can have bocoup schemas. the first respondent was correct. Oracle
does not lump databases under a server umbrella like the other systems.
Each instance (unless you're running OPS or RAC) is the database.
J
Jim Kennedy wrote:
> No, the equivalent is a schema.
> Jim
> "Steve M" <steve.mcdaniels_at_vuinteractive.com> wrote in message
> news:ahpitc$rdv$1_at_spiney.sierra.com...
>> The Oracle instance IS the database.
>> The MS-SQL equivalent to "database" is TABLESPACE.
>>
>> As user SYSTEM:
>>
>> select name from V$TABLESPACE;
>>
>>
>> "Lee" <lee_at_dev.null.com> wrote in message
>> news:3d3f6464_at_news.starhub.net.sg...
>> > I need to know the interactive SQL syntax to get a listing of databases
on
>> > the current server.
>> >
>> > Using Informix, the commands would be:
>> > database sysmaster;
>> > select name from sysdatabases;
>> >
>> > MySQL:
>> > show databases;
>> >
>> > MS-SQL:
>> > SELECT name FROM master..sysdatabases ORDER BY name
>> >
>> > Please reply by posting to this newsgroup. My email address is hashed
>> > to protect me from spamming.
>> >
>> > Thanks,
>> > Lee
>> >
>> >
>> >
>> >
>>
>>
Received on Sat Jul 27 2002 - 06:43:50 CEST