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

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle partitioning issue

Re: oracle partitioning issue

From: felidae <m.mischke_at_gmx.net>
Date: 22 May 2006 05:12:55 -0700
Message-ID: <1148299975.578844.274670@j73g2000cwa.googlegroups.com> 





Hi,



use dbms_redefinition:



    
  
  1.   create interim table with new structure
  
  2.   start online redefinition session
  
  3.   create all indexes, triggers, ... on interim table
  
  4.   sync interim table
  
  5.   finish online redefinition session
  
  6.   drop interim table






see:


http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tables.htm#ADMIN01501



+ need only minimum downtime during step 5
- needs twice the disk space



Regards,


 Marco
Received on Mon May 22 2006 - 07:12:55 CDT












Original text of this message













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