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 -> Convert a non-partitioned table to partitioned table

Convert a non-partitioned table to partitioned table

From: David YEUNG <dyeung_at_ust.hk>
Date: Fri, 20 Apr 2001 16:03:41 +0800
Message-ID: <3ADFED5D.8578C3B8@ust.hk> 






I have a number of tables growing quite large and I would like
to convert them to partitioned tables. Could anyone tell me what
is the best way to convert a normal table to a range partitioned
table? Do I need to re-create the table using partition clauses
and then re-load the data into it, or can I use the 'alter table ...'
statement to do so?



Thanks



david
Received on Fri Apr 20 2001 - 03:03:41 CDT












Original text of this message













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