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!

Dropping a datafile

572552Apr 20 2007 — edited Apr 20 2007

Can we drop one datafile from a tablspace?

I have a tablespace TS1 which has 3 datafiles.i made one datafile offline and trying to drop that particular datafile....is it possible ?

SQL> alter database datafile 'E:\ORACLE\ORADATA\TESTDB\KISH1.DBF' DROP;
alter database datafile 'E:\ORACLE\ORADATA\TESTDB\KISH1.DBF' DROP
*
ERROR at line 1:
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

the errror is we are not giving the right option but Oracle itself is suggesting a DROP option...CAN ANYONE HELPME OUT

THANKS

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2007

Added on Apr 20 2007

#general-database-discussions

7 comments

1,317 views