Re: help with select for update
From: <emdproduction_at_hotmail.com>
Date: Wed, 14 Jan 2009 14:22:25 -0800 (PST)
Message-ID: <49172c50-b43f-40fe-9b01-823d7ea18a7c_at_r24g2000vbp.googlegroups.com>
Date: Wed, 14 Jan 2009 14:22:25 -0800 (PST)
Message-ID: <49172c50-b43f-40fe-9b01-823d7ea18a7c_at_r24g2000vbp.googlegroups.com>
> We need:
>
> * Oracle release you're using (all four or five numbers)
> * How you defined the policy
> * Output from the following query:
>
> select table_name, table_lock
> from user_tables
> where table_lock = 'DISABLED';
>
> Provide that information and someone can get started with some actual
> assistance.
>
> David Fitzjarrell
Oracle is 10.2.0.3
SQL> select * from <table_name> for update nowait;
no rows selected
SQL> select table_name, table_lock
2 from user_tables
3 where table_lock = 'DISABLED';
no rows selected Received on Wed Jan 14 2009 - 16:22:25 CST