-
Hi ,
When I try to compile any procedure I get this error
The following error has occurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: You are not allowed to DROP
ORA-06512: at line 4
Please advise
Thanks
-
privs?
sounds like the creator of the procedure does not have DROP privs. Is this possibly the case?
otherwise please post the portion of the procedure that is receiving the error.
- magnus
-
Hi,
Thanks for your reply ,but this is not the case.
This error comes whenever any procedure is compiled or whenever yuu try to create a new one.
-
Came across from one of the posting:
Seems there is too less space for the SYSTEM tablespace.
In a runnding database environment one could use something
like
ALTER TABLESPACE
ADD DATAFILE SIZE 50M
AUTOEXTEND on
NEXT 20M
MAXSIZE 500M;
Let me know if this works
Badrinath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|