RE: no create system tbs ?????

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Mon, 30 Jul 2001 07:11:57 -0700
Message-ID: <F001.00358E0E.20010730070521@fatcity.com>

The actual response to this is...
What is an Oracle database and instance? What does it require? To have a running Oracle database you need:

        A pfile (init<sid>.ora) to set up the SGA
        At least one control file (location defined in pfile created by the
create database command)
        At least two redo logs (defined and created in the create database
command)
        A system tablespace (defined and created in the create database

command.)

By the time you have completed running your create database script you have created all the
NECESSARY items for running an Oracle database. Granted you can't do much with it at
this point, but it is up and running. That's why the second script has alter tablespace
for system and create tablespace for all the others.

HTH Rodd Holman

        -----Original Message-----
        From:   Sinardy [SMTP:sinardyxing_at_bcsis.com]
        Sent:   Friday, July 27, 2001 11:20 PM
        To:     Multiple recipients of list ORACLE-L
        Subject:        no create system tbs ?????

        Hi all,

        When I am using dbassist to create "create DB script",

        First of the script is for something like:
        CREATE DATABASE

                ..
                redo bla bla
                datafile
                logfile

        ;

        Second script

        ALTER TABLESPACE SYSTEM
        DEFAULT STORAGE



        .

        .

        .

        .


        CREATE TABLESPACE tool



        ...

        ..


        CREATE TABLESPACE rbs

        ________________________________

        My question is in second script, where we create the tablespace call
system
        ?
        alter tablespace will not create tablespace, am I right ?


        Regards,
        Sinardy


        -- 
        Please see the official ORACLE-L FAQ: http://www.orafaq.com
        -- 
        Author: Sinardy
          INET: sinardyxing_at_bcsis.com

        Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
        San Diego, California        -- Public Internet access / Mailing
Lists
        --------------------------------------------------------------------
        To REMOVE yourself from this mailing list, send an E-Mail message
        to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
        the message BODY, include a line containing: UNSUB ORACLE-L
        (or the name of mailing list you want to be removed from).  You may
        also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  INET: rodney.holman_at_lodgenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jul 30 2001 - 09:11:57 CDT