RE: DBMS_REDEF - How online is it, really?

Only Gotcha was the amount of redo generated and ability to manage that effectively    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Tuesday, February 11, 2014 11:24 AM To: stephan uzzell
Cc: oracle-l_at_freelists.org
Subject: Re: DBMS_REDEF - How online is it, really?  

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.' 






Please visit our website at 
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html 
for important disclosures and information about our e-mail 
policies. For your protection, please do not transmit orders 
or instructions by e-mail or include account numbers, Social 
Security numbers, credit card numbers, passwords, or other 
personal information.
--
http://www.freelists.org/webpage/oracle-l