Re: Defragmentation of tablespace

What makes you think you have a problem with tablespace fragmentation?

In what way will reorganizing the objects in the tablespace help solve this problem?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 31, 2002 5:13 AM

> Dear Friends,
>
> Does anybody help me to defrag / reorganise the user tablespaces which
> is large in size.
> Is there any script for that ? If available can somebody send it to me
> ?
>
> Regards,
> Pradeep
>
> Disclaimer:
> "The information in this e-mail is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. It should not be used by anyone who is not the
> original intended recipient. If you have erroneously received this
> message, please delete it immediately and notify the sender. The
> recipient acknowledges that IBS or IBS Group like any other large
> global corporation, are unable to exercise total control or ensure or
> guarantee the integrity of contents of the information contained in
> individual e-mail transmissions and the recipient acknowledges that
> any views expressed in this message may be those of the individual
> sender and no binding nature of the message shall be implied or
> assumed unless the sender does so expressly with due authority of IBS
> Group. Before opening any attachments please check them for viruses
> and defects."
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: pradeep_at_ibsplc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).