Skip to Main Content
Forums

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!

When the last time a datafile was used

Dan AApr 18 2011 — edited Apr 18 2011
Hello.

This is from Solaris box, running Oracle 8.1.7.4.0.

There are two datafiles, actually three, that were created for three tablespaces. These in total take up more than 3G on the server and space is at a premium.

I suspect that these files can be removed but I need to understand when the last time they were used and if it is safe to remove them.

Each of these files was created as 800M files and each has 799.99M remaining.

Thank you for any advice.

DA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2011
Added on Apr 18 2011
#general-database-discussions
11 comments
489 views