Oracle Locks - ORA00054

Most of the self-help website outthere would suggest that whenever you encounter the ORA-00054 error message; just go check the tables like DBA_BLOCKERS and the likes to weed out the root cause.

Well for typical users like me, every time I run the command "select * from DBA_BLOCKERS" the only reply I get from the DB would be something like "object does not exist".


That is until I found out that you actually had to run a script for all of those "DBA lock"-related table to be created.

Simply go to $ORACLE_HOME/rdbms/admin directory and run catblock.sql script. And owh yeah - you might need to have admin privileges for this to work.


Popular posts from this blog

HIVE: Both Left and Right Aliases Encountered in Join

Assign select result to variable in Netezza stored procedure

Splitting value in Netezza using array_split