RE: DBMS_REDEFINITION

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <thump@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 19 Oct 2004 12:33:32 -0400

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@xxxxxxxxxxxxxxxx]=20
Sent: Tuesday, October 19, 2004 12:21 PM
To: oracle-l@xxxxxxxxxxxxx
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

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

Other related posts: