Oracle 11 g 删除表test_part清洗;
创建表test_part
(t_time日期、
小时数,
city_id号码,
hour_city varchar2(108)生成的总是作为(to_char(小时)| |的| | | to_char (city_id)))
分区的范围(t_time) subpartition byhash (hour_city)
(分区part_201705值小于(to_date(' 20170601 ', '名称'))
(subpartition subpart_201705_01,
subpartition subpart_201705_02),
分区part_201706值小于(to_date(' 20170701 ', '名称'))
(subpartition subpart_201706_01,
subpartition subpart_201706_02))
创建表test_part
(t_time日期、
小时数(2)
city_id号码,
day_hour varchar2(50)生成总是(to_char (t_time, '名称')| | |的| | to_char(小时)))
分区的范围(day_hour) subpartition byhash (city_id)
(分区part_201705值小于(2017060100)
(subpartition subpart_201705_01,
subpartition subpart_201705_02),
分区part_201706值小于(“2017070100”)
(subpartition subpart_201706_01,
subpartition subpart_201706_02)
创建
3 id
