| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Initial Extent 5GB?? for 17GB table!!
Peter,
I shall say not to go because
1)first you don't have disk space to create backup table before droping your
original table.
2)Droping original tables of Oracle Financials and specially table like GL
which is a real center point of Financials is inviting a lot of trouble and
down time. Besides it will result in hundreds of invalid objects which might
even not compile and Oracle support will suggest you to run catalog.ora etc.
so there is a lot of hassle.
3) The released space will be used by new data/rows and to improve performance you can rebuild all indexes on this table. Don't use parallel caluse in index rebuilding(which I am found of) if your version is less than 7.3.4.4 as it corrupts indexes whith more than one keys.
I have been reorganising Material tables which was not having that much complexities but once I touched AR tables on a test system , I was trapped in a very bad situation and I have to run catalog.ora to resolve my dictionery issue to get compile invalid views. My env is HP-UX and oracle 7.3.4.5.
To avoid any possible hasle , we now rebulding indexes on all purged tables and next year data takes the deleted space in tables.
If you have any specific question please let me know...
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Tue, 06 Aug 2002 08:53:33 -0800
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.
-- 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-LReceived on Tue Aug 06 2002 - 14:18:53 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_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).
 |
 |