Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Red face Unanswered: Drop user in 9.2.0.1

    Hi,
    I am trying to drop user in Oracle 9.2.0.1 but the following error is encountered.

    DROP USER DEMO1 CASCADE
    ORA-00604: error occurred at recursive SQL level 1
    ORA-24170:
    ORA-06512: at "SYS.DBMS_RULE_ADM", line 128
    ORA-06512: at line 1

    Any clue?
    Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    undo tablespace full?

    as a workaround you can write a generic script deleting all the objects
    select ' drop '|| object_type || ' ' || owner ||'.' || object_name || ';' from all_objects where owner = 'DEMO1';

  3. #3
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140

    Re: Drop user in 9.2.0.1

    Originally posted by kbtcyan
    Hi,
    I am trying to drop user in Oracle 9.2.0.1 but the following error is encountered.

    DROP USER DEMO1 CASCADE
    ORA-00604: error occurred at recursive SQL level 1
    ORA-24170:
    ORA-06512: at "SYS.DBMS_RULE_ADM", line 128
    ORA-06512: at line 1

    Any clue?
    Thanks in advance.
    I remember a similar problem. Which user (and how) are you connected with ? SYS as SYSDBA ?

  4. #4
    Join Date
    Oct 2003
    Posts
    2

    Re: Drop user in 9.2.0.1

    Originally posted by cvandemaele
    I remember a similar problem. Which user (and how) are you connected with ? SYS as SYSDBA ?
    I am connected with SYS as SYSDBA. Recall anything?

  5. #5
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    Working with SYS AS SYSDBA worked for me, but does not seem to help you.

    Did you try to shutdown and restart the database, before dropping DEMO1 ?

    Are there any invalid objects in DEMO1 ? If so, maybe try to recompile them first.

    I've looked up the error messages in the Oracle documentation

    <<<START DOCUMENTATION>>>
    ORA-00604 error occurred at recursive SQL level string

    Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

    Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.
    <<<END DOCUMENTATION>>>

    The next error in the stack (ORA-24170) is not even referenced. You might want to open a TAR at Oracle.

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •