Home » RDBMS Server » Server Administration » Deleting a data file
Deleting a data file [message #54927] Mon, 16 December 2002 15:42 Go to next message
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.

Report message to a moderator

Re: Deleting a data file [message #54930 is a reply to message #54927] Mon, 16 December 2002 21:40 Go to previous message
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;

Report message to a moderator

Previous Topic: Character mode and block mode,which one is better?
Next Topic: Re: enabling Object features in Oracle 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 20:31:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.