|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
Location: Blogs
Jeff Smith's Blog
|
|
| JeffSmith |
3/31/2009 |
This was a question I got this morning from a customer. I showed them how to do this with the ‘Alter’ dialog in Toad’s Schema Browser. However, they wanted to do it for more than one table at a time, and apparently some OTHER tool could do so. Why couldn’t Toad?
Great question. It turns out that IT CAN INDEED do so. Here’s how:
Step 0: Open the ‘Rebuild Multiple Objects’ window
Step 1: Load and Check tables
Step 2: Select new tablespace (by size)
Step 3: View Script (or just execute)
Here is what is generated and ran on your behalf:
So, we can do anything ‘your other tool’ can do and more (if not better)! |
|
| Permalink |
Trackback |
Comments (2)
|
By HunterX on
4/1/2009 |
Move tablespaces ... that make indexes 's unusable.
How can Toad help ?
|
|
|
By hillbillyToad on
4/1/2009 |
Great question!
When you're done moving your tables, go to the Indexes tab in the 'Rebuild Multiple Objects' screen.
Choose the 'Load Indexes of Checked Tables' option.
Toad will highlight your unusable indexes.
Check them.
Rebuild them.
So, this is a two-step process. |
|
|
|
|
|
|
|
|
|
|