Oracle Error Message
ORA-00057: maximum number of temporary table locks exceeded
Reason for the Error
You attempted to start a database whose initialization file DB BLOCK SIZE parameter value did not match the value used when the database was created.
Solution
There are few options to fix this error.
- Check that you’re mounting the right database.
- Check that you’re using the right initialization file.
- In the initialization file, you may need to change the DB BLOCK SIZE parameter.