Oracle-L: RE: OFA myths was Re: BAARF

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 30 Sep 2003 12:44:42 -0800
Message-ID: <F001.005D1885.20030930124442@fatcity.com>

and the first thing that I do is to delete the INDX tablespace!!! As well as dropping the ORD* users, SCOTT, Tim, Tammy-Fae, Jim Bob and all the other crappy stuff that auytomatically gets installed.

I try and get it back to the original 8.0 install!!!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, September 30, 2003 4:25 PM To: Multiple recipients of list ORACLE-L

> -----Original Message-----
> Paul Baumgartel
>
> Loney didn't write OFA, and methinks he was taking liberties with it.

Perhaps. However I notice that DBCA in Oracle 9.2 creates a tablespace called INDX.
http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref807 Oracle9i Administrator's Reference Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris
Part No. A97297-01

Appendix G Optimal Flexible Architecture

...
Separate Segments With Different Requirements Separate groups of segments with different lifespans, I/O request demands, and backup frequencies across different tablespaces. Table G-5 describes the special tablespaces that the Database Configuration Assistant creates for each Oracle database. ...
Table G-5 Special Tablespaces
...
INDX - Index associated with data in the USERS tablespace USERS - Miscellaneous user segments
...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 Tue Sep 30 2003 - 15:44:42 CDT