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
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:
For security reasons, the DISABLE_DIRECTORY_LINK_CHECK access parameter is required when using
The only other access parameters that can be used with the
DATA clause are the following:
The following example uses the
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 ;