Skip to Content
0

Oracle table size increases after reorg

Dec 07, 2016 at 07:20 AM

61

avatar image

Hi ,

I did online table reorg of table "ZPOSDW_RCP_ESIGN" using BRSPACE in brtools.

Before Table Reorg table size was 421855 MB and after reorg strangely size increased to 451652 MB.

Actually we are planning Table reorg of EDI40 table which is around 1 TB of size. Hence we have taken a copy of PRD to sandbox system and performing these reorg tests.

It would be great if you also can help with suggestions how we can plan for online reorg of bigger tables with minimal impact.

Please find attached about table details

table-reorg.txt

Thanks.

Amaresh Nayak

+91 9886001117

table-reorg.txt (1.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers