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!

Droping a datafile from a tablespace

792446Feb 16 2012 — edited Feb 16 2012

I want to drop a datafile from a tablespace by using the query
SQL> alter tablespace TS1 drop datafile 'OS path\df1';

This query drops the datafile. But physically the datafile is present in the OS path. how to delete the datafile completely from the disk.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2012

Added on Feb 16 2012

#dba, #general-database-discussions

11 comments

346 views