Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Part I Oracle Data Pump
-
1
Overview of Oracle Data Pump
- 1.1 Oracle Data Pump Components
- 1.2 How Does Oracle Data Pump Move Data?
- 1.3 Using Oracle Data Pump With CDBs
- 1.4 Required Roles for Oracle Data Pump Export and Import Operations
-
1.5
What Happens During Execution of an Oracle Data Pump Job?
- 1.5.1 Coordination of an Oracle Data Pump Job
- 1.5.2 Tracking Progress Within a Job
- 1.5.3 Filtering Data and Metadata During an Oracle Data Pump Job
- 1.5.4 Transforming Metadata During an Oracle Data Pump Job
- 1.5.5 Maximizing Job Performance of Oracle Data Pump
- 1.5.6 Loading and Unloading Data with Oracle Data Pump
- 1.6 How to Monitor Status of Oracle Data Pump Jobs
- 1.7 How to Monitor the Progress of Executing Jobs
- 1.8 File Allocation with Oracle Data Pump
- 1.9 Exporting and Importing Between Different Oracle Database Releases
- 1.10 Managing SecureFiles Large Object Exports with Oracle Data Pump
- 1.11 Oracle Data Pump Process Exit Codes
- 1.12 How to Monitor Oracle Data Pump Jobs with Unified Auditing
- 1.13 Encrypted Data Security Warnings for Oracle Data Pump Operations
- 1.14 How Does Oracle Data Pump Handle Timestamp Data?
- 1.15 Character Set and Globalization Support Considerations
- 1.16 Oracle Data Pump Behavior with Data-Bound Collation
-
2
Oracle Data Pump Export
- 2.1 What Is Oracle Data Pump Export?
- 2.2 Starting Oracle Data Pump Export
- 2.3 Filtering During Export Operations
-
2.4
Parameters Available in Data Pump Export
Command-Line Mode
- 2.4.1 About Data Pump Export Parameters
- 2.4.2 ABORT_STEP
- 2.4.3 ACCESS_METHOD
- 2.4.4 ATTACH
- 2.4.5 CLUSTER
- 2.4.6 COMPRESSION
- 2.4.7 COMPRESSION_ALGORITHM
- 2.4.8 CONTENT
- 2.4.9 DATA_OPTIONS
- 2.4.10 DIRECTORY
- 2.4.11 DUMPFILE
- 2.4.12 ENABLE_SECURE_ROLES
- 2.4.13 ENCRYPTION
- 2.4.14 ENCRYPTION_ALGORITHM
- 2.4.15 ENCRYPTION_MODE
- 2.4.16 ENCRYPTION_PASSWORD
- 2.4.17 ENCRYPTION_PWD_PROMPT
- 2.4.18 ESTIMATE
- 2.4.19 ESTIMATE_ONLY
- 2.4.20 EXCLUDE
- 2.4.21 FILESIZE
- 2.4.22 FLASHBACK_SCN
- 2.4.23 FLASHBACK_TIME
- 2.4.24 FULL
- 2.4.25 HELP
- 2.4.26 INCLUDE
- 2.4.27 JOB_NAME
- 2.4.28 KEEP_MASTER
- 2.4.29 LOGFILE
- 2.4.30 LOGTIME
- 2.4.31 METRICS
- 2.4.32 NETWORK_LINK
- 2.4.33 NOLOGFILE
- 2.4.34 PARALLEL
- 2.4.35 PARFILE
- 2.4.36 QUERY
- 2.4.37 REMAP_DATA
- 2.4.38 REUSE_DUMPFILES
- 2.4.39 SAMPLE
- 2.4.40 SCHEMAS
- 2.4.41 SERVICE_NAME
- 2.4.42 SOURCE_EDITION
- 2.4.43 STATUS
- 2.4.44 TABLES
- 2.4.45 TABLESPACES
- 2.4.46 TRANSPORT_FULL_CHECK
- 2.4.47 TRANSPORT_TABLESPACES
- 2.4.48 TRANSPORTABLE
- 2.4.49 TTS_CLOSURE_CHECK
- 2.4.50 VERSION
- 2.4.51 VIEWS_AS_TABLES
- 2.5 Commands Available in Data Pump Export Interactive-Command Mode
- 2.6 Examples of Using Oracle Data Pump Export
- 2.7 Syntax Diagrams for Oracle Data Pump Export
-
3
Oracle Data Pump Import
- 3.1 What Is Oracle Data Pump Import?
- 3.2 Starting Oracle Data Pump Import
- 3.3 Filtering During Import Operations
-
3.4
Parameters Available in Oracle Data Pump
Import Command-Line Mode
- 3.4.1 About Import Command-Line Mode
- 3.4.2 ABORT_STEP
- 3.4.3 ACCESS_METHOD
- 3.4.4 ATTACH
- 3.4.5 CLUSTER
- 3.4.6 CONTENT
- 3.4.7 CREDENTIAL
- 3.4.8 DATA_OPTIONS
- 3.4.9 DIRECTORY
- 3.4.10 DUMPFILE
- 3.4.11 ENABLE_SECURE_ROLES
- 3.4.12 ENCRYPTION_PASSWORD
- 3.4.13 ENCRYPTION_PWD_PROMPT
- 3.4.14 ESTIMATE
- 3.4.15 EXCLUDE
- 3.4.16 FLASHBACK_SCN
- 3.4.17 FLASHBACK_TIME
- 3.4.18 FULL
- 3.4.19 HELP
- 3.4.20 INCLUDE
- 3.4.21 JOB_NAME
- 3.4.22 KEEP_MASTER
- 3.4.23 LOGFILE
- 3.4.24 LOGTIME
- 3.4.25 MASTER_ONLY
- 3.4.26 METRICS
- 3.4.27 NETWORK_LINK
- 3.4.28 NOLOGFILE
- 3.4.29 PARALLEL
- 3.4.30 PARFILE
- 3.4.31 PARTITION_OPTIONS
- 3.4.32 QUERY
- 3.4.33 REMAP_DATA
- 3.4.34 REMAP_DATAFILE
- 3.4.35 REMAP_DIRECTORY
- 3.4.36 REMAP_SCHEMA
- 3.4.37 REMAP_TABLE
- 3.4.38 REMAP_TABLESPACE
- 3.4.39 SCHEMAS
- 3.4.40 SERVICE_NAME
- 3.4.41 SKIP_UNUSABLE_INDEXES
- 3.4.42 SOURCE_EDITION
- 3.4.43 SQLFILE
- 3.4.44 STATUS
- 3.4.45 STREAMS_CONFIGURATION
- 3.4.46 TABLE_EXISTS_ACTION
- 3.4.47 REUSE_DATAFILES
- 3.4.48 TABLES
- 3.4.49 TABLESPACES
- 3.4.50 TARGET_EDITION
- 3.4.51 TRANSFORM
- 3.4.52 TRANSPORT_DATAFILES
- 3.4.53 TRANSPORT_FULL_CHECK
- 3.4.54 TRANSPORT_TABLESPACES
- 3.4.55 TRANSPORTABLE
- 3.4.56 VERSION
- 3.4.57 VIEWS_AS_TABLES (Network Import)
- 3.4.58 VIEWS_AS_TABLES (Non-Network Import)
- 3.5 Commands Available in Oracle Data Pump Import Interactive-Command Mode
- 3.6 Examples of Using Oracle Data Pump Import
- 3.7 Syntax Diagrams for Oracle Data Pump Import
- 4 Oracle Data Pump Legacy Mode
- 5 Oracle Data Pump Performance
- 6 Using the Oracle Data Pump API
-
1
Overview of Oracle Data Pump
-
Part II SQL*Loader
-
7
Understanding How to Use SQL*Loader
- 7.1 SQL*Loader Features
- 7.2 SQL*Loader Parameters
- 7.3 SQL*Loader Control File
- 7.4 How SQL*Loader Reads Input Data and Data Files
- 7.5 LOBFILEs and Secondary Data Files (SDFs)
- 7.6 Data Conversion and Data Type Specification
- 7.7 SQL*Loader Discarded and Rejected Records
- 7.8 Log File and Logging Information
- 7.9 Conventional Path Loads, Direct Path Loads, and External Table Loads
- 7.10 Loading Objects, Collections, and LOBs with SQL*Loader
- 7.11 Partitioned Object Support in SQL*Loader
- 7.12 Application Development: Direct Path Load API
- 7.13 SQL*Loader Case Studies
-
8
SQL*Loader Command-Line Reference
- 8.1 Starting SQL*Loader
-
8.2
Command-Line Parameters for SQL*Loader
- 8.2.1 BAD
- 8.2.2 BINDSIZE
- 8.2.3 COLUMNARRAYROWS
- 8.2.4 CONTROL
- 8.2.5 DATA
- 8.2.6 DATE_CACHE
- 8.2.7 DEFAULTS
- 8.2.8 DEGREE_OF_PARALLELISM
- 8.2.9 DIRECT
- 8.2.10 DIRECT_PATH_LOCK_WAIT
- 8.2.11 DISCARD
- 8.2.12 DISCARDMAX
- 8.2.13 DNFS_ENABLE
- 8.2.14 DNFS_READBUFFERS
- 8.2.15 EMPTY_LOBS_ARE_NULL
- 8.2.16 ERRORS
- 8.2.17 EXTERNAL_TABLE
- 8.2.18 FILE
- 8.2.19 HELP
- 8.2.20 LOAD
- 8.2.21 LOG
- 8.2.22 MULTITHREADING
- 8.2.23 NO_INDEX_ERRORS
- 8.2.24 PARALLEL
- 8.2.25 PARFILE
- 8.2.26 PARTITION_MEMORY
- 8.2.27 READSIZE
- 8.2.28 RESUMABLE
- 8.2.29 RESUMABLE_NAME
- 8.2.30 RESUMABLE_TIMEOUT
- 8.2.31 ROWS
- 8.2.32 SDF_PREFIX
- 8.2.33 SILENT
- 8.2.34 SKIP
- 8.2.35 SKIP_INDEX_MAINTENANCE
- 8.2.36 SKIP_UNUSABLE_INDEXES
- 8.2.37 STREAMSIZE
- 8.2.38 TRIM
- 8.2.39 USERID
- 8.3 Exit Codes for Inspection and Display
-
9
SQL*Loader Control File Reference
- 9.1 Control File Contents
- 9.2 Comments in the Control File
- 9.3 Specifying Command-Line Parameters in the Control File
- 9.4 Specifying File Names and Object Names
- 9.5 Identifying XMLType Tables
- 9.6 Specifying Field Order
- 9.7 Specifying Data Files
- 9.8 Specifying CSV Format Files
- 9.9 Identifying Data in the Control File with BEGINDATA
- 9.10 Specifying Data File Format and Buffering
- 9.11 Specifying the Bad File
-
9.12
Specifying the Discard
File
- 9.12.1 Understanding and Specifying the Discard File
- 9.12.2 Specifying the Discard File in the Control File
- 9.12.3 Limiting the Number of Discard Records
- 9.12.4 Examples of Specifying a Discard File Name
- 9.12.5 Criteria for Discarded Records
- 9.12.6 How Discard Files Are Handled with LOBFILEs and SDFs
- 9.12.7 Specifying the Discard File from the Command Line
- 9.13 Specifying a NULLIF Clause At the Table Level
- 9.14 Specifying Datetime Formats At the Table Level
- 9.15 Handling Different Character Encoding Schemes
- 9.16 Interrupted Loads
- 9.17 Assembling Logical Records from Physical Records
- 9.18 Loading Logical Records into Tables
- 9.19 Index Options
- 9.20 Benefits of Using Multiple INTO TABLE Clauses
-
9.21
Bind Arrays and Conventional Path Loads
- 9.21.1 Size Requirements for Bind Arrays
- 9.21.2 Performance Implications of Bind Arrays
- 9.21.3 Specifying Number of Rows Versus Size of Bind Array
- 9.21.4 Calculations to Determine Bind Array Size
- 9.21.5 Minimizing Memory Requirements for Bind Arrays
- 9.21.6 Calculating Bind Array Size for Multiple INTO TABLE Clauses
-
10
SQL*Loader Field List Reference
- 10.1 Field List Contents
- 10.2 Specifying the Position of a Data Field
- 10.3 Specifying Columns and Fields
-
10.4
SQL*Loader Data Types
- 10.4.1 Portable and Nonportable Data Type Differences
- 10.4.2 Nonportable Data Types
-
10.4.3
Portable Data Types
- 10.4.3.1 Categories of Portable Data Types
- 10.4.3.2 CHAR
- 10.4.3.3 Datetime and Interval
- 10.4.3.4 GRAPHIC
- 10.4.3.5 GRAPHIC EXTERNAL
- 10.4.3.6 Numeric EXTERNAL
- 10.4.3.7 RAW
- 10.4.3.8 VARCHARC
- 10.4.3.9 VARRAWC
- 10.4.3.10 Conflicting Native Data Type Field Lengths
- 10.4.3.11 Field Lengths for Length-Value Data Types
- 10.4.4 Data Type Conversions
- 10.4.5 Data Type Conversions for Datetime and Interval Data Types
- 10.4.6 Specifying Delimiters
- 10.4.7 How Delimited Data Is Processed
- 10.4.8 Conflicting Field Lengths for Character Data Types
- 10.5 Specifying Field Conditions
- 10.6 Using the WHEN, NULLIF, and DEFAULTIF Clauses
- 10.7 Examples of Using the WHEN, NULLIF, and DEFAULTIF Clauses
- 10.8 Loading Data Across Different Platforms
- 10.9 Byte Ordering
- 10.10 Loading All-Blank Fields
- 10.11 Trimming Whitespace
- 10.12 How the PRESERVE BLANKS Option Affects Whitespace Trimming
- 10.13 How [NO] PRESERVE BLANKS Works with Delimiter Clauses
- 10.14 Applying SQL Operators to Fields
-
10.15
Using SQL*Loader to Generate Data for Input
- 10.15.1 Loading Data Without Files
- 10.15.2 Setting a Column to a Constant Value
- 10.15.3 Setting a Column to an Expression Value
- 10.15.4 Setting a Column to the Data File Record Number
- 10.15.5 Setting a Column to the Current Date
- 10.15.6 Setting a Column to a Unique Sequence Number
- 10.15.7 Generating Sequence Numbers for Multiple Tables
-
11
Loading Objects, LOBs, and Collections with
SQL*Loader
-
11.1
Loading Column Objects
- 11.1.1 Loading Column Objects in Stream Record Format
- 11.1.2 Loading Column Objects in Variable Record Format
- 11.1.3 Loading Nested Column Objects
- 11.1.4 Loading Column Objects with a Derived Subtype
- 11.1.5 Specifying Null Values for Objects
- 11.1.6 Loading Column Objects with User-Defined Constructors
- 11.2 Loading Object Tables
- 11.3 Loading REF Columns with SQL*Loader
- 11.4 Loading LOBs with SQL*Loader
- 11.5 Loading BFILE Columns with SQL*Loader
- 11.6 Loading Collections (Nested Tables and VARRAYs)
- 11.7 Choosing Dynamic or Static SDF Specifications
- 11.8 Loading a Parent Table Separately from Its Child Table
-
11.1
Loading Column Objects
-
12
Conventional and Direct Path Loads
- 12.1 Data Loading Methods
- 12.2 Conventional Path Load
-
12.3
Direct Path Load
- 12.3.1 Data Conversion During Direct Path Loads
- 12.3.2 Direct Path Load of a Partitioned or Subpartitioned Table
- 12.3.3 Direct Path Load of a Single Partition or Subpartition
- 12.3.4 Advantages of a Direct Path Load
- 12.3.5 Restrictions on Using Direct Path Loads
- 12.3.6 Restrictions on a Direct Path Load of a Single Partition
- 12.3.7 When to Use a Direct Path Load
- 12.3.8 Integrity Constraints
- 12.3.9 Field Defaults on the Direct Path
- 12.3.10 Loading into Synonyms
-
12.4
Using Direct Path Load
- 12.4.1 Setting Up for Direct Path Loads
- 12.4.2 Specifying a Direct Path Load
- 12.4.3 Building Indexes
- 12.4.4 Indexes Left in an Unusable State
- 12.4.5 Using Data Saves to Protect Against Data Loss
- 12.4.6 Data Recovery During Direct Path Loads
- 12.4.7 Loading Long Data Fields
- 12.4.8 Loading Data As PIECED
- 12.4.9 Auditing SQL*Loader Operations That Use Direct Path Mode
- 12.5 Minimizing Time and Space Required for Direct Path Loads
- 12.6 Optimizing Direct Path Loads on Multiple-CPU Systems
- 12.7 Avoiding Index Maintenance
- 12.8 Direct Path Loads, Integrity Constraints, and Triggers
-
12.9
Parallel Data Loading Models
- 12.9.1 Concurrent Conventional Path Loads
- 12.9.2 Intersegment Concurrency with Direct Path
- 12.9.3 Intrasegment Concurrency with Direct Path
- 12.9.4 Restrictions on Parallel Direct Path Loads
- 12.9.5 Initiating Multiple SQL*Loader Sessions
- 12.9.6 Parameters for Parallel Direct Path Loads
- 12.9.7 Enabling Constraints After a Parallel Direct Path Load
- 12.9.8 PRIMARY KEY and UNIQUE KEY Constraints
- 12.10 General Performance Improvement Hints
-
13
SQL*Loader Express
- 13.1 What is SQL*Loader Express Mode?
- 13.2 Using SQL*Loader Express Mode
-
13.3
SQL*Loader Express Mode Parameter Reference
- 13.3.1 BAD
- 13.3.2 CHARACTERSET
- 13.3.3 CSV
- 13.3.4 DATA
- 13.3.5 DATE_FORMAT
- 13.3.6 DEGREE_OF_PARALLELISM
- 13.3.7 DIRECT
- 13.3.8 DNFS_ENABLE
- 13.3.9 DNFS_READBUFFERS
- 13.3.10 ENCLOSED_BY
- 13.3.11 EXTERNAL_TABLE
- 13.3.12 FIELD_NAMES
- 13.3.13 LOAD
- 13.3.14 NULLIF
- 13.3.15 OPTIONALLY_ENCLOSED_BY
- 13.3.16 PARFILE
- 13.3.17 SILENT
- 13.3.18 TABLE
- 13.3.19 TERMINATED_BY
- 13.3.20 TIMESTAMP_FORMAT
- 13.3.21 TRIM
- 13.3.22 USERID
- 13.4 SQL*Loader Express Mode Syntax Diagrams
-
7
Understanding How to Use SQL*Loader
-
Part III External Tables
- 14 External Tables Concepts
-
15
The ORACLE_LOADER Access Driver
- 15.1 About the ORACLE_LOADER Access Driver
- 15.2 access_parameters Clause
-
15.3
record_format_info Clause
- 15.3.1 Overview of record_format_info Clause
- 15.3.2 FIXED Length
- 15.3.3 VARIABLE size
- 15.3.4 DELIMITED BY
- 15.3.5 XMLTAG
- 15.3.6 CHARACTERSET
- 15.3.7 EXTERNAL VARIABLE DATA
- 15.3.8 PREPROCESSOR
- 15.3.9 LANGUAGE
- 15.3.10 TERRITORY
- 15.3.11 DATA IS...ENDIAN
- 15.3.12 BYTEORDERMARK [CHECK | NOCHECK]
- 15.3.13 STRING SIZES ARE IN
- 15.3.14 LOAD WHEN
- 15.3.15 BADFILE | NOBADFILE
- 15.3.16 DISCARDFILE | NODISCARDFILE
- 15.3.17 LOGFILE | NOLOGFILE
- 15.3.18 SKIP
- 15.3.19 FIELD NAMES
- 15.3.20 READSIZE
- 15.3.21 DISABLE_DIRECTORY_LINK_CHECK
- 15.3.22 DATE_CACHE
- 15.3.23 string
- 15.3.24 condition_spec
- 15.3.25 [directory object name:] [filename]
- 15.3.26 condition
- 15.3.27 IO_OPTIONS clause
- 15.3.28 DNFS_DISABLE | DNFS_ENABLE
- 15.3.29 DNFS_READBUFFERS
-
15.4
field_definitions Clause
- 15.4.1 delim_spec
- 15.4.2 trim_spec
- 15.4.3 MISSING FIELD VALUES ARE NULL
- 15.4.4 field_list
- 15.4.5 pos_spec Clause Syntax
-
15.4.6
datatype_spec Clause Syntax
- 15.4.6.1 [UNSIGNED] INTEGER [EXTERNAL] [(len)]
- 15.4.6.2 DECIMAL [EXTERNAL] and ZONED [EXTERNAL]
- 15.4.6.3 ORACLE_DATE
- 15.4.6.4 ORACLE_NUMBER
- 15.4.6.5 Floating-Point Numbers
- 15.4.6.6 DOUBLE
- 15.4.6.7 FLOAT [EXTERNAL]
- 15.4.6.8 BINARY_DOUBLE
- 15.4.6.9 BINARY_FLOAT
- 15.4.6.10 RAW
- 15.4.6.11 CHAR
- 15.4.6.12 date_format_spec
- 15.4.6.13 VARCHAR and VARRAW
- 15.4.6.14 VARCHARC and VARRAWC
- 15.4.7 init_spec Clause
- 15.4.8 LLS Clause
- 15.5 column_transforms Clause
- 15.6 Parallel Loading Considerations for the ORACLE_LOADER Access Driver
- 15.7 Performance Hints When Using the ORACLE_LOADER Access Driver
- 15.8 Restrictions When Using the ORACLE_LOADER Access Driver
- 15.9 Reserved Words for the ORACLE_LOADER Access Driver
-
16
The ORACLE_DATAPUMP Access Driver
- 16.1 Using the ORACLE_DATAPUMP Access Driver
- 16.2 access_parameters Clause
- 16.3 Unloading and Loading Data with the ORACLE_DATAPUMP Access Driver
- 16.4 Supported Data Types
- 16.5 Unsupported Data Types
- 16.6 Performance Hints When Using the ORACLE_DATAPUMP Access Driver
- 16.7 Restrictions When Using the ORACLE_DATAPUMP Access Driver
- 16.8 Reserved Words for the ORACLE_DATAPUMP Access Driver
-
17
ORACLE_HDFS and ORACLE_HIVE Access Drivers
- 17.1 Syntax Rules for Specifying Properties
- 17.2 ORACLE_HDFS Access Parameters
- 17.3 ORACLE_HIVE Access Parameters
-
17.4
Descriptions of com.oracle.bigdata Parameters
- 17.4.1 com.oracle.bigdata.colmap
- 17.4.2 com.oracle.bigdata.erroropt
- 17.4.3 com.oracle.bigdata.fields
- 17.4.4 com.oracle.bigdata.fileformat
- 17.4.5 com.oracle.bigdata.log.exec
- 17.4.6 com.oracle.bigdata.log.qc
- 17.4.7 com.oracle.bigdata.overflow
- 17.4.8 com.oracle.bigdata.rowformat
- 17.4.9 com.oracle.bigdata.tablename
-
18
External Tables Examples
- 18.1 Using the ORACLE_LOADER Access Driver to Create Partitioned External Tables
- 18.2 Using the ORACLE_LOADER Access Driver to Create Partitioned Hybrid Tables
- 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 CSV Files From External Tables
- 19 ORACLE_BIGDATA Access Driver
-
Part IV Other Utilities
-
20
ADRCI: ADR Command Interpreter
- 20.1 About the ADR Command Interpreter (ADRCI) Utility
- 20.2 Definitions for Oracle Database ADRC
- 20.3 Starting ADRCI and Getting Help
- 20.4 Setting the ADRCI Homepath Before Using ADRCI Commands
- 20.5 Viewing the Alert Log
- 20.6 Finding Trace Files
- 20.7 Viewing Incidents
- 20.8 Packaging Incidents
-
20.9
ADRCI Command Reference
- 20.9.1 CREATE REPORT
- 20.9.2 ECHO
- 20.9.3 EXIT
- 20.9.4 HOST
-
20.9.5
IPS
- 20.9.5.1 Using the <ADR_HOME> and <ADR_BASE> Variables in IPS Commands
- 20.9.5.2 IPS ADD
- 20.9.5.3 IPS ADD FILE
- 20.9.5.4 IPS ADD NEW INCIDENTS
- 20.9.5.5 IPS COPY IN FILE
- 20.9.5.6 IPS COPY OUT FILE
- 20.9.5.7 IPS CREATE PACKAGE
- 20.9.5.8 IPS DELETE PACKAGE
- 20.9.5.9 IPS FINALIZE
- 20.9.5.10 IPS GENERATE PACKAGE
- 20.9.5.11 IPS GET MANIFEST
- 20.9.5.12 IPS GET METADATA
- 20.9.5.13 IPS PACK
- 20.9.5.14 IPS REMOVE
- 20.9.5.15 IPS REMOVE FILE
- 20.9.5.16 IPS SET CONFIGURATION
- 20.9.5.17 IPS SHOW CONFIGURATION
- 20.9.5.18 IPS SHOW FILES
- 20.9.5.19 IPS SHOW INCIDENTS
- 20.9.5.20 IPS SHOW PACKAGE
- 20.9.5.21 IPS UNPACK FILE
- 20.9.6 PURGE
- 20.9.7 QUIT
- 20.9.8 RUN
- 20.9.9 SELECT
- 20.9.10 SET BASE
- 20.9.11 SET BROWSER
- 20.9.12 SET CONTROL
- 20.9.13 SET ECHO
- 20.9.14 SET EDITOR
- 20.9.15 SET HOMEPATH
- 20.9.16 SET TERMOUT
- 20.9.17 SHOW ALERT
- 20.9.18 SHOW BASE
- 20.9.19 SHOW CONTROL
- 20.9.20 SHOW HM_RUN
- 20.9.21 SHOW HOMEPATH
- 20.9.22 SHOW HOMES
- 20.9.23 SHOW INCDIR
- 20.9.24 SHOW INCIDENT
- 20.9.25 SHOW LOG
- 20.9.26 SHOW PROBLEM
- 20.9.27 SHOW REPORT
- 20.9.28 SHOW TRACEFILE
- 20.9.29 SPOOL
- 20.10 Troubleshooting ADRCI
- 21 DBVERIFY: Offline Database Verification Utility
- 22 DBNEWID Utility
-
23
Using LogMiner to Analyze Redo Log Files
- 23.1 LogMiner Benefits
- 23.2 Introduction to LogMiner
- 23.3 Using LogMiner in a CDB
- 23.4 LogMiner Dictionary Files and Redo Log Files
- 23.5 Starting LogMiner
- 23.6 Querying V$LOGMNR_CONTENTS for Redo Data of Interest
- 23.7 Filtering and Formatting Data Returned to V$LOGMNR_CONTENTS
- 23.8 Reapplying DDL Statements Returned to V$LOGMNR_CONTENTS
- 23.9 Calling DBMS_LOGMNR.START_LOGMNR Multiple Times
-
23.10
Supplemental Logging
- 23.10.1 Database-Level Supplemental Logging
- 23.10.2 Disabling Database-Level Supplemental Logging
- 23.10.3 Table-Level Supplemental Logging
- 23.10.4 Tracking DDL Statements in the LogMiner Dictionary
- 23.10.5 DDL_DICT_TRACKING and Supplemental Logging Settings
- 23.10.6 DDL_DICT_TRACKING and Specified Time or SCN Ranges
- 23.11 Accessing LogMiner Operational Information in Views
-
23.12
Steps in a Typical LogMiner
Session
- 23.12.1 Understanding How to Run LogMiner Sessions
- 23.12.2 Typical LogMiner Session Task 1: Enable Supplemental Logging
- 23.12.3 Typical LogMiner Session Task 2: Extract a LogMiner Dictionary
- 23.12.4 Typical LogMiner Session Task 3: Specify Redo Log Files for Analysis
- 23.12.5 Start LogMiner
- 23.12.6 Query V$LOGMNR_CONTENTS
- 23.12.7 Typical LogMiner Session Task 6: End the LogMiner Session
-
23.13
Examples Using LogMiner
-
23.13.1
Examples of Mining by Explicitly Specifying the Redo Log Files of Interest
- 23.13.1.1 Example 1: Finding All Modifications in the Last Archived Redo Log File
- 23.13.1.2 Example 2: Grouping DML Statements into Committed Transactions
- 23.13.1.3 Example 3: Formatting the Reconstructed SQL
- 23.13.1.4 Example 4: Using the LogMiner Dictionary in the Redo Log Files
- 23.13.1.5 Example 5: Tracking DDL Statements in the Internal Dictionary
- 23.13.1.6 Example 6: Filtering Output by Time Range
- 23.13.2 LogMiner Use Case Scenarios
-
23.13.1
Examples of Mining by Explicitly Specifying the Redo Log Files of Interest
- 23.14 Supported Data Types, Storage Attributes, and Database and Redo Log File Versions
-
24
Using the Metadata APIs
- 24.1 Why Use the DBMS_METADATA API?
- 24.2 Overview of the DBMS_METADATA API
- 24.3 Using the DBMS_METADATA API to Retrieve an Object's Metadata
- 24.4 Using the DBMS_METADATA API to Re-Create a Retrieved Object
- 24.5 Using the DBMS_METADATA API to Retrieve Collections of Different Object Types
- 24.6 Using the DBMS_METADATA_DIFF API to Compare Object Metadata
- 24.7 Performance Tips for the Programmatic Interface of the DBMS_METADATA API
- 24.8 Example Usage of the DBMS_METADATA API
- 24.9 Summary of DBMS_METADATA Procedures
- 24.10 Summary of DBMS_METADATA_DIFF Procedures
-
25
Original Export
- 25.1 What is the Export Utility?
- 25.2 Before Using Export
- 25.3 Invoking Export
- 25.4 Export Modes
-
25.5
Export Parameters
- 25.5.1 BUFFER
- 25.5.2 COMPRESS
- 25.5.3 CONSISTENT
- 25.5.4 CONSTRAINTS
- 25.5.5 DIRECT
- 25.5.6 FEEDBACK
- 25.5.7 FILE
- 25.5.8 FILESIZE
- 25.5.9 FLASHBACK_SCN
- 25.5.10 FLASHBACK_TIME
- 25.5.11 FULL
- 25.5.12 GRANTS
- 25.5.13 HELP
- 25.5.14 INDEXES
- 25.5.15 LOG
- 25.5.16 OBJECT_CONSISTENT
- 25.5.17 OWNER
- 25.5.18 PARFILE
- 25.5.19 QUERY
- 25.5.20 RECORDLENGTH
- 25.5.21 RESUMABLE
- 25.5.22 RESUMABLE_NAME
- 25.5.23 RESUMABLE_TIMEOUT
- 25.5.24 ROWS
- 25.5.25 STATISTICS
- 25.5.26 TABLES
- 25.5.27 TABLESPACES
- 25.5.28 TRANSPORT_TABLESPACE
- 25.5.29 TRIGGERS
- 25.5.30 TTS_FULL_CHECK
- 25.5.31 USERID (username/password)
- 25.5.32 VOLSIZE
- 25.6 Example Export Sessions
- 25.7 Warning, Error, and Completion Messages
- 25.8 Exit Codes for Inspection and Display
- 25.9 Conventional Path Export Versus Direct Path Export
- 25.10 Starting a Direct Path Export
- 25.11 Network Considerations for Original Oracle Data Pump Export
- 25.12 Character Set and Globalization Support Considerations
- 25.13 Using Instance Affinity with Export and Import
-
25.14
Considerations When Exporting Database Objects
- 25.14.1 Exporting Sequences
- 25.14.2 Exporting LONG and LOB Data Types
- 25.14.3 Exporting Foreign Function Libraries
- 25.14.4 Exporting Offline Locally-Managed Tablespaces
- 25.14.5 Exporting Directory Aliases
- 25.14.6 Exporting BFILE Columns and Attributes
- 25.14.7 Exporting External Tables
- 25.14.8 Exporting Object Type Definitions
- 25.14.9 Exporting Nested Tables
- 25.14.10 Exporting Advanced Queue (AQ) Tables
- 25.14.11 Exporting Synonyms
- 25.14.12 Possible Export Errors Related to Java Synonyms
- 25.14.13 Support for Fine-Grained Access Control
- 25.15 Transportable Tablespaces
- 25.16 Exporting From a Read-Only Database
- 25.17 Using Export and Import to Partition a Database Migration
- 25.18 Using Different Releases of Export and Import
-
26
Original Import
- 26.1 What Is the Import Utility?
- 26.2 Before Using Import
- 26.3 Importing into Existing Tables
- 26.4 Effect of Schema and Database Triggers on Import Operations
- 26.5 Invoking Import
- 26.6 Import Modes
-
26.7
Import Parameters
- 26.7.1 BUFFER
- 26.7.2 COMMIT
- 26.7.3 COMPILE
- 26.7.4 CONSTRAINTS
- 26.7.5 DATA_ONLY
- 26.7.6 DATAFILES
- 26.7.7 DESTROY
- 26.7.8 FEEDBACK
- 26.7.9 FILE
- 26.7.10 FILESIZE
- 26.7.11 FROMUSER
- 26.7.12 FULL
- 26.7.13 GRANTS
- 26.7.14 HELP
- 26.7.15 IGNORE
- 26.7.16 INDEXES
- 26.7.17 INDEXFILE
- 26.7.18 LOG
- 26.7.19 PARFILE
- 26.7.20 RECORDLENGTH
- 26.7.21 RESUMABLE
- 26.7.22 RESUMABLE_NAME
- 26.7.23 RESUMABLE_TIMEOUT
- 26.7.24 ROWS
- 26.7.25 SHOW
- 26.7.26 SKIP_UNUSABLE_INDEXES
- 26.7.27 STATISTICS
- 26.7.28 STREAMS_CONFIGURATION
- 26.7.29 STREAMS_INSTANTIATION
- 26.7.30 TABLES
- 26.7.31 TABLESPACES
- 26.7.32 TOID_NOVALIDATE
- 26.7.33 TOUSER
- 26.7.34 TRANSPORT_TABLESPACE
- 26.7.35 TTS_OWNERS
- 26.7.36 USERID (username/password)
- 26.7.37 VOLSIZE
-
26.8
Example Import Sessions
- 26.8.1 Example Import of Selected Tables for a Specific User
- 26.8.2 Example Import of Tables Exported by Another User
- 26.8.3 Example Import of Tables from One User to Another
- 26.8.4 Example Import Session Using Partition-Level Import
- 26.8.5 Example Import Using Pattern Matching to Import Various Tables
- 26.9 Exit Codes for Inspection and Display
- 26.10 Error Handling During an Import
- 26.11 Table-Level and Partition-Level Import
- 26.12 Controlling Index Creation and Maintenance
- 26.13 Network Considerations for Using Oracle Net with Original Import
- 26.14 Character Set and Globalization Support Considerations
- 26.15 Using Instance Affinity
-
26.16
Considerations When Importing Database Objects
- 26.16.1 Importing Object Identifiers
- 26.16.2 Importing Existing Object Tables and Tables That Contain Object Types
- 26.16.3 Importing Nested Tables
- 26.16.4 Importing REF Data
- 26.16.5 Importing BFILE Columns and Directory Aliases
- 26.16.6 Importing Foreign Function Libraries
- 26.16.7 Importing Stored Procedures, Functions, and Packages
- 26.16.8 Importing Java Objects
- 26.16.9 Importing External Tables
- 26.16.10 Importing Advanced Queue (AQ) Tables
- 26.16.11 Importing LONG Columns
- 26.16.12 Importing LOB Columns When Triggers Are Present
- 26.16.13 Importing Views
- 26.16.14 Importing Partitioned Tables
- 26.17 Support for Fine-Grained Access Control
- 26.18 Snapshots and Snapshot Logs
- 26.19 Transportable Tablespaces
- 26.20 Storage Parameters
- 26.21 Read-Only Tablespaces
- 26.22 Dropping a Tablespace
- 26.23 Reorganizing Tablespaces
- 26.24 Importing Statistics
- 26.25 Using Export and Import to Partition a Database Migration
- 26.26 Tuning Considerations for Import Operations
- 26.27 Using Different Releases of Export and Import
-
20
ADRCI: ADR Command Interpreter
- Part V Appendixes
- A SQL*Loader Syntax Diagrams
-
B
Instant Client for SQL*Loader, Export, and Import
- B.1 What is the Tools Instant Client?
- B.2 Choosing the Instant Client to Install
- B.3 Installing Tools Instant Client by Downloading from OTN
- B.4 Installing Tools Instant Client from the 12c Client Release Media
- B.5 Configuring Tools Instant Client Package
- B.6 Connecting to a Database with the Tools Instant Client Package
- B.7 Uninstalling Instant Client
- Index