EXTERNAL VARIABLE DATA

Note:

The EXTERNAL VARIABLE DATA clause is valid only for use with the Oracle SQL Connector for Hadoop Distributed File System (HDFS). See Oracle Big Data Connectors User's Guide for more information about the Oracle SQL Connector for HDFS.

When you specify the EXTERNAL VARIABLE DATA clause, the ORACLE_LOADER access driver is used to load dump files that were generated with the ORACLE_DATAPUMP access driver. The syntax is as follows:

Description of the illustration et_extvardat.eps follows
Description of the illustration et_extvardat.eps

For security reasons, the DISABLE_DIRECTORY_LINK_CHECK access parameter is required when using EXTERNAL VARIABLE DATA.

The only other access parameters that can be used with the EXTERNAL VARIABLE DATA clause are the following:

The following example uses the EXTERNAL VARIABLE DATA clause. The example assumes that the deptxt1.dmp dump file was previously generated by the ORACLE_DATAPUMP access driver. The tkexcat program specified by the PREPROCESSOR parameter is a user-supplied program to manipulate the input data.

CREATE TABLE deptxt1
(
   deptno  number(2),
   dname   varchar2(14),
   loc     varchar2(13)
)
ORGANIZATION EXTERNAL
(
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY dpump_dir
  ACCESS PARAMETERS
  (
    EXTERNAL VARIABLE DATA
    DISABLE_DIRECTORY_LINK_CHECK
    LOGFILE 'deptxt1.log'
    READSIZE=10000
    PREPROCESSOR tkexcat
  )
  LOCATION ('deptxt1.dmp')
)
REJECT LIMIT UNLIMITED
;