Re: Rename table transaction

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.

Jared

On Mon, 21 Mar 2005 08:21:27 -0800 (PST), Sunil Bhola <oraclebhola_at_yahoo.com> 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
--
http://www.freelists.org/webpage/oracle-l