Procedure compile error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Procedure compile error

  1. #1
    Join Date
    Oct 2000
    Posts
    24
    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

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Unhappy 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

  3. #3
    Join Date
    Oct 2000
    Posts
    24
    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.


  4. #4
    Join Date
    Jan 2001
    Posts
    642
    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
  •  



Click Here to Expand Forum to Full Width