Re: Graphical Oracle administration

From: news.verizon.net <kennedyii_at_verizon.net>
Date: Thu, 22 May 2008 14:50:44 GMT
Message-ID: <8LfZj.2331$aJ1.417@trndny03>

"Luigi" <newsgroupusr_at_gmail.com> wrote in message news:dd63e773-c8c3-4fef-9d39-537e16c2a2ae_at_j22g2000hsf.googlegroups.com...
>> True, but the SQL Server 'definition' of a 'database' differs
>> DRASTICALLY from the Oracle definition, of which you're apparently
>> unaware.
>> A 'database' in SQL Server is used to colocate data and tables which are
>> related to each other; this is the purpose of the SCHEMA in Oracle.
>>
>
> I read the concepts guide, thank you.
>
> So if I want to create two database MANAGEMENT and CONFIGURATION, in
> SQL Server I have to create TWO DB, while in Oracle I have to create
> ONE DB and TWO SCHEMAS.
> How much SQL Server schemas have I to create, one?
> SQL Server schemas can be compared to Oracle databases?
>
> Thanks,
> Luigi.

I think you have the rdbms's reversed in the above question. I will assume that is so.
In Oracle you can create many many schemas and people often do. A schema in Oracle is similar to a SQL Server database. Jim Received on Thu May 22 2008 - 09:50:44 CDT

Original text of this message