cancel
Showing results for 
Search instead for 
Did you mean: 

how to use psapundo during online reorg

Former Member
0 Kudos

Hi Experts,

I'd like to exuecute online reorg on AIX6.1&Oracle10g.

Target table size is 300GB (not tablespace), therefore I 'd like to proceed carefully.

[Question]

Could you tell me needed PSAPUNDO size?

PSAPUNDO is 130GB, and I knowPSAPUNDO would be reused after commit.

But I can't have confidence to success reorg due to lack of PSAPUNDO.

Best Regards,

Toshi

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Hi Toshi,

there aren't any special requirements for the size of the UNDO tablespace during an online reorg.

As this is done via DBMS_REDEFINITION and this in turns uses materialized views, the creation of the data in the target tablespace doesn't require much UNDO.

regards,

Lars

Former Member
0 Kudos

Thank you so much.

I also think so.

But it is first time in this system, so I'd like to collect some knowledge.

Best Regards,

Toshi

Answers (0)