-
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..
-
Make sure that, no active table is in that TS. Then offline and drop it. Then delete if physically.
Thanks
Kishore Kumar
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|