ORA-00052

[gunjan14]

Hi,

I am working on Oracle 8.0.6. And initialization parameter
ENQUEUE_RESOURCES is set to be 524.
When I give the command
drop tablespace <tablespace_name> including contents;

Nearly 60% of the time (I have noticed), the error occurs
ORA-00604: error occurred at recursive SQL level 1
ORA-00052: maximum number of enqueue resources (524) exceeded


But if I first drop the tables individually for the tablespace and then drop the tablespace then I do not get this error.

I do not know why this happens or can anyone tell me what can be the probable cause for this?

Gunjan

 

[elam68]

Hi,

Set a big rollback segment then try with the same script.
bye