------------------------首先创建分区表------------------------------------------------- create table store_sales (store_id number(6),invoice_number number, time_id date,invoice_sale_amt number(10,2)) partition by range(time_id) subpartition by hash(invoice…