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

Thread: tablespace

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    What steps are involved in dropping a tablespace?

  2. #2
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    1)Make a backup of the tablespace you are going to drop
    2)
    SQL>alter tablespace TABLESPACENAME offline;
    SQL>drop tablespace TABLESPACENAME including contents;
    3) then drop the datafile associated with the TABLESPACE in your system.

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    If you are not using 8i, you will not be able to take tablespace space backup, and only way is to backup all the users using that tablespace and then drop it.

    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Good points. In my case, I assign one tablespace to one particular user and it is easier to manage and plus I do have enough diskspace.

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In fact.. you can take backup of a tablespace in version 7 also if you are running in arcihvelog mode.

    Sanjay

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