RE: sapdba and DBMS_REDEFINITION online reorg

  • From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
  • To: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 17 Aug 2005 14:35:02 -0500

"SAP Note Number: 645639 SAPDBA: wrong argument in SYNC_INTERIM_TABLE (online 
According to this note, one should be able to do online reorg via sapdba 6.20 
patch 111.

-----Original Message-----
From: Hand, Michael T [mailto:HANDM@xxxxxxxxxxxx]
Sent: Wednesday, August 17, 2005 9:27 AM
To: Roger Xu; Oracle-L@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?
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 

We are using sapdba 6.20 patch 120.
I know the option is there but I cannot see it where in sapdba.

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. 
This email has been scanned for all viruses by the MessageLabs Email Security 
System. Any questions please call 972-721-8257 or email your request to 

Other related posts: