-Rocky   "Armstead, Michael A" wrote: I also believe that you need to rebuild the database to defrag SYSTEM.Michael Armstead Database Administrator, OCP-CertifiedCorporate & Finance Information SystemsGlaxo SmithKline> -----Original Message-----> From: nlzanen1@ey.nl [SMTP:nlzanen1@ey.nl]> Sent: Tuesday, February 20, 2001 7:25 AMM> To: Multiple recipients of list ORACLE-L> Subject: Re: System Tablespace> > > Hi> > > Export entire database> recreate database> import entire database> > I believe is the only way to defrag system tablespace> > > Jack> > > > > david hill> > > list ORACLE-L > hateau.ca> cc:> > Sent by: Subject: System Tab! lespace> > root@fatcity.co> > m> > > > > > 20-02-2001> > 10:50> > Please respond> > to ORACLE-L> > > > > > > > > Uhoh just noticed that someone here had created some users wiht their> temporary tablespace as the system tablespace and now i have some big> chunks> of free space in there.> > Is it a good idea for me to defrag my sytem tablespace now?> if so could i just run the catproc.sql and the other sql's or would i have> to do an export import.> --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author: david hill> INET: davvid.hill@lechateau.ca> > 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@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).> > > > > =====================================================================> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en> volledige overbrenging van de inhoud v! an een verzonden e-mailbericht, noch> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.> > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u> vriendelijk doch dringend het e-mailbericht te retourneren aan de> verzender> en het origineel en eventuele kopieën te verwijderen en te vernietigen.> > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De> algemene voorwaarden worden u op verzoek kosteloos toegezonden.> =====================================================================> The information contained in this communication is confidential and is> intended solely for the use of the! individual or entity to whom it is> addressed. You should not copy, disclose or distribute this communication> without the authority of Ernst & Young. Ernst & Young is neither liable> for> the proper and complete transmission of the information contained in this> communication nor for any delay in its receipt. Ernst & Young does not> guarantee that the integrity of this communication has been maintained nor> that the communication is free of viruses, interceptions or interference.> > If you are not the intended recipient of this communication please return> the communication to the sender and delete and destroy all copies.> > In carrying out its engagements, Ernst & Young applies general terms and> conditions, which contain a clause that limits its liability. A copy of> these terms and conditions is available on request free of charge.> ====================! =================================================> > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: > INET: nlzanen1@eyy.nl> > 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@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: Armstead, Michael AINET: maa25681@GlaxoWellcome.comFat C! ity Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!