Re: table reorg

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: raja4list@xxxxxxxxx, oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 06 May 2006 23:05:23 +0800


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


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006