Deleting a data file [message #54927] |
Mon, 16 December 2002 15:42 |
skd_1507
Messages: 2 Registered: December 2002
|
Junior Member |
|
|
Hello All,
How do we delete a datafile of a tablespace thru oracle?
Otherway, Oracle is not seems to be deleting the data files when I drop the table space. Is that I have to use special option or I have to delete manually?
Thanks in advance.
|
|
|
Re: Deleting a data file [message #54930 is a reply to message #54927] |
Mon, 16 December 2002 21:40 |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
Use this if you want Oracle to delete the datafiles also when you drop the tablespace
DROP TABLESPACE TABLESPACENAME INCLUDING CONTENTS AND DATAFILES;
|
|
|