Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Live Reorganize from SQL-script?

Re: Live Reorganize from SQL-script?

From: Brian <brian_at_databaseknowledge.com>
Date: 30 Apr 2005 14:11:21 -0700
Message-ID: <1114895481.554246.306340@g14g2000cwa.googlegroups.com> 





In 92R2 and 10g you reorg tables online using DBMS_REDEFINITION.  This
works really well, I'ved used it a lot.  Clients are able to
ins/upd/del during the reorg process, however if you can turn off any
batch type of operations you should.



see:


http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96612/d_redefi.htm
Received on Sat Apr 30 2005 - 16:11:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US