Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: System tablespace Oracle 9202

RE: System tablespace Oracle 9202

From: Godlewski, Melissa <Melissa.Godlewski_at_hq.doe.gov>
Date: Fri, 07 Mar 2003 08:49:09 -0800
Message-ID: <F001.005635D7.20030307084909@fatcity.com>


Isn't that the truth. GUI's don't seems to make our DBA work easier.

-----Original Message-----
Sent: Friday, March 07, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L

Which is a good reason to save scripts from DBCA as opposed to having it create the DB for you. I always do this. I can't tell you how many times I tried to let DBCA create the DB directly only to have it crap out for one reason or another, and then you need to go back and plug in all the custom values all over again. If you save scripts, you can modify them to do whatever you want.

> It was only in 9.2 that it was possible to create the system tablespace
> as locally managed, and rumour says that in 10i system tbs defaults to
> locally managed.
>
> The reason it's not default in 9.2 is most likely because......:
> 1. Most likely they just didn't update the DBCA default scripts to
> use this feature when they went from 9i R1 to 9i R2 (read: the scripts
> was just copied from the 9i R1 source tree)
> 2. The feature is brand new, so if some problems turn up, most
> databases wont have it set, because they are created from the DBCA.
>
> Regards,
> Morten Egan
>
> Godlewski, Melissa wrote:
>
> > List,
> >
> > System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent
> > Management. I thought all tablespaces defaulted to Local in this
release.
> >
> >
> > Thu Mar 6 15:29:43 2003
> > create tablespace SYSTEM datafile
> > '/oradb/DEV/system/system01.dbf' size 201M reuse
> > default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY
> > online
> > Thu Mar 6 15:29:57 2003
> > Completed: create tablespace SYSTEM datafile
> > '/oradb/DEV
> > Thu Mar 6 15:29:57 2003
> > create rollback segment SYSTEM tablespace SYSTEM
> > storage (initial 50K next 50K)
> > Completed: create rollback segment SYSTEM tablespace SYSTEM
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Morten Egan
> INET: meg_at_miracleas.dk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Chuck Hamilton
  INET: chuckh_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Godlewski, Melissa
  INET: Melissa.Godlewski_at_hq.doe.gov

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri Mar 07 2003 - 10:49:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US