Download package TablespacesAssignment and import it to Toad Data Modeler.  Select entities in Physical Model Explorer, right click on any of them and choose Macros | Tablespace Assignment. 

tblspc1.png-550x0

New custom dialog opens. Select existing Tablespace and click Execute.

 tblspc2.png-550x0

See messages in Message Explorer.

 tblspc3.png-550x0

If you wish to assign Tablespace to various objects and find manual selection in Physical Model Explorer difficult, use Object Viewer (Objects | Object Viewer). Search for entities and indexes (use wildcards..) and then select all items in resultset, right click any of them and choose Macros | Tablespace Assignment.  I guess you know what happens and how to continue simple-smile-1

tblspc5.png-550x0

Of course, the macro works fine for objects/shapes selected on workspace too.

tblspc6.png-550x0

Good Luck!

About the Author

Vaclav Frolik

Interests: UX design and graphics, Databases, Product / Project management, Web technologies, Online marketing and Favorites: Music bands: Pearl Jam, Audioslave, RHCP, Midnight Oil, Alter Bridge... Actors: Kevin, Edward, Jack, Jeff and my kids. Actresses: Kim, Jennifer Sports: MTB, Squash, Football (the one played with feet, not hands) Series: IT Crowd, The Big Bang Theory

Start the discussion at forums.toadworld.com