| Create List Subpartition for an existing List partition [message #572636] |
Fri, 14 December 2012 05:32  |
prashanth7582
Messages: 34
Registered: October 2005
Location: Bangalore
|
Member |
|
|
Dear All,
We have a table which is already partitioned by list and now we would like to add a subpartition.
Create table Item_mst
(
ccn varchar2(10),
Flag varchar2(1),
Item varchar2(10),
status varchar2(1)
)
partition by list(CCN)
(
partition Item_mst_Test values('ABC'),
partition Item_mst_Test1 values('DEF')
);
Now I could like to alter the above table for adding a new subpartition on each partition on status.
ALTER TABLE Item_mst
MODIFY PARTITION Item_mst_Test
ADD SUBPARTITION Item_mst_Test_A VALUES ('A');
Above alter gives ORA-14253: table is not partitioned by composite range method.
However dropping and recreating the table with subpartitions is working fine.
But Dropping and recreating the table in production is very cumbersome as it has huge data and many indices.
Please let me know if you have any suggestions.
Thanks
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
