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

Thread: DROP TABLESPACE

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

    Question

    Iam using Oracle 9i on winNT

    When i fire these command i got these ERROR ?

    Drop tablespace r_data8 including contents and datafiles
    *
    ERROR at line 1:
    ORA-00060: deadlock detected while waiting for resource

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I wonder if this could be aa trigger that is firing when your are dropping the table. If I was doing this I would drop all of the tables and indexes in that tablespace then drop the tablespace and see if that works. then I would do the following:
    Drop tablespace r_data8 including contents;

    If all of the tables and indexes are owner by the same user I would do a:
    drop user uname cascade;

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