Re: create database and new instance

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 11 Apr 2005 17:03:38 -0700
Message-ID: <1113263997.258364@yasure>

Mark Bole wrote:

> DA Morgan wrote:
>

>> orclnewbee_at_gmail.com wrote:
>>
>>> Hi guys I am new to oracle - I am a informix dba.
>>> I was experimenting and wanted to start learning oracle.
>>> I have installaed oracle 9 on my windows XP and wanted to create a new
>>> instance and a new database on it.
>>> Please guide me.
>>
>>
>>
>> First off ... learn the language.[...]

>
>

>> What you likely
>> want is to create a schema which is a combination of a
>> userid and password.
>>

> [...]
>
> Well, I know what you mean, and you know what you mean, but as long as
> we're trying to help someone learn a new "language", let's be more precise.
>
> "A schema is a collection of database objects. A schema is owned by a
> database user and has the same name as that user."
>
> Wouldn't want someone to think that every user in the database is a
> schema owner...
>
> -Mark Bole

Though the "precision of language" harkens back to a bygone era I think you are right to point it out in this case and I appreciate the correction. Or should it be clarification?

What really makes your point is one of Oracle's least known bits of syntax ... and one I use quite often: CREATE SCHEMA.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Apr 11 2005 - 19:03:38 CDT