Re: DBMS_REDEF - How online is it, really?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 11 Feb 2014 10:24:29 -0600
Message-ID: <CAJvnOJZwavWC=Nf4UpKvEvH3pZRhwAWFo6ecs2rYkBFiQ3EXCg_at_mail.gmail.com>

I have used it with great success. I had a large number of tables we wanted to repartition and wrote a couple of stored procedures to accomplish it. The dbms_Redefinition worked very well.

On Tue, Feb 11, 2014 at 10:03 AM, Uzzell, Stephan <SUzzell_at_micros.com>wrote:

> 11.2.0.3.7 on OEL 6, in case that matters.
>
>
>
> We've been looking into partitioning some large tables (5 trillion rows,
> 1TB) so that we can better manage them (drop old data, &c.). Right now I'd
> say dbms_redefinition may be the leading candidate, because Oracle says it
> is an online operation. I've been burned by Oracle's idea of "online"
> operations before - alter index rebuild online, if the code is optimized /
> hinted to use that index, may be online as far as Oracle is concerned, but
> it sure wasn't for the end users.
>
>
>
> So I'm wondering - has anyone used dbms_redefinition to partition large
> tables? Is it truly online? Can Oracle keep up with inserts in the meantime?
>
>
>
> We are thinking about using RAT to try to play back a typical workload,
> but before we open another can of Oracle worms, I figured a question to the
> list might be a good place to start.
>
>
>
> Thanks!
>
>
>
> *Stephan Uzzell*
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Received on Tue Feb 11 2014 - 17:24:29 CET