"lock table in exclusive mode"

From: charlie s <word)_at_yahoo.com>
Date: Fri, 20 Sep 2002 01:05:11 GMT
Message-ID: <bvui9.18348$t%6.1233@nwrddc02.gnilink.net>

I am using Oracle817.
I am developping a script in which I want to

1) lock the table
2) refresh the materialized view
3) drop the table

The problem is, after I lock the table in exclusive mode, if there is another session trying to do DML on the table, the session will be hanging there, as soon as I issued "drop table", the lock is released, the I will get an error
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

How can I lock the table so that other session will get an error if they try to do DML on the table instead of waiting there?

Thanks for your help Received on Thu Sep 19 2002 - 20:05:11 CDT