Newsgroups: comp.databases.oracle.misc
Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.cc.ukans.edu!logbridge.uoregon.edu!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news
From: Brian Peasland <oracle_dba@remove_spam.peasland.com>
Subject: Re: Consolidating TableSpace
X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov
Content-Type: text/plain; charset=us-ascii
Message-ID: <3F09B0E3.F68BC191@remove_spam.peasland.com>
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: U.S. Geological Survey, Reston VA
X-Accept-Language: en
References: <3f09ad8e@shknews01>
Mime-Version: 1.0
Date: Mon, 7 Jul 2003 17:41:55 GMT
X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U)
Lines: 44
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129103

You can create a new tablespace and move the objects to the new ts. This
can be done as follows:

1. For tables: ALTER TABLE table_name MOVE TABLESPACE new_ts;
2. For indexes: ALTER INDEX index_name REBUILD TABLESPACE new_ts;

Otherwise, you can export the objects, drop the tablespace and remove
the datafiles, recreate the tablespace, and then import the objects.

HTH,
Brian

"Rath.Yelandur" wrote:
> 
> 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

-- 
===================================================================

Brian Peasland
oracle_dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"