dropping a tablespace ? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: dropping a tablespace ?

  1. #11
    Join Date
    Feb 2003
    Posts
    85
    Just drop the user XDB then drop the tablespace

  2. #12
    Join Date
    Sep 2003
    Posts
    7
    YES... YES !!!!!!!

    Y O U--A R E--R I G H T !!!!

    IT WORKED !

    i tryied to drop a tablespace called "TOOLS" - no broblem, just wrote :
    DROP TABLESPACE TOOLS INCLUDING CONTENTS AND DATAFILES;

    worked just fine. then i tryied the same for the tablespace XDB and it didnt worked. so, i started to think that the XDB tbs is somehow more problematic to mannage (like SYSTEM tbs or somthing).

    BUT Then You Came along and you were absolutly RIGHT !
    I Dropped the user XDB and then the tbs :

    DROP USER XDB CASCADE;
    (Cascade - Drops all the user Objects as well.)
    and then :

    DROP TABLESPACE XDB INCLUDING CONTENTS AND DATAFILES;

    Worked Just Fine !!!

    Thank You guru_heaven You are ACE .


  3. #13
    Join Date
    Feb 2003
    Posts
    85
    that was the brute force solution

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