Home » RDBMS Server » Server Administration » deleting data files (10.2.0.1.0)
deleting data files [message #324484] Mon, 02 June 2008 14:00 Go to next message
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

Re: deleting data files [message #324485 is a reply to message #324484] Mon, 02 June 2008 14:03 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You have to move all the objects out of the 2 tablespaces,
drop those 2 tablespace & create the tablespaces with appropriately sized files.

Hope This Helps!
Re: deleting data files [message #324486 is a reply to message #324485] Mon, 02 June 2008 14:22 Go to previous messageGo to next message
simoh
Messages: 6
Registered: May 2008
Junior Member
Thank you for the kind reply.

However, this is the production server. Would it be possible to do that without any downtime?
Re: deleting data files [message #324489 is a reply to message #324484] Mon, 02 June 2008 14:57 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_redefi.htm#i998265
Previous Topic: insufficient prev
Next Topic: Index creation statement
Goto Forum:
  


Current Time: Thu Dec 08 10:41:55 CST 2016

Total time taken to generate the page: 0.08414 seconds