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)
Remove datafile from operating system after droping its tablespace [message #561940] Thu, 26 July 2012 06:07 Go to next message
Andrey_R
Messages: 187
Registered: January 2012
Location: Euro-Asia
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
Re: Remove datafile from operating system after droping its tablespace [message #561948 is a reply to message #561940] Thu, 26 July 2012 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 57599
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but as you are on Windows you will be able to do it only after database shutdown.

Regards
Michel

[Updated on: Thu, 26 July 2012 06:30]

Report message to a moderator

Re: Remove datafile from operating system after droping its tablespace [message #562178 is a reply to message #561948] Mon, 30 July 2012 03:20 Go to previous message
Andrey_R
Messages: 187
Registered: January 2012
Location: Euro-Asia
Senior Member

Thanks Michel.
I successfully deleted the datafile from my OS without any issues.

Regards,
Andrey
Previous Topic: Negative Values of Library Cache Hit Ratio in AWR Report
Next Topic: Empty database
Goto Forum:
  


Current Time: Wed Apr 16 06:21:51 CDT 2014

Total time taken to generate the page: 0.06793 seconds