📋Steps in this guide1/1

Split partition online(12cR2 only)

SQL> alter table order_tab split partition CREATED_MX into (partition CREATED_2106_P2 VALUES LESS THAN (TO_DATE('01/03/2016', 'DD/MM/YYYY')),PARTITION CREATED_MX) ONLINE;

oracle configurationintermediate

by OracleDba

13 views

Split partition online(12cR2 only)

Code/Command (click line numbers to comment):

SQL>
alter table order_tab split partition CREATED_MX into
(partition CREATED_2106_P2 VALUES LESS THAN (TO_DATE('01/03/2016', 'DD/MM/YYYY')),PARTITION CREATED_MX) ONLINE;
Table altered.
SQL>
select partition_name,read_only,high_value from dba_tab_partitions where table_name='ORDER_TAB';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!