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. 


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


See messages in Message Explorer.


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


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


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