Toad World Blog

How to quickly assign Tablespace to various objects

Feb 11, 2013 3:30:00 PM by Vaclav Frolik

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!

Tags: Toad Data Modeler Data Modeling

Vaclav Frolik

Written by Vaclav Frolik

Interests:

  • UX design and graphics
  • Databases
  • Product / Project management
  • Web technologies
  • Online marketing

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