Re: Online redef - is there a better way?

From: Ind-dba <oraclearora_at_googlemail.com>
Date: Sat, 14 Feb 2009 11:17:09 -0800 (PST)
Message-ID: <81ab42aa-f319-4d52-9770-409925e66a6f_at_z6g2000pre.googlegroups.com>

Thanks Mark for your reply!

We dont have cushion for going with 2nd option -- we cant stop frontend users to not able to work. so availability of tables have to be 100% (1% inconvenience is affordable).
Using DBMS_REDEFINITION.FINISH_REDEF_TABLE - is there a possibility to get "ORA-00054 -- resource busy" at the time of swap of dictionary names of 2 tables?
If yes -- any way to avoid it?
Is there a way to tune dbms_redefination way to work fast. I know im being lazy in asking this. I should do this myself -- but asking if anyone has done this in past?

Thx, Sachin Received on Sat Feb 14 2009 - 13:17:09 CST

This message: [ Message body ]
Next message: Michael Austin: "Re: Will Oracle ever follow its own advice?"
Previous message: hpuxrac: "Re: restore using rman"
Maybe in reply to: Ind-dba: "Online redef - is there a better way?"
Next in thread: Jonathan Lewis: "Re: Online redef - is there a better way?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message