Home » RDBMS Server » Backup & Recovery » How to reorganize datafiles
How to reorganize datafiles [message #139454] Wed, 28 September 2005 01:57 Go to next message
StefanTA650
Messages: 9
Registered: May 2005
Junior Member
We have several datefiles making up our oracle intance. All of these datafiles are in use but some of them just for 1 or 2 percent. Is it possible to reorganize the data in the datafiles so that I can delete some of the dbf-files to save diskspace?
Thanks in advance for your support!!!

Regards,
Stefan
Re: How to reorganize datafiles [message #139457 is a reply to message #139454] Wed, 28 September 2005 02:16 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

you can not delete datafiles straightaway (tablespace owns datafiles). But you can do it by the following method

--> Create a new tablespace.

--> Move all the objects of less utilized tablespace/datafiles to the new tablespace.

--> Now delete the less utilized tablespace.

There might be some other methods also but this is the one that strikes my mind.
Let others get into this post.

regards,
tarun
Re: How to reorganize datafiles [message #139608 is a reply to message #139454] Wed, 28 September 2005 15:52 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

export the schema ..drop the tablespace (along with datafiles ) ..recreate with small size and import ..

This is applicable for a small / medium size schemas .. also if this is prod. db ..then outage times bla bla might also need to be considered ..

-Sai jeedigunta
Previous Topic: Oracle Backup problem
Next Topic: IMP-00016 required character set conversion (type 3 to 1) not supported
Goto Forum:
  


Current Time: Thu Mar 28 17:03:37 CDT 2024