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: 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
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: 68618
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: 441
Registered: January 2012
Location: Israel
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: Tue Mar 19 05:05:10 CDT 2024