OraFAQ Forum: Server Administration » Space release after deleted database ffiles

Home » RDBMS Server » Server Administration » Space release after deleted database ffiles (oracle 10g)

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

Space release after deleted database ffiles [message #389733]

Tue, 03 March 2009 07:25

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

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

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:41:05 CDT 2024