Re: 1.Create new schema? 2. Databases on a different drive?

Hello,

First, when you create a user in Oracle, you create a schema. Think of user and schema as being the same thing.
eg:
CREATE USER user01
IDENTIFIED BY password
DEFAULT TABLESPACE usr
QUOTA 10M ON usr
QUOTA 5M ON temporary
PROFILE default

creates a schema called 'user01'.
When you connect to Oracle as that user, and you build Oracle objects (tables, views, sequences, indexes) you build objects in that schema.

Second, the Oracle home(s) is more about where the Oracle software is stored than where the Oracle data files are. You can place the data files anywhere you want, regardless of the Oracle home. I suggest you look into a thing called the Optimal Flexible Architecture (OFA). The OFA specifies the correct place for all the Oracle software

Good Luck

Mikel

kvemuri_at_my-dejanews.com wrote in message <7gso8c$csn$1_at_nnrp1.deja.com>...
>Hi I am not a qualified DBA nor I have any database experience, but I am
>setting up a Oracle7 Workgroup Server(version 7.3...) for a inhouse
databases
>(huge, scientific data). I have set up a new SID, changed the Tnsnames.ora
>file and renamed all the files under \\orant\databases\ to reflect the new
>SID, now I have a problem : how do i create a new Schema ? any script that
I
>can use? and next question : oracle_home is on the 'C' drive and I have a
>drive 'D' in which I would like to load the databases how do i specify the
>drive when I create the database? Help is appreciated. Thanks kavita
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu May 06 1999 - 20:07:09 CDT