Error while drop user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Error while drop user

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Error while drop user

    When i have tried to drop ACC user i got fllowing error

    SQL>DROP USER ACC CACSADE;

    drop user acc
    *
    ERROR at line 1:
    ORA-01001: invalid cursor
    ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [],
    [], [], []



    After getting this error i have checked than there is no object in ACC user.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    From metalink:
    Code:
    Symptoms
    
    ORA-600 [qmxiUnpPacked2] [121 being reported during a drop user on a new 9.2.0.7 database.
    
    Cause
    
    This is generally caused by an invalid upgrade from earlier release.
    If a database is created with the DBCA at 9.2.0.7 and one of the "seed" databases are used (not the "New Database" option),
    then this seed database is at 9.2.0.1.
    Once the create database is complete it needs patching to 9.2.0.7
    
    This error occurs due to XMLType data that has not been successfully upgraded from a previous version.
    
    Solution
    
    To implement the solution, please execute the following steps:
    
    1)SQL> shutdown immediate
    
    2)SQL> startup migrate
    
    3)SQL> spool patch.log
    
    4)SQL> @?/rdbms/admin/catpatch
    
    5)SQL> spool off
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks jmodic.

    I follow the steps as mention by you.

    My problem is solved

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