Oracle 19C Hybrid partitioned tables混合分区表

Oracle 19C支持Hybrid partitioned tables（混合分区表），也就是一一个表部分分区是外部CSV\\TXT文件，部分分区是数据库中的表分区，可以同时查询操作，这在归档数据时非常方便，也可以很方便查询到多年前的历史数据。
编辑外部文件并创建混合分区表：
[code]SQL> select DIRECTORY_PATH from dba_directories where DIRECTORY_NAME = 'DATA_PUMP_DIR';

DIRECTORY_PATH
-------------------------------------------------------------------------------------------------
/u01/app/oracle/admin/cs19c/dpdump/

SQL> !cat /u01/app/oracle/admin/cs19c/dpdump/a.dat
1,jsss,
2,kjjj,
3,looo,

SQL> CREATE TABLE par_hybrid_tab ( id number,
2 name varchar2(5))
3 EXTERNAL PARTITION ATTRIBUTES
4 ( TYPE oracle_loader DEFAULT DIRECTORY DATA_PUMP_DIR REJECT LIMIT unlimited )
5 PARTITION BY RANGE(id)
6 ( partition p1 values less than (10)
7 EXTERNAL LOCATION ('a.dat'),
8 partition p2 values less than (20),
9 partition p3 values less than (30),
10 partition p4 values less than (40));


Table created.[/code]
对表进行操作：
[code]SQL> select * from par_hybrid_tab;

ID NAME
---------- -----
1 jsss
2 kjjj
3 looo

SQL> insert into par_hybrid_tab values (16,'mppp');

1 row created.

SQL> insert into par_hybrid_tab values (28,'gyyy');

1 row created.

SQL> insert into par_hybrid_tab values (39,'arrr');

1 row created.

SQL> select * from par_hybrid_tab;

ID NAME
---------- -----
1 jsss
2 kjjj
3 looo
16 mppp
28 gyyy
39 arrr

6 rows selected.

SQL> select * from par_hybrid_tab partition (p1);

ID NAME
---------- -----
1 jsss
2 kjjj
3 looo

SQL> select * from par_hybrid_tab partition (p2);

ID NAME
---------- -----
16 mppp

SQL> select * from par_hybrid_tab partition (p3);

ID NAME
---------- -----
28 gyyy

SQL> select * from par_hybrid_tab partition (p4);

ID NAME
---------- -----
39 arrr

SQL>[/code]