Re: help with select for update

From: ddf <oratune_at_msn.com>
Date: Wed, 14 Jan 2009 10:31:48 -0800 (PST)
Message-ID: <b66928c0-a0a1-405f-a079-aff2c4e97892_at_b1g2000yqg.googlegroups.com>

On Jan 14, 10:47 am, emdproduct..._at_hotmail.com wrote:
> Dear group,
>
> I am trying to debug a problem with FGAC, i enable the policy on a
> table
> When i do
> SQL>select count(*) from tableA where col=1;
>   COUNT(*)
> ----------
>          1
>
> I can get the row without problem
>
> But when i do
> SQL>select count(*) from tableA where col=1 for update nowait;
> no rows selected
>
> I do not see any errors, and i can not get the lock neither.
>
> What could be wrong?
>
> Thanks for your help

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 Received on Wed Jan 14 2009 - 12:31:48 CST