SEM_APIS.CREATE_SOURCE_EXTERNAL

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 1-109 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;