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: 65146
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: oracle uid
Next Topic: some sys view can not found
Goto Forum:

Current Time: Mon Aug 21 03:27:16 CDT 2017

Total time taken to generate the page: 0.14107 seconds