Reorg active table

From: astalavista <nobody_at_nowhere.com>
Date: Wed, 27 Aug 2008 22:25:37 +0200
Message-ID: <48b5b83a$0$20496$426a74cc@news.free.fr>

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 Received on Wed Aug 27 2008 - 15:25:37 CDT

This message: [ Message body ]
Next message: Julian Mensch: "Re: Trigger Timeout Loop Issue"
Previous message: Steve Howard: "Re: about "cursor: pin S wait on X" wait event."
Next in thread: Robert Klemme: "Re: Reorg active table"
Reply: Robert Klemme: "Re: Reorg active table"
Reply: Palooka: "Re: Reorg active table"
Reply: hpuxrac: "Re: Reorg active table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message