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

Thread: DROP USER CASCADE

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145
    hello,

    Iam using Oracle 8i personel database on Win NT .

    when i fire a command it gives error

    SVRMGRL> DROP USER SCOTT CASCADE;

    ora-00604 error occrued at recursive SQL level 1
    ora-00949 table view does not exits
    ora-06512 at line 7

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sqlplus "/ as sysdba"

    alter session set events '10046 trace name context forever, level 12';

    DROP USER SCOTT CASCADE;

    exit;

    go to your udump and look for the trace file and see what it says

    look your alert in bdump
    look trace file generated by 00604 in udump

  3. #3
    Join Date
    Jan 2002
    Posts
    13
    Actually this is a well-known bug ... Support will be able to help you .. involves running one of the $ORACLE_HOME/RDBMS/Admin scripts .. catnoque.sql I think.

    The problem is due to the user having acquired Temporary segments that are not released properly ... doesn't happen if using proper Temporary tablespace tempfiles on 8i +.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter

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