SEM_APIS.CREATE_SOURCE_EXTERNAL_TABLE

Format

SEM_APIS.CREATE_SOURCE_EXTERNAL_TABLE(
     source_table   IN VARCHAR2,
     def_directory  IN VARCHAR2,
     log_directory  IN VARCHAR2 DEFAULT NULL,
     bad_directory  IN VARCHAR2 DEFAULT NULL,
     log_file       IN VARCHAR2 DEFAULT NULL,
     bad_file       IN VARCHAR2 DEFAULT NULL,
     parallel       IN INTEGER DEFAULT NULL,
     source_table_owner IN VARCHAR2 DEFAULT NULL,
     flags          IN VARCHAR2 DEFAULT NULL);

Description

Creates an external table to map an N-Triple or N-Quad format file into a table.

Parameters

source_table

Name of the external table to be created.

def_directory

Database directory where the input files are located. To load from this staging table, you must have READ privilege on this directory.

log_directory

Database directory where the log files will be generated when loading from the external table. If not specified, the value of the def_directory parameter is used. When loading from the external table, you must have WRITE privilege on this directory.

bad_directory

Database directory where the bad files will be generated when loading from the external table. If not specified, the value of the def_directory parameter is used. When loading from the external table, you must have WRITE privilege on this directory.

log_file

Name of the log file. If not specified, the name will be generated automatically during a load operation.

bad_file

Name of the bad file. If not specified, the name will be generated automatically during a load operation.

parallel

Degree of parallelism to associate with the external table being created.

source_table_owner

Owner for the external table being created. If not specified, the invoker becomes the owner.

flags

(Reserved for future use)

Usage Notes

For more information and an example, see Loading N-Quad Format Data into a Staging Table Using an External Table.

Examples

The following example creates a source external table. (This example is an excerpt from Example: Using an External Table to Load a Staging Table in Loading N-Quad Format Data into a Staging Table Using an External Table.)

BEGIN
  sem_apis.create_source_external_table(
    source_table    => 'stage_table_source'
   ,def_directory   => 'DATA_DIR'
   ,bad_file        => 'CLOBrows.bad'
   );
END;