on 01-14-2009 8:24 PM
Hi
Based on many threads I saw here in this forum I am going for an offline re-organization of the table TST03 to reclaim back the space.
But before I go ahead performing this task, can someone please tell me whether there is any risk associated with the offline re-organization of this table...
TST03 contains TEMSE, so, worst case, you lose all of them. it contains temporary contents, so, no biggie here.
other than that, a table reorg is not really risky. take note that because this table uses LONG RAW, a reorg will be much slower than a normal table.
so, to make things faster, run a TEMSE consistency in SP12 and delete everything that is not needed BEFORE reorg.
Test the process with a copy of your PRD system and calculate how much time it will take.
If you plan on reorg'ing this table often, converting LONG RAW to BLOB is a good idea which will enable you to reorg this table online in the future.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Grame,
> I mean to say, will the table extents number come down after this re-organization.
If you have deleted many data before - yes. If your extent sizes are very big you maybe would see the same number of extents with more free space. The size of your extents depends on some factors ( LMTs or DMTs).
But you would only reorganize the table after a massive delete action, so in normal yes you will have more free space in the corresponding tablespace.
Regards
Stefan
hi grame,
It should be OK to do some table reorganization especially doing offline reorg.
ardhian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.