Home » RDBMS Server » Performance Tuning » DBF files
DBF files [message #207450] Tue, 05 December 2006 11:16 Go to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Hi,

If i delete the dbf file from the oracle database,will this deletion effect anything.

Thanks,
Srinivas
Re: DBF files [message #207452 is a reply to message #207450] Tue, 05 December 2006 11:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
well, obviously you loose the data stored in concerned tablespace via tables. You need to do it gracefully ,within oracle.
Directly deleting the files in OS, would be disastrous.
Question is Why? Why are you deleting the datafile?
Before doing anything, consult the documentation
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/dfiles.htm#sthref1392
Re: DBF files [message #207458 is a reply to message #207452] Tue, 05 December 2006 11:48 Go to previous messageGo to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Thanks for your reply.
I want to delete ,because it is occupying 30GB space.
Re: DBF files [message #207459 is a reply to message #207458] Tue, 05 December 2006 11:52 Go to previous messageGo to next message
HibsMax
Messages: 4
Registered: December 2006
Location: Massachusetts
Junior Member
It would be better to delete the data from within Oracle and then resize the datafiles to retrieve unused space.
Re: DBF files [message #209330 is a reply to message #207450] Thu, 14 December 2006 05:45 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Deleting datafiles just because they occupy space is never a good idea. Datafiles are meant to hold data.

What you should be looking at is
1) What kind of data does the tablespace which has this 30G file hold and how cruicial it is to the org?
2) Can you archive some of the data or delete some data off of this tablespace?
3)Do you have sufficient space on the server to do some re-org?

Try these first and then decide with the proper permissions to delete the datafile!!

V
Previous Topic: session cached cursors
Next Topic: Looking for a guru
Goto Forum:
  


Current Time: Tue Dec 03 20:15:57 CST 2024