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?

Report message to a moderator

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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Shut down the database.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:07:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.