RE: DBMS_REDEFINITION

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 19 Oct 2004 12:33:32 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501B9DEE8@25exch1.vicorpower.vicr.com>

In my experience you can move a table and rebuild the indexes without downtime. Things get a bit slower during the time your messing around, but they don't stop.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: David [mailto:thump_at_cosmiccooler.org]=20 Sent: Tuesday, October 19, 2004 12:21 PM To: oracle-l_at_freelists.org
Subject: DBMS_REDEFINITION

I would like to hear feedback on DBMS_REDEFINITION package for table/index reorg.
I like table move, index rebuild, but that does require some downtime...I amn told I can do same with package with no downtime.
--

..
David

--

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

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 19 2004 - 11:29:06 CDT