List of Examples
- 1-1 Importing a Table into a PDB
- 1-2 Specifying a Credential When Importing Data
- 1-3 Importing Data Using a Default Credential
- 2-1 Example
- 2-2 Performing a Table-Mode Export
- 2-3 Data-Only Unload of Selected Tables and Rows
- 2-4 Estimating Disk Space Needed in a Table-Mode Export
- 2-5 Performing a Schema Mode Export
- 2-6 Parallel Full Export
- 2-7 Stopping and Reattaching to a Job
- 3-1 Performing a Data-Only Table-Mode Import
- 3-2 Performing a Schema-Mode Import
- 3-3 Network-Mode Import of Schemas
- 3-4 Wildcards Used in a URL-based Filename
- 6-1 Performing a Simple Schema Export
- 6-2 Importing a Dump File and Remapping All Schema Objects
- 6-3 Using Exception Handling During a Simple Schema Export
- 6-4 Displaying Dump File Information
- 7-1 Loading Data in Fixed Record Format
- 7-2 Loading Data in Variable Record Format
- 7-3 Loading Data in Stream Record Format
- 9-1 Sample Control File
- 9-2 Identifying XMLType Tables in the SQL*Loader Control File
- 9-3 CONTINUEIF THIS Without the PRESERVE Parameter
- 9-4 CONTINUEIF THIS with the PRESERVE Parameter
- 9-5 CONTINUEIF NEXT Without the PRESERVE Parameter
- 9-6 CONTINUEIF NEXT with the PRESERVE Parameter
- 10-1 Field List Section of Sample Control File
- 10-2 DEFAULTIF Clause Is Not Evaluated
- 10-3 DEFAULTIF Clause Is Evaluated
- 10-4 DEFAULTIF Clause Specifies a Position
- 10-5 DEFAULTIF Clause Specifies a Field Name
- 11-1 Loading Column Objects in Stream Record Format
- 11-2 Loading Column Objects in Variable Record Format
- 11-3 Loading Nested Column Objects
- 11-4 Loading Column Objects with a Subtype
- 11-5 Specifying Attribute Nulls Using the NULLIF Clause
- 11-6 Loading Data Using Filler Fields
- 11-7 Loading a Column Object with Constructors That Match
- 11-8 Loading a Column Object with Constructors That Do Not Match
- 11-9 Using SQL to Load Column Objects When Constructors Do Not Match
- 11-10 Loading an Object Table with Primary Key OIDs
- 11-11 Loading OIDs
- 11-12 Loading an Object Table with a Subtype
- 11-13 Loading System-Generated REF Columns
- 11-14 Loading Primary Key REF Columns
- 11-15 Loading LOB Data in Predetermined Size Fields
- 11-16 Loading LOB Data in Delimited Fields
- 11-17 Loading LOB Data in Length-Value Pair Fields
- 11-18 Loading LOB Data with One LOB per LOBFILE
- 11-19 Loading LOB Data Using Predetermined Size LOBs
- 11-20 Loading LOB Data Using Delimited LOBs
- 11-21 Loading LOB Data Using Length-Value Pair Specified LOBs
- 11-22 Example Specification of an LLS Clause
- 11-23 Loading Data Using BFILEs: Only File Name Specified Dynamically
- 11-24 Loading Data Using BFILEs: File Name and Directory Specified Dynamically
- 11-25 Loading a VARRAY and a Nested Table
- 11-26 Loading a Parent Table with User-Provided SIDs
- 11-27 Loading a Child Table with User-Provided SIDs
- 12-1 Setting the Date Format in the SQL*Loader Control File
- 12-2 Setting an NLS_DATE_FORMAT Environment Variable
- 14-1 Specifying Attributes for the ORACLE_LOADER Access Driver
- 14-2 Specifying Attributes for the ORACLE_DATAPUMP Access Driver
- 14-3 Specifying Attributes for the ORACLE_HDFS Access Driver
- 14-4 Specifying Attributes for the ORACLE_HIVE Access Driver
- 17-1 Setting Multiple Access Parameters for ORACLE_HDFS
- 17-2 Setting Multiple Access Parameters for ORACLE_HIVE
- 18-1 Using ORACLE_LOADER to Create a Partitioned External Table
- 18-2 Example
- 18-3 Using the ORACLE_DATAPUMP Access Driver to Create Partitioned External Tables
- 18-4 Using the ORACLE_HDFS Access Driver to Create Partitioned External Tables
- 18-5 Using the ORACLE_HIVE Access Driver to Create Partitioned External Tables
- 18-6 Loading LOBs From External Tables
- 18-7 Loading Data From CSV Files With No Access Parameters
- 18-8 Default Date Mask For the Session Does Not Match the Format of Data Fields in the Data File
- 18-9 Data is Split Across Two Data Files
- 18-10 Data Is Split Across Two Files and Only the First File Has a Row of Field Names
- 18-11 The Order of the Fields in the File Match the Order of the Columns in the Table
- 18-12 Not All Fields in the Data File Use Default Settings for the Access Parameters
- 23-1 Using the DBMS_METADATA Programmatic Interface to Retrieve Data
- 23-2 Using the DBMS_METADATA Browsing Interface to Retrieve Data
- 23-3 Retrieving Multiple Objects
- 23-4 Placing Conditions on Transforms
- 23-5 Modifying an XML Document
- 23-6 Using Parse Items to Access Specific Metadata Attributes
- 23-7 Using the Submit Interface to Re-Create a Retrieved Object
- 23-8 Retrieving Heterogeneous Object Types
- 23-9 Filtering the Return of Heterogeneous Object Types
- 23-10 Comparing Object Metadata