Skip to Content
avatar image
Former Member

Oracle table size increases after reorg

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



Amaresh Nayak

+91 9886001117

table-reorg.txt (1.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers