| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SYSTEM TABLESPACE IS SO HUGE ?
To eliminate all confusion ( I came to know just now ) , somebody created
this tablespace with 10000 MB at the time of database creation "MAY" be ,
and only 150 MB of space is consumed , remaining all wasted space. would
like to resize the SYSTEM tablespace datafile now !!!
Thanks
Madhu
-----Original Message-----
Sent: Thursday, August 15, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Check for 3rd party applications going in there. Peoplesoft was one that used to use System as it's default tablespace.
Also in beginning in 11i apps 11.5.5 the patches now go in the database so System grows quite a bit.
Kathy
-----Original Message-----
Sent: Thursday, August 15, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L
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).
Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kathy Duret
INET: KathyD_at_belkin.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: 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). Received on Thu Aug 15 2002 - 16:13:38 CDT
 |
 |