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
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@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?
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.
____________________________________________________________________
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
tech_support@xxxxxxxxxxxx
Other related posts:
