Re: utllockt.sql

Since catblock should have been ran when your database was built I believe that your problem is one of three things:

1. The table is missing. If this is true it is probably because Oracle has had a syntax error in one of its lock scripts since 7.0. Connect as sys and run the script with echo on. Check the results. If you see an error message it should be due to a comment near the end of the SQL statement if my memory is correct.
2. If the table exists check the synonym.
3. If the synonym is present then issue a grant select to ......

I hope this helps.

vich__at_hotmail.com wrote in article <71vgke$guf$1_at_nnrp1.dejanews.com>...
> Hi everybody..
>
> I have been unable to run a utllockt.sql script to check whether there
are
> processes that are waiting on others because of the locks. The error I'm
> getting is that the table dba_locks can't be found. Indeed I can't find
this
> table in the database. Is there a special script I need to run to create
this
> table?
>
> TIA
>
> Gene
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Mon Nov 09 1998 - 08:35:05 CST