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: ORACLE-L@fatcity.com
>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: oracledbam@hotmail.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@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).
Send and receive Hotmail on your mobile device: Click Here
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaibal Talukder
INET: shaibal_talukder@hotmail.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@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 Feb 07 2002 - 19:19:37 CST
