I'd go for 'alter table ... move' and then rebuild the
indexes - lots less hassle (if you have the free space
to do it)
hth
connor
- Peter R <niagarap_at_hotmail.com> wrote: > Hi
Friends,
>
> Hi Friends,
>
> I have GL table ready to reorg! The table underwent
> so many purges, Now had
> real data 17Gb with initial and next extents as
> 360M, Offcourse the total
> size showing 26Gb from dba_segments. I want to avoid
> export and Import
> process due to time taking.
>
> I want to use CTAS to reorg this GL table.
>
> First Create a copy of GL in Newtablespace
> Drop main GL table
> Creat New GL table with new storage parameters like
> Initial extent 5GB(I
> knew I had more than 10Gb data!!) and next extent
> 360M, and pctused 40,
> pctfree 5.
> Insert data from copy GL to Main GL and create all
> indexes
>
> My doubts are Can I create such a big Initial
> extent?? What other
> implications I may face in future? Will it increase
> performance?? I can't
> create newtablespace for this table due to my system
> already saturated in
> terms of diskspace.
> My environment is oracle7.3 on AIX, btw my avg row
> length is 448 bytes. MY
> aim is simple! To pack the data and get back space!!
>
> Thanks in advance for your help
> peter.
>
>
>
>
> MSN Photos is the easiest way to share and print
> your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Peter R
> INET: niagarap_at_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_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
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
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 Wed Aug 07 2002 - 04:10:16 CDT