Error when dropping a user.....HELP!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error when dropping a user.....HELP!!!

  1. #1
    Join Date
    Aug 2001
    Posts
    8

    Exclamation

    guys,

    (running 8.1.6 on solaris)

    I am trying to drop a user like so..

    drop user IFSAPP cascade;

    but I am getting the following errors...

    sqlplus> drop user IFSAPP cascade;
    drop user IFSAPP cascade
    *
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

    any ideas?
    Cheers


    Rich H

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    I have got this problem resolved by running catnoqueue.sql & catqueue.sql from sys/system user. As this script created the Dict. Table reqd. for Advanced Queues even though I am not using any of Advanced Queuing.
    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did you recently upgrade?

    If yes, then you probably did not all run necessary scripts as SYS.

    If that is not your case, then enlarge the SYSTEM datafile or just add a datafile to the SYSTEM tablespace (you might not have enough space is the SYSTEM tablespace).

    I suspect it is the 2nd :-)









  4. #4
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    that was a bug fixed later ...look for metalink docs
    sonofsita
    http://www.ordba.net

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Bug like this was in Oracle 9i (9.0.1) v.1 for Solaris
    I fixed it thru executing some scripts from catalog.sql but I can't remember exactly whitch of scripts.

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