RE: sapdba and DBMS_REDEFINITION online reorg

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 17 Aug 2005 10:26:54 -0400
Message-ID: <96FB7D6574516C45922A76B354B684FD45A5DC@USHQEXVS.polanet.polaroid.com>

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

--

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 17 2005 - 09:28:58 CDT