Re: multiple databases

From: Dave <x_at_x.com>
Date: Tue, 16 Nov 2004 23:35:45 GMT
Message-ID: <l9wmd.16409$up1.15673@text.news.blueyonder.co.uk>

"Yasaswi Pulavarti" <yasaswi_at_encfor.com> wrote in message news:aa862233.0411161443.42f964f4_at_posting.google.com...
> Hans:
> Howard Rogers in the earlier post clarified all my questions. However
> I did want to get back to you. What I mean by a database is a
> "collection of tables" that span over multiple tablespaces. You are
> right about different vendors treating databases differently. In DB2
> for example you can have one Instance and have many databases in that
> one instance.
> However I guess in Oracle, Instance and Database mean the same or in
> other words one instance can have only one database.
> Thanks,
> Yasaswi

no an instance and a database are not the same thing (think RAC)

Your database is a schema in oracle Received on Tue Nov 16 2004 - 17:35:45 CST