Re: table reorg

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 06 May 2006 23:05:23 +0800
Message-Id: <6.2.1.2.0.20060506230111.01ff5360@pop.singnet.com.sg>

You could query DBA_SEGMENTS to see if a new Segment is being built. With Index rebuilds, I have seen that the new Segment is a TEMPORARY segment till the rebuild is completed. A Table MOVE should also be creating a like segment.

Hemant
At 10:46 PM Saturday, you wrote:
>Hi All,
>
>How to track the table reorg:
>
>alter table xyz move;
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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

Received on Sat May 06 2006 - 10:05:23 CDT