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

Thread: Ts dropping and creation

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    4
    what precautions do we have to take while dropping a TS and creating a new one. "Also I should remove the datafile physically right" once the TS is dropped..
    Thx..

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Make sure that, no active table is in that TS. Then offline and drop it. Then delete if physically.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Make sure, if you do not have any users/schemas defaulted to the tablespace you are above to drop and alter those users to other tablespace if you do have...

    Use 'INCLUDING CONTENTS' and 'CASCADE CONSTRAINTS' otherwise you get an error... if you have any constarints.

    You can drop when its online. But, recommended to make it offline and then drop...


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