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
- 1-4 Avoiding Invalid Local User Error
- 2-1 Performing a Table-Mode Export
- 2-2 Data-Only Unload of Selected Tables and Rows
- 2-3 Estimating Disk Space Needed in a Table-Mode Export
- 2-4 Performing a Schema Mode Export
- 2-5 Parallel Full Export
- 2-6 Stopping and Reattaching to a Job
- 2-7 Finding LOB Corruption in Large Tables
- 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 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 Filler Field Specification
- 10-3 DEFAULTIF Clause Is Not Evaluated
- 10-4 DEFAULTIF Clause Is Evaluated
- 10-5 DEFAULTIF Clause Specifies a Position
- 10-6 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 REF Clause descriptions in the SQL*Loader Control file
- 11-14 Loading System-Generated REF Columns
- 11-15 Loading Primary Key REF Columns
- 11-16 Single Load Using Multiple INTO TABLE Clause Method
- 11-17 Loading LOB Data in Predetermined Size Fields
- 11-18 Loading LOB Data in Delimited Fields
- 11-19 Loading LOB Data in Length-Value Pair Fields
- 11-20 Loading LOB Data with One LOB per LOBFILE
- 11-21 Loading LOB Data Using Predetermined Size LOBs
- 11-22 Loading LOB Data Using Delimited LOBs
- 11-23 Loading LOB Data Using Length-Value Pair Specified LOBs
- 11-24 Loading Data Using BFILEs: Only File Name Specified Dynamically
- 11-25 Loading Data Using BFILEs: File Name and Directory Specified Dynamically
- 11-26 Loading a VARRAY and a Nested Table
- 11-27 Loading a Parent Table with User-Provided SIDs
- 11-28 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_FORMATEnvironment 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_BIGDATA Access Driver
- 17-1 Cloud Service Credentials
- 17-2 Native Oracle Cloud Infrastructure Credentials
- 17-3 Native Oracle Cloud Infrastructure Credentials
- 17-4 Native Oracle Cloud Infrastructure Object Storage
- 17-5 Oracle Cloud Infrastructure Object Storage
- 17-6 Hosted-Style URI format
- 17-7 Path-style URI Format
- 17-8 Azure BLOB Storage Location Format
- 17-9 CSV Data File
- 17-10 CSV Data File
- 17-11 JSON Data File
- 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_BIGDATA Access Driver to create
- 18-5 Loading LOBs From External Tables
- 18-6 Loading Data From CSV Files With No Access Parameters
- 18-7 Default Date Mask For the Session Does Not Match the Format of Data Fields in the Data File
- 18-8 Data is Split Across Two Data Files
- 18-9 Data Is Split Across Two Files and Only the First File Has a Row of Field Names
- 18-10 The Order of the Fields in the File Match the Order of the Columns in the Table
- 18-11 Not All Fields in the Data File Use Default Settings for the Access Parameters
- 19-1 Generating a CPAT Properties File
- 22-1 Alert Files for a Database Name and Database ID Change
- 23-1 Querying SYS.DBA_LOGMNR_DICTIONARY
- 23-2 Enabling Minimal Supplemental Logging
- 24-1 Using the DBMS_METADATA Programmatic Interface to Retrieve Data
- 24-2 Using the DBMS_METADATA Browsing Interface to Retrieve Data
- 24-3 Retrieving Multiple Objects
- 24-4 Placing Conditions on Transforms
- 24-5 Modifying an XML Document
- 24-6 Using Parse Items to Access Specific Metadata Attributes
- 24-7 Using the Submit Interface to Re-Create a Retrieved Object
- 24-8 Retrieving Heterogeneous Object Types
- 24-9 Filtering the Return of Heterogeneous Object Types
- 24-10 Comparing Object Metadata