Home » RDBMS Server » Performance Tuning » Partitioning Tables
Partitioning Tables [message #204822] Wed, 22 November 2006 04:31 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Partitioning Problem

--------------------------------------------------------------------------------

Dear All,
I am trying to practice for partitioning the tables
I have created a partitioned table with the following

CREATE TABLE my_table_2 (
id NUMBER,
description VARCHAR2(50)
)
PARTITION BY RANGE (id)
(PARTITION my_table_part VALUES LESS THAN (MAXVALUE));

INSERT INTO my_table (id, description) VALUES (1, 'One');
INSERT INTO my_table (id, description) VALUES (2, 'Two');
INSERT INTO my_table (id, description) VALUES (3, 'Three');
INSERT INTO my_table (id, description) VALUES (4, 'Four');
COMMIT;

A partitioned table is created with a single partition,Now i want to split this partitioned table into multiple partition,i have split it into two partition with the following script

ALTER TABLE my_table SPLIT PARTITION my_table_part AT (3)
INTO (PARTITION my_table_part_1,
PARTITION my_table_part_2);

But My requirement is to split this partition table into more than two partition
Can anybody help me in this regard by providing the syntax to do it?
Thanx in advance
Re: Partitioning Tables [message #204951 is a reply to message #204822] Wed, 22 November 2006 19:55 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Use your ALTER statement to do the first split, and then repeat for further splits.

Ross Leishman
Previous Topic: Difference Between Global Index and Local Index
Next Topic: While Analyzing Schema
Goto Forum:
  


Current Time: Fri Dec 02 21:08:49 CST 2016

Total time taken to generate the page: 0.13536 seconds