-
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
-
Split one of the produced partitions again
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|