OraFAQ Forum: Server Administration » Remove datafile from operating system after droping its tablespace

Home » RDBMS Server » Server Administration » Remove datafile from operating system after droping its tablespace (Oracle Database 11g Release 11.2.0.1.0 - 64bit Production, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remove datafile from operating system after droping its tablespace [message #561940]

Thu, 26 July 2012 06:07

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

Hi all,

I want to remove a tablespace with it's datafile.

I've ran:
DROP TABLESPACE x_tbs INCLUDING CONTENTS;

I've read(should have read it prior to action)
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9004.htm

and I understand now that I should have stated "AND DATAFILES",
However, too late now. the tablespace is removed,
but the datafile x_tbs is still present in a folder of my OS.

Is it safe to manually remove it by deleting it from the operating system?

Regards,
Andrey

Report message to a moderator