| DBF files [message #207450] |
Tue, 05 December 2006 11:16  |
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 #207459 is a reply to message #207458] |
Tue, 05 December 2006 11:52  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
