Re: Splitting a table partition

The best way to answer your questions is to try it out for yourself. Build a simple partitioned table and just test it. Putting a partition into a specific tablespace is the easy part. You simply specify the tablespace name for each partition during creation or rebuilt. Look up the mannual for the exact SQL syntax. The part that you need to pay more attention to is : what type of indexes do I have? how will each partition maintanence affect them. There is the local index, there is the global index (partitioned and nonpartitioned). Your table can be IOT, or non-IOT. How will split partition, add partition and exchange partition affect these indexes? There is nothing like testing it out for yourself with the version of ORACLE you are using.

• Jusung Yang

vissuyk_at_yahoo.com (Vissu) wrote in message news:<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 - 20:36:31 CET