Home -> Usenet -> comp.databases.oracle -> Splitting a table partition

Splitting a table partition

From: Vissu <vissuyk_at_yahoo.com>
Date: 25 Dec 2002 20:33:02 -0800
Message-ID: <2bedd6a7.0212252033.4ea9c633_at_posting.google.com> 






Hi,



I have a table with several partitions. The latest partition (key is
date column) has values less than MAXVALUE.  The table has several
local indexes on it. It's too large and I'd like to split the latest
partition.  I have the following questions:



    
  
  1.   Can I simply split the partion and expect everything to work
  
  2.   What about indexes, do I have to re-create them or will they be
split along with the table ?. I'd like to specify a new tablespace for
the newly partitioned index. How can I do that
  
  3.   How can I specify a tablespace for the newly partition data ?
Should I move the rows between tablespaces after the split
  
  4.   Can anyone share any experience with me.






The database is Oracle 9i. Any help is higly appreciated.



Thanks a lot



Vissu
Received on Thu Dec 26 2002 - 05:33:02 CET












Original text of this message