【故障描述】
使用网络连接的方式登录19c的PDB,然后创建oracle_loader驱动模式的外部表。创建成功后,在检索数据时,出现KUP-04040的报错,过程如下:
[oracle@sdedu ~]$ sqlplus sys/oracle@pdb1 as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 7 18:12:34 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> create directory dmp_dir as '/home/oracle/ext_table/';
Directory created.
SQL> CREATE TABLE emp_load
2 (
3 first_name CHAR(15),
4 last_name CHAR(20),
5 year_of_birth CHAR(4)
6 )
7 ORGANIZATION EXTERNAL
8 (
9 TYPE ORACLE_LOADER
10 DEFAULT DIRECTORY dmp_dir
11 ACCESS PARAMETERS
12 (
13 RECORDS DELIMITED BY '