Re: lock table

LOCK TABLE table IN EXCLUSIVE MODE NOWAIT;

ERROR at line 1:
ORA-01031: insufficient privileges
ORA-02063: preceding line from ORACLE

This is in Oracle 9i (9.2.0.4.0)

Thanks,
Andrew

bdbafh_at_gmail.com wrote:
> lark047_at_gmail.com wrote:
> > Hi,
> >
> > I am confused why I can't lock a particular table. The table is not in
> > my schema, but I do have some object privileges on it (insert, delete).
> > Everything I've seen says that's all I need:
> >
> > One of 3
> > - LOCK ANY TABLE
> > - owner of table
> > - object privileges on table
> >
> > Help?
> >
> > Andrew
>
> what is the statement that you are attempting to execute? (include it)
> what is the error message? (include it)
> what version of oracle? (include it).
>
> -bdbafh
Received on Fri Jun 02 2006 - 07:10:05 CDT