deleting data files [message #324484] |
Mon, 02 June 2008 14:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
simoh
Messages: 6 Registered: May 2008
|
Junior Member |
|
|
Hi,
We were facing problems with 2 tablespaces in Oracle 10.2.0.1.0. They were increasing rapidly. The only solution that we had at that time is to add more data file into those tablespaces. The application support team discovered a bug and that made those tablespaces to shrink to a smaller size.
Now as we have 9 huge different data files that only holds small data.
My question is: is there a way to move the data into only 5 data files and then delete the other 4??
I hope I am explaining this the right way…
Thank you
Mohammed
[Updated on: Mon, 02 June 2008 15:12] by Moderator Report message to a moderator
|
|
|
|
|
|