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!

Delete Data Files

603447Dec 20 2010 — edited Dec 21 2010
I am using Oracle 10g Database on Windows Server 2003. I have TBSTEST tablespace with 10 datafiles (1GB size each). I want to remove one datafile without data loss. Can you help us list down the steps on how to handle this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2011
Added on Dec 20 2010
17 comments
405 views