Shaibal is right on target. If you're going to go to the trouble to defragment then you may as well switch to uniform extent sizing so you don't have the problem in the future. If you have the room you can do it in stages. First create an index tablespace and rebuild all your indexes in that. Then create a table tablespace(s), then you can export all the tables, drop them and recreate the table structures with uniform extents or locally managed and import them. If you have tables of widely varying size then you could set up multiple tablespaces (ts_small, ts_medium, etc). Jay Miller
-----Original Message----- Sent: Thursday, February 07, 2002 8:03 PM To: Multiple recipients of list ORACLE-L Seema, >From your posting, it is not clear to me about the content of the mentioned tablespace. If it contains all of one users schema you can just take export for that particular schema. The step when you are recreating the tablespace, create it with pct increase 0 and do create initial and next extents same size or you can create the tablespace as a locally managed tablespace - this is where your fragmentation is going to be stopped. The rest looks fine to me. Slightly off topic, it is not good practice to create everything belong to a owner in the same tablespace. For sure tables and indexes should have their seperate tablespaces. Shaibal >From: "Seema Singh" >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L >Subject: FRAGMENTATION ISSUE? >Date: Thu, 07 Feb 2002 13:07:10 -0800 > >Hi >one of my tablespace is highly fragmented and that tablespace >contains >almost all objects and its default tablespace of one of users .I >want to >correct it thru export/import.Let me correct if any thing missing >please. >-Full export of current instance. >-Drop that tablespace including contents.(Drop only one tablespace) >-Create that tablespace >-import the data thru fromuser touser option. >-compile the object if required >Is anything missing in this list.The above are overall steps.Let me >know >this will remove the fragmentation of that tablespace or not?What is >the >risk factor to do this? >Thx >-sEEMA > > > >_________________________________________________________________ >Chat with friends online, try MSN Messenger: >http://messenger.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seema Singh > 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). _____ Send and receive Hotmail on your mobile device: Click Here <http://go.msn.com/bql/hmtag2_etl_EN.asp> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaibal Talukder 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: Miller, Jay 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).
