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 remove a datafile from the database.

659828Apr 5 2010 — edited Apr 5 2010

Hi All,

I have a Oracle 9i (9.2.0.6) Database. I mistakenly added a datafile on tablespace AAA. I tried removing the datafile after making it to offline but it was not getting dropped. So we recreated the controlfile by taking current controlfile trace and removed the entry for that datafile (say aaa02.dbf). We were able to make the database up after recreating the controlfile. But if I query the datafiles for the tablespace it's showing the file name as /u01/oracle/9.2.0/dbs/MISSING0025. How can we remove this entry from the data dictionary.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2010

Added on Apr 5 2010

#general-database-discussions

7 comments

4,286 views