Re: Reorg active table
Date: Wed, 27 Aug 2008 17:01:43 -0700 (PDT)
On Aug 27, 4:25 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> 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 18.104.22.168
Read the doc on dbms_redefinition is one way. Received on Wed Aug 27 2008 - 19:01:43 CDT