Re: Relocate table to a different tablespace in SAP

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 14 Nov 2005 18:52:09 +0000
Message-ID: <bf46380511141052mf9bd1b3q56603a8aace33ebb@mail.gmail.com>

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_at_dp7uptx.com> 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_at_gmail.com]
> *Sent:* Thursday, November 10, 2005 10:58 PM
> *To:* Roger Xu
> *Cc:* oracle-l_at_freelists.org
> *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>)
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 14 2005 - 12:54:13 CST