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!

Reg: Datafile

New_To_Oracle_7912Oct 3 2012 — edited Oct 3 2012

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf' OFFLINE DROP;

it will work. but when u'll check status in v$datafile it will show RECOVER there. means datafile is still present in data dictionary.

then the question is how to remove in from there???

plz tell me

Oracle11g

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2012

Added on Oct 3 2012

#general-database-discussions

2 comments

95 views