Re: Relocate table to a different tablespace in SAP
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Roger Xu <roger_xu@xxxxxxxxxxx>
- Date: Mon, 14 Nov 2005 18:52:09 +0000
See SAP note 646681.
It states that due to various bugs with dbms_redefinition, it should
not be used to reorg SAP tables below version 9.2.0.6 <http://9.2.0.6> of
Oracle.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 11/11/05, Roger Xu <roger_xu@xxxxxxxxxxx> wrote:
>
> What is broken in 9.2.0.5 <http://9.2.0.5>? brspace or dbms_redefinition?
> What is the fix?
> One more reason for us to stay on 9.2.0.4.0.
> Thanks.
>
> -----Original Message-----
> *From:* Jared Still [mailto:jkstill@xxxxxxxxx]
> *Sent:* Thursday, November 10, 2005 10:58 PM
> *To:* Roger Xu
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: Relocate table to a different tablespace in SAP
>
> The current tool for doing that in SAP is brspace.
>
> brspace uses dbms_redefinition under the covers.
>
> (Which is unfortunately broken in 9.2.0.5 <http://9.2.0.5>)
>
>
Other related posts:
