| Partitioning Tables [message #204822] |
Wed, 22 November 2006 04:31  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
