RE: Differences between Table Move and table Export

From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
To: <maheswara.rao@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 23 Sep 2008 08:10:37 -0700

maheswara.rao@xxxxxxx wrote:

> We have tables that are highly fragmented.  We are planning to reorg these
tables...
> Our aim is to reclaim the disk space and reset HWM.
> 
> If we use Alter table move, does the HWM get reset

Yes, alter table move resets the HWM.  Between exp/imp and alter table move,
the latter seems far simpler. However, it would be helpful if you could
state more clearly what the problem is that you are trying to solve, what
you mean by 'fragmentation,' and your version of Oracle.  Depending on the
version, there may be other options available to you that can minimize
disruption.  Please see:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#AD
MIN10161

http://tinyurl.com/4a8emf

Regards,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Differences between Table Move and table Export
From: maheswara . rao

References:
- Steps to Upgrade Rman Catalog Database.
  - From: Shanmugam, Dhandapani
- Re: Steps to Upgrade Rman Catalog Database.
  - From: Bradd Piontek
- Differences between Table Move and table Export
  - From: maheswara . rao

RE: Differences between Table Move and table Export

Other related posts: