Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SYSTEM TABLESPACE IS SO HUGE ?
10G? Must have a lot of objects not belonging to sys/system in there.
(Unless someone turned auditing on and forgot about it.) I'd say the system
tablespace must be so fragmented that it's best to create another database
and recreate the users and import their data with default and quota set to
locally managed tablespace(s).
-----Original Message-----
Sent: Thursday, August 15, 2002 12:07 PM
To: Multiple recipients of list ORACLE-L
Hello Listers,
We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
Now I have a plan to reduce the size of it . And database is running on
8.1.7.2.
What would be the best and faster way to do it. Your ideas will be very much
appreciated !!
Thank in advance,
Madhu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reddy, Madhusudana
INET: Madhusudana.Reddy_at_bestbuy.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).
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 Thu Aug 15 2002 - 13:51:06 CDT
![]() |
![]() |