Differences between Table Move and table Export

From: <maheswara.rao_at_ubs.com>
Date: Tue, 23 Sep 2008 10:54:09 -0400
Message-ID: <2FCB63BD2F527141842CFB7A9F4C645303E90822@NLNHC012PEX.ubsamericas.net>


We have tables that are highly fragmented. We are planning to reorg these tables. Currently these tables are in LMT that NON ASSM type. We created tablespace with type ASSM.  

These are large tables with sizes 70 GB to 100 GB.  

Our aim is to reclaim the disk space and reset HWM.  

Should we use Alter table move or Export and import commands to do this job?  

If we use Alter table move, does the HWM get reset/ does the unused space below HWM can be reclaimed with Alter table move?  

What are the differences between table export and alter table move (if our objective is to reorganize the tables to claim the space).  

Please provide your views or please point me to the sites where I can get this info.  

Regards,  

Rao  

Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.

UBS International Inc.

UBS Financial Services Incorporated of Puerto Rico

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 23 2008 - 09:54:09 CDT

Original text of this message