CREATE TABLE INV_HISTORY ( inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2) ) partition by range(inv_date) interval(numtoyminterval(1,'month')) ( partition p0 values less than(to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy')) ); |
![](https://i-blog.csdnimg.cn/blog_migrate/cd1631b3719f96974b3286a543023344.png)
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL>ALTER TABLE inv_history MERGE PARTITIONS FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
A.It executes successfully,and the transition point is set to'1-apr-2006'.
B.It executes successfully,and the transition point is set to'15-apr-2006'.
C.It produces an error because the partitions specified for merging are not adjacent.
D.It produces an error because the date values specified in the merge do not match the date values stored in the table.
答案:(C)
解析:
参考 ALTER TABLE的merge_table_partitions子句
对于范围分区,进行合并的2个分区必须是连续的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1247596/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1247596/