Tablespace Management using Toad

You can view all of your tablespace information using toad tablespace screen from

 Database –> Administer –> TablespacesHere each table describes different

 detailed information across all the tablespaces in database. If you open this

 screen from the toad DBA module then you are also able to see the “space 

history” and “IO history” tab along with Files, Free space, object, Fragmentation.

With these tab you are able to able perform space monitoring and planning steps. 

These tab permits you check graphically space and IO usage over time.Through

 this way DBA are also able to estimate ‘Object size’ based on this estimation.

From the below “alter tablespace” tab you can

§         Modify the tablespace and datafile size.

§         Add new datafile to the tablespace.

§         Drop the existing tablespace.

§         Change the status of tablespace ‘online’ or ‘Read only’

§         Review schema object extent allocation.

§         Checking tablespace fragmentation.

For Example to edit the datafile click on datafile tab on the above screen