Wow! Your disclaimer is larger then your message! As for the defragmentation
look into DBA guide under "locally managed tablespaces" and then in SQL
reference
under: "ALTER TABLE" and pay particular attention to the "MOVE" qualifier.
The site to visit is http://technet.oracle.com. And yes, this is a "read the
fine
manual" answer.
> -----Original Message-----
> From: pradeep_at_ibsplc.com [mailto:pradeep_at_ibsplc.com]
> Sent: Thursday, October 31, 2002 7:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Defragmentation of tablespace
>
>
> 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: Gogala, Mladen
INET: MGogala_at_oxhp.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).
Received on Thu Oct 31 2002 - 09:23:46 CST
