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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
