on 02-23-2011 4:14 AM
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
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
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 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.