8i+
alter table BLAH move;
and then rebuild indexes..
Cheers
Connor
- Muthaiah <cvmuthaiah_at_yahoo.com> wrote: > Hi,
>
> 1. Create a dummy table by using
> create table dummy_table as select * from
> original_table;
> 2. Truncate your original_table
> 3. insert into original_table select * from
> dummy_table;
>
> This will eliminate the fragmenataion
>
> Hope this helps,
>
> Regards,
>
> Muths
>
> At 11:40 PM 4/28/01 -0800, you wrote:
> >hi oracle gurus,
> >how can I defrag a table?
> >this table has many relations,I was going to drop
> them and export the table
> >and import it again,then create the relations.
> >this is very tedious!
> >is their any better way?
> >
> >
> >
> >
> > stuck with
> fragmented tables
> >
>
>____________________________________________________________________
> >Get free email and a permanent address at
> http://www.netaddress.com/?N=1
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: MOHAMMAD AMER
> > INET: mohammad_amer_at_usa.net
> >
> >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_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).
>
>
>
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Muthaiah
> INET: cvmuthaiah_at_yahoo.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_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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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_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 Sun Apr 29 2001 - 16:20:11 CDT
