Skip to Main Content
Forums

SQL & PL/SQL

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!

SQL to find orphaned tablespaces and datafiles

947200Apr 25 2016 — edited Apr 25 2016

I need an SQL that would list orphaned tablespaces and datafiles that have no user schemas linked to it.

In the past users had been dropped with cascade option, but never the tablespaces and datafiles. We need to cleanup the storage.

Thank you,

Dejan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2016
Added on Apr 25 2016
6 comments
2,449 views