Skip to Main Content

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 from a offline tablespace

455759Jan 13 2009 — edited Jan 14 2009
We are running oracle 9.2 on windows.

Out of the 3 datafiles in a non-system tablespace A, one datafile A-DF1 was accidently droped from the file system by our DBA.

The other two datafiles were brought online by using the ALTER DATABASE RECOVER command by bringning the database in mount phase.

Now we want to remove that datafile A-DF1 from the tablespace and bring that tablespace online.

The database is not in archive mode and no cold backup was present.

The solution that we want to try is:

1-drop the tablespace A without dropping the datafiles
2-create a new tablespace and reuse those datafiles
3-assign this new tablespace to the affected user

Would this work? Do you have any other safe solution for this problem?

thanks
Imran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2009
Added on Jan 13 2009
4 comments
409 views