Re: Rename table transaction

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Sunil Bhola <oraclebhola@xxxxxxxxx>
  • Date: Mon, 21 Mar 2005 08:25:44 -0800

Thanks Sunil.

This is strictly a proof of concept, and there are probably
other caveats as well.

Code supplied on this list is not frequently unit tested,
at least not by me.


On Mon, 21 Mar 2005 08:21:27 -0800 (PST), Sunil Bhola
<oraclebhola@xxxxxxxxx> wrote:
> Hi, 
>  When you rename a table, the command requires an exclusive lock, so if
> there is uncommitted DML will cause the rename attempt to fail. To lock the
> table with command you should use "LOCK TABLE <<TABLENAME>> in exclusive
> lock". 
> Hope it will give you the guideline : 
> Sunil Bhola  
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: