Home » RDBMS Server » Server Administration » Space release after deleted database ffiles (oracle 10g)
Space release after deleted database ffiles [message #389733] Tue, 03 March 2009 07:25 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I have done one mistake on the database.

I deleted database files from the partitions without shutting down the database.
Because of that the space is not releasing from disk

What can i do?
How can i relese the space?
Re: Space release after deleted database ffiles [message #389739 is a reply to message #389733] Tue, 03 March 2009 07:30 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I have delete those files just from the operating system Sad
Acutally my database creation failed thats why i want to create database again.
So i deleted every file related to oracle with
rm filename
Re: Space release after deleted database ffiles [message #389759 is a reply to message #389733] Tue, 03 March 2009 08:13 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Shut down the database.

Regards
Michel
Previous Topic: Database creation stopped
Next Topic: ORA-01000: maximum open cursors exceeded error
Goto Forum:
  


Current Time: Fri Dec 09 05:58:12 CST 2016

Total time taken to generate the page: 0.09460 seconds