Hello Fellow Toad Users and Toad Gurus,
We have a legacy system where 451 tables were improperly placed in the USERSPACE1 tablespace instead of the tablespace defined for them. I have been tasked to fix this. Using Toad, when I select 1 table I can change the tablespace and it generates the correct code, but when I select 2 to 451 tables it does not give me the option to change the tablespace. Does anyone have a methodology I can use to make these changes without going to 451 separate tables and making the change. Thanks for your help!