oracle 混合分区表,ORACLE 19C的混合分区表使用场景

CREATE DIRECTORY TPA_DIR AS '/opt/oracle/product/19c/dbhome_1/test';

GRANT READ,WRITE ON DIRECTORY TPA_DIR TO c##boco; --给c#boco用户权限

create table E_P_TPA_RADIO_SUM

(id RAW (16) NOT NULL,

stime date default sysdate,

p1 integer,

p2 integer,

p3 integer,

p4 integer

)

EXTERNAL PARTITION ATTRIBUTES (

TYPE ORACLE_LOADER

DEFAULT DIRECTORY TPA_DIR

ACCESS PARAMETERS(

FIELDS TERMINATED BY ','

(id,stime DATE 'yyyy-mm-dd',p1,p2,p3,p4)

)

REJECT LIMIT UNLIMITED

)

partition by range(stime)(

PARTITION stime_ep1 VALUES LESS THAN (TO_DATE('01-01-2015','dd-mm-yyyy')) ,

PARTITION stime_ep2 VALUES LESS THAN (TO_DATE('01-01-2016','dd-mm-yyyy')),

PARTITION stime_ep3 VALUES LESS THAN (TO_DATE('01-01-2017','dd-mm-yyyy')),

PARTITION stime_ep4 VALUES LESS THAN (TO_DATE('01-01-2018','dd-mm-yyyy')),

PARTITION stime_ep5 VALUES LESS THAN (TO_DATE('01-01-2019','dd-mm-yyyy')),

PARTITION stime_ep6 VALUES LESS THAN (TO_DATE('01-01-2020','dd-mm-yyyy')),

PARTITION stime_ep7 VALUES LESS THAN (TO_DATE('01-01-2021','dd-mm-yyyy'))  external   LOCATION ('test.csv')

);