From: "Rath.Yelandur" <Rath.Yelandur@Spam.Nope>
Newsgroups: comp.databases.oracle.misc
Subject: Consolidating TableSpace
Date: Mon, 7 Jul 2003 13:27:16 -0400
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 63.104.15.5
Message-ID: <3f09ad8e@shknews01>
X-Trace: shknews01 1057598862 63.104.15.5 (8 Jul 2003 01:27:42 +0800)
Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!npeer.de.kpn-eurorings.net!newsfeed.freenet.de!nntp.gblx.net!news2.ilink.net!shknews01
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129101

TableSpace (DEV_DATA)  at the moment uses  8 datafiles
DevData01.dbf ... DevData08.dbf.

Some of the datafiles is larger than 2GB and the Free Bytes available is 50%
or higher.

I want to consolidate these 8 datafiles into 2-3 datafiles of 2GB each.
This will freeup the DiskSpace for other uses.

Question:
1.  Can I create a new TS and move all the data from DEV_DATA to
MY_TABLESPACE.
2.  What is the preferred way of accomplishing this task.

Please point me in the right direction...

Thanks in Advance,
Rath