OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » deleting data files (10.2.0.1.0)

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

deleting data files [message #324484]

Mon, 02 June 2008 14:00

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

BlackSwan
Messages: 26766
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!

Report message to a moderator