| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sapdba and DBMS_REDEFINITION online reorg
"SAP Note Number: 645639 SAPDBA: wrong argument in SYNC_INTERIM_TABLE (online reorg.)"
According to this note, one should be able to do online reorg via sapdba 6.20 patch 111.
Thanks.
-----Original Message-----
From: Hand, Michael T [mailto:HANDM_at_polaroid.com]
Sent: Wednesday, August 17, 2005 9:27 AM
To: Roger Xu; Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: sapdba and DBMS_REDEFINITION online reorg
To those who runs SAP and using sapdba,
How do I use DBMS_REDEFINITION (online reorg) in sapdba?
Roger,
SAP want you to use the BRtools/BRspace utilities instead of sapdba and are no longer maintaining it nor including it in the utility packs. That being said, it still performs some functions better (in the eye of the beholder) than brspace. I don't remember seeing any online reorganization capabilities in sapdba, only an exp/imp based method. Check out brspace for options that do use DBMS_REDEF.
Regards,
Mike
We are using sapdba 6.20 patch 120.
I know the option is there but I cannot see it where in sapdba.
Thanks,
Roger
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 17 2005 - 14:37:17 CDT
 |
 |