Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find out inactive tablespace?

jtomasicJun 25 2014 — edited Jun 25 2014

We are trying to clean up our database server by removing inactive tablespaces along w/ the owners to yield some disk space.  Please help me to find any inactive tablespaces on the server.  We have a known tablespace and file name that use up over 32 GB on the server and we would like to remove it but we want to make sure it is not actively being used before removing it.

Thanks a lot in advance for any/all the help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2014
Added on Jun 25 2014
4 comments
455 views