Oracle OCP 1Z0 053 Q224(Interval Partition)

abstractcyj發表於2016-04-01
224.You need to create a partitioned table to store historical data and you issued the following command:
CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL
(NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESS
THAN(TO_DATE('1-1-2005', 'dd-mm-yyyy')), PARTITION p2 VALUES LESS THAN(TO_DATE('1-1- 2007',
'dd-mm-yyyy'))) AS SELECT * FROM purchases WHERE time_id < TO_DATE('1-1-2007','dd-mm-yyyy');
What is the outcome of the above command?
A. It returns an error because the range partitions P1 and P2 should be of the same range.
B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.
C. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a
width of one month each.
D. It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match
the number of range partitions (P1,P2) specified.
Answer: C

INTERVAL 是11G新增的自動分割槽特性
該語句建立p1、p2兩個分割槽,其後的資料按月自動進行分

參考:http://blog.csdn.net/jgmydsai/article/details/38231135

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2073806/,如需轉載,請註明出處,否則將追究法律責任。

相關文章