Re: Graphical Oracle administration

From: <fitzjarrell_at_cox.net>
Date: Thu, 22 May 2008 08:07:30 -0700 (PDT)
Message-ID: <35a2c41a-3e62-42fe-b62b-0c36fcd8550e@l42g2000hsc.googlegroups.com>


Comments embedded.
On May 22, 9:45 am, Luigi <newsgroup..._at_gmail.com> wrote:
> > 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.

Correct, that's one way to accomplish the task. You COULD create two separate Oracle databases, one for the MANAGEMENT schema and one for the CONFIGURATION schema, but that is still vastly different from creating a SQL Server database.

> How much SQL Server schemas have I to create, one?

Each SQL Server database would equate to a single Oracle schema.

> SQL Server schemas can be compared to Oracle databases?
>

No, it's the other way around: 1 SQL Server database == 1 Oracle schema.

> Thanks,
> Luigi.

David Fitzjarrell Received on Thu May 22 2008 - 10:07:30 CDT

Original text of this message