Home » RDBMS Server » Server Administration » To reduce number of datafiles in tablespace (ORACLE database RHEL 4.5)
To reduce number of datafiles in tablespace [message #544931] Sat, 25 February 2012 02:38 Go to next message
Messages: 3
Registered: May 2010
Location: pune
Junior Member
Dear associates,

We have two tablespace xyz_ts & pqr_ts having 167 datafiles
We have to reduce this number of files. These tablespace having 580 GB size
Please suggest the best workaround for this activity.


[Updated on: Sat, 25 February 2012 02:41]

Report message to a moderator

Re: To reduce number of datafiles in tablespace [message #544935 is a reply to message #544931] Sat, 25 February 2012 03:41 Go to previous message
Michel Cadot
Messages: 64953
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create new tablespaces and move the objects to these ones then delete the previous tablespaces (and possibly rename the new ones if names are important for you).
Of course you will say you have not the double of space, and I will answer you can move the objects file per file, so you don't need not so much adding space.

Previous Topic: How to change the character set ?
Next Topic: change from nologging to logging
Goto Forum:

Current Time: Sun Jun 25 22:53:42 CDT 2017

Total time taken to generate the page: 0.08274 seconds