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!

Drop datafile

user13726158Oct 3 2011 — edited Oct 3 2011

Hello,

I need to drop one datafile, but I get following ORA-03264: "cannot drop offline datafile of locally managed tablespace"
*Cause: Trying to drop offline datafile in lmts
*Action: Try to drop file afetr making it online"

When I try to do respective tablespace online so I get the following Ora Errors: ORA-01122: "database file %s failed verification check", ORA-01110, ORA-01210

How to do drop this datafile?

Thank you for advice.

This post has been answered by Aman.... on Oct 3 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2011

Added on Oct 3 2011

#general-database-discussions

9 comments

1,119 views