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: [EMAIL PROTECTED] 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: [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.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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). 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: [EMAIL PROTECTED] 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: [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.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] 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: [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).
