Oracle分区表跨分区查询数据为空

测试积点老人

Oracle分区表跨分区查询数据为空
创建分区表的语句，PLATTIME是一个时间字段

1. ALTER TABLE TORDER MODIFY
   
2. PARTITION BY RANGE (PLATTIME)
   
3. (
   
4.   partition p1801 values less than (to_timestamp('2018-01-01', 'YYYY-MM-DD')),
   
5.   partition p1805 values less than (to_timestamp('2018-05-01', 'YYYY-MM-DD')),
   
6.   partition p1808 values less than (to_timestamp('2018-08-01', 'YYYY-MM-DD')),
   
7.   partition p1810 values less than (to_timestamp('2018-10-01', 'YYYY-MM-DD')),
   
8.   partition p1812 values less than (to_timestamp('2018-12-01', 'YYYY-MM-DD')),
   
9.   partition p1901 values less than (to_timestamp('2019-01-01', 'YYYY-MM-DD')),
   
10.   partition p1902 values less than (to_timestamp('2019-02-01', 'YYYY-MM-DD')),
    
11.   partition p1903 values less than (to_timestamp('2019-03-01', 'YYYY-MM-DD')),
    
12.   partition p1904 values less than (to_timestamp('2019-04-01', 'YYYY-MM-DD')),
    
13.   partition p1905 values less than (to_timestamp('2019-05-01', 'YYYY-MM-DD')),
    
14.   partition p1906 values less than (to_timestamp('2019-06-01', 'YYYY-MM-DD')),
    
15.   partition p1907 values less than (to_timestamp('2019-07-01', 'YYYY-MM-DD')),
    
16.   partition p1908 values less than (to_timestamp('2019-08-01', 'YYYY-MM-DD')),
    
17.   partition pmax values less than (maxvalue)
    
18. )ONLINE
    
19. UPDATE INDEXES;

复制代码

1. 在没有进行分区之前使用以下sql语句是可以查询到数据的，分区后再查询获取的数据为空
   
2. select * from TORDER where PLATTIME BETWEEN to_timestamp('2018-01-01', 'YYYY-MM-DD') and to_timestamp('2018-09-01', 'YYYY-MM-DD');

复制代码

qqq911

查询区间加大一点

bellas

是不是没有分区成功呢

jingzizx

正确与否啊

海海豚

怀疑没分区成功

abcsell

联合查询