Re: Reorg active table
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 27 Aug 2008 17:01:43 -0700 (PDT)
Message-ID: <cf872710-21f6-4451-83ad-9b0c98d9bf7b@f63g2000hsf.googlegroups.com>
Date: Wed, 27 Aug 2008 17:01:43 -0700 (PDT)
Message-ID: <cf872710-21f6-4451-83ad-9b0c98d9bf7b@f63g2000hsf.googlegroups.com>
On Aug 27, 4:25 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I need to reorg an active table( lot of insert/update/delete)
> I would like to do a move tablespace to shrink the table.
> How can I lock all the DML and do the move ?
> Thanks in advance
> Oracle 9.2.0.6
Read the doc on dbms_redefinition is one way. Received on Wed Aug 27 2008 - 19:01:43 CDT