Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

---

A

• ABORT_STEP parameter
  • Data Pump Export utility 2.4.2
  • Data Pump Import utility 3.4.2
• ACCESS_METHOD parameter
  • Data Pump Export utility 2.4.3
  • Data Pump Import utility 3.4.3
• ACCESS PARAMETERS clause
  • special characters 17.1
• access privileges
  • Export and Import 24.2.3
• ADD_FILE parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.2
• ADR
  • See: automatic diagnostic repository
• ADR base
  • in ADRCI utility 19.2
• ADRCI
  • troubleshooting 19.10
• ADRCI utility 19
  • ADR base 19.2
  • ADR home 19.2
  • batch mode 19.3.3
  • commands 19.9
  • getting help 19.3
  • homepath 19.2
  • interactive mode 19.3.1
  • starting 19.3
• ADR home
  • in ADRCI utility 19.2
• Advanced Queuing
  • exporting advanced queue tables 24.14.10
  • importing advanced queue tables 25.16.10
• aliases
  • directory
    • exporting 24.14.5
    • importing 25.16.5
• analyzer statistics 25.24
• analyzing redo log files 22
• ANYDATA type
  • using SQL strings to load 10.14.6
• APPEND parameter
  • SQL*Loader utility 9.18.2
• append to table
  • SQL*Loader 9.17.2.2.1
• archived LOBs
  • restrictions on export 2.4.48
• archive logging
  • disabling in Data Pump jobs 3.4.49
  • enabling in Data Pump jobs 3.4.49
• archiving
  • disabling
    • effect on direct path loads 12.5.4.1
• array overflows 17.4.8
• arrays
  • committing after insert 25.7.2
• atomic null 11.1.5.2
• attaching to an existing job
  • Data Pump Export utility 2.4.4
• ATTACH parameter
  • Data Pump Export utility 2.4.4
  • Data Pump Import utility 3.4.4
• attributes
  • null 11.1.5.1
• attribute-value constructors
  • overriding 11.1.6
• auditing Data Pump jobs
  • unified auditing
    • Data Pump 1.12
• auditing direct path loads
  • when using SQL*Loader 12.4.8
• automatic diagnostic repository 19.2

---

B

• backslash escape character 9.3.3.2
• backups
  • restoring dropped snapshots
    • Import 25.18.2.1
• BADFILE parameter
  • SQL*Loader utility 9.10
• bad files
  • specifying for SQL*Loader 9.10
• BAD parameter
  • SQL*Loader command line 8.2.1
  • SQL*Loader express mode 13.3.1
• BEGINDATA parameter
  • SQL*Loader control file 9.8
• BFILEs
  • in original Export 24.14.6
  • in original Import 25.16.5
  • loading with SQL*Loader 11.4
• big-endian data
  • external tables 15.2.10
• binary overflows 17.4.8
• bind arrays
  • determining size of for SQL*Loader 9.20.4
  • minimizing SQL*Loader memory requirements 9.20.5
  • minimum requirements 9.20.1
  • size with multiple SQL*Loader INTO TABLE statements 9.20.6
  • specifying maximum size 8.2.2
  • specifying number of rows 8.2.31
  • SQL*Loader performance implications 9.20.2
• BINDSIZE parameter
  • SQL*Loader command line 8.2.2, 9.20.3
• blanks
  • loading fields consisting of blanks 10.10
  • SQL*Loader BLANKS parameter for field comparison 10.5.1
  • trailing 10.4.5.4
  • trimming 10.11
    • external tables 8.2.38, 13.3.21, 15.3.2
  • whitespace 10.11
• BLANKS parameter
  • SQL*Loader utility 10.5.1
• BLOBs
  • loading with SQL*Loader 11.4
• buffer cache size
  • and Data Pump operations involving Streams 5.3.1
• BUFFER parameter
  • Export utility 24.5.1
  • Import utility 25.7.1
• buffers
  • calculating for export 24.5.1
  • specifying with SQL*Loader BINDSIZE parameter 9.20.4
• byte order 10.9
  • big-endian 10.9
  • little-endian 10.9
  • specifying in SQL*Loader control file 10.9.1
• BYTEORDERMARK parameter
  • SQL*Loader utility 10.9.2.1
• byte order marks 10.9.2
  • precedence
    • for first primary datafile 10.9.2
    • for LOBFILEs and SDFs 10.9.2
  • suppressing checks for 10.9.2.1
• BYTEORDER parameter
  • SQL*Loader utility 10.9.1

---

C

• cached sequence numbers
  • Export 24.14.1
• catalog.sql script
  • preparing database for Export and Import 24.2.1, 25.2.1
• catexp.sql script
  • preparing database for Export and Import 24.2.1, 25.2.1
• CDBs
  • Oracle Data Pump support 1.3
  • using Data Pump to move data into 1.3.2
• changing a database ID 21.4.1
• changing a database name 21.4.3
• character fields
  • delimiters and SQL*Loader 10.4.2, 10.4.5
  • determining length for SQL*Loader 10.4.7
  • SQL*Loader data types 10.4.2
• character-length semantics 9.14.5.4
• character overflows 17.4.8
• CHARACTERSET parameter
  • SQL*Loader express mode 13.3.2
  • SQL*Loader utility 9.14.5.2, 13.3.2
• character sets
  • conversion
    • during Export and Import 24.12.1, 25.14.1
  • eight-bit to seven-bit conversions
    • Export/Import 24.12.3, 25.14.3
  • identifying for external tables 15.2.5
  • multibyte
    • Export/Import 24.12.4
    • SQL*Loader 9.14.1
  • single-byte
    • Export/Import 24.12.3, 25.14.3
  • SQL*Loader control file 9.14.5.3
  • SQL*Loader conversion between 9.14
  • Unicode 9.14.2
• character strings
  • external tables
    • specifying bytes or characters 15.2.12
  • SQL*Loader 10.5.2
• CHAR data type
  • delimited form and SQL*Loader 10.4.5
• check constraints
  • overriding disabling of 12.8.1.2
• CLOBs
  • loading with SQL*Loader 11.4
• CLUSTER parameter
  • Data Pump Export utility 2.4.5
  • Data Pump Import utility 3.4.5
• collections 7.10
  • loading 11.6
• collection types supported by SQL*Loader 7.10.2
• column array rows
  • specifying number of 12.5.5
• COLUMNARRAYROWS parameter
  • SQL*Loader command line 8.2.3
• column mapping 17.4.1
• column objects
  • loading 11.1
    • with user-defined constructors 11.1.6
• columns
  • exporting LONG data types 24.14.2
  • loading REF columns 11.3
  • naming
    • SQL*Loader 10.3
  • objects
    • loading nested column objects 11.1.3
    • stream record format 11.1.1
    • variable record format 11.1.2
  • reordering before Import 25.3.1
  • setting to a constant value with SQL*Loader 10.15.2
  • setting to an expression value with SQL*Loader 10.15.3
  • setting to a unique sequence number with SQL*Loader 10.15.6
  • setting to null with SQL*Loader 10.15.2.1
  • setting to the current date with SQL*Loader 10.15.5
  • setting to the datafile record number with SQL*Loader 10.15.4
  • specifying
    • SQL*Loader 10.3
  • specifying as PIECED
    • SQL*Loader 12.4.7.1
  • using SQL*Loader 10.15.3
• com.oracle.bigdata.colmap 17.4.1
• com.oracle.bigdata.datamode 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.qc 17.4.7
• com.oracle.bigdata.overflow 17.4.8
• com.oracle.bigdata.rowformat 17.4.9
• com.oracle.bigdata.tablename 17.4.10
• comments
  • in Export and Import parameter files 24.3.3, 25.5.2
  • with external tables 15.1, 16.2.1
• COMMIT parameter
  • Import utility 25.7.2
• COMPILE parameter
  • Import utility 25.7.3
• completion messages
  • Export 24.7.4
  • Import 24.7.4
• compression
  • specifying algorithm in Data Pump jobs 2.4.7
  • specifying for tables in Data Pump jobs 3.4.49
  • specifying level for external tables 16.2.2
• COMPRESSION_ALGORITHM parameter
  • Data Pump Export utility 2.4.7
• compression algorithms
  • specifying in Data Pump jobs 2.4.7
• COMPRESSION parameter
  • Data Pump Export utility 2.4.6
• COMPRESS parameter
  • Export utility 24.5.2
• CONCATENATE parameter
  • SQL*Loader utility 9.16
• concurrent conventional path loads 12.8.4
• configuration
  • of LogMiner utility 22.2.1
• CONSISTENT parameter
  • Export utility 24.5.3
    • nested tables and 24.5.3
    • partitioned table and 24.5.3
• consolidating
  • extents 24.5.2
• CONSTANT parameter
  • SQL*Loader 10.15.2
• constraints
  • automatic integrity and SQL*Loader 12.8.2.2
  • direct path load 12.8
  • disabling referential constraints 25.3.2
  • enabling
    • after a parallel direct path load 12.9.7
  • enforced on a direct load 12.8.1.1
  • failed
    • Import 25.10.1.1
  • load method 12.3.8
• CONSTRAINTS parameter
  • Export utility 24.5.4
  • Import utility 25.7.4
• constructors
  • attribute-value 11.1.6
    • overriding 11.1.6
  • user-defined 11.1.6
    • loading column objects with 11.1.6
• CONTENT parameter
  • Data Pump Export utility 2.4.8
  • Data Pump Import utility 3.4.4
• CONTINUE_CLIENT parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.3
  • Data Pump Import utility
    • interactive-command mode 3.5.2
• CONTINUEIF parameter
  • SQL*Loader utility 9.16
• control files
  • character sets 9.14.5.3
  • data definition language syntax 9.1
  • specifying data 9.8
  • specifying SQL*Loader discard file 9.11
  • SQL*Loader 9.1
• CONTROL parameter
  • SQL*Loader command line 8.2.4
• conventional path Export
  • compared to direct path 24.9
• conventional path loads
  • behavior when discontinued 9.15.1
  • compared to direct path loads 12.3.7
  • concurrent 12.9.1
  • of a single partition 12.2
  • SQL*Loader bind array 9.20.2
  • when to use 12.2.2
• conversion of character sets
  • during Export/Import 24.12.1, 25.14.1
  • effect of character set sorting on 24.12.1.1, 25.14.1.1
• conversion of data
  • during direct path loads 12.3.1
• conversion of input characters 9.14.5
• CREATE REPORT command, ADRCI utility 19.9.1
• CREATE SESSION privilege
  • Export 24.2.3, 25.2.2
  • Import 24.2.3, 25.2.2
• creating
  • incident package 19.8.2
  • tables
    • manually, before import 25.3.1
• CSV parameter
  • SQL*Loader express mode 13.3.3

---

D

• data
  • conversion
    • direct path load 12.3.1
  • delimiter marks in data and SQL*Loader 10.4.5.2
  • distinguishing different input formats for SQL*Loader 9.19
  • distinguishing different input row object subtypes 9.19, 9.19.3
  • exporting 24.5.24
  • generating unique values with SQL*Loader 10.15.6
  • including in control files 9.8
  • loading data contained in the SQL*Loader control file 10.15.1
  • loading in sections
    • SQL*Loader 12.4.7.1
  • loading into more than one table
    • SQL*Loader 9.19
  • maximum length of delimited data for SQL*Loader 10.4.5.3
  • moving between operating systems using SQL*Loader 10.8
  • recovery
    • SQL*Loader direct path load 12.4.6
  • saving in a direct path load 12.4.5
  • saving rows
    • SQL*Loader 12.5.3
  • unsorted
    • SQL*Loader 12.5.2.2
  • values optimized for SQL*Loader performance 10.15.1
• DATA_OPTIONS parameter
  • Data Pump Export utility 2.4.9
  • Data Pump Import utility 3.4.7
• database ID (DBID)
  • changing 21.4.1
• database identifier
  • changing 21.4.1
• database migration
  • partitioning of 24.17, 25.25
• database name (DBNAME)
  • changing 21.4.3
• database objects
  • exporting LONG columns 24.14.2
• databases
  • changing the database ID 21.4.1
  • changing the name 21.4.3
  • exporting entire 24.5.11
  • full import 25.7.12
  • privileges for exporting and importing 24.2.3, 25.2.2
  • reusing existing datafiles
    • Import 25.7.7
• data fields
  • specifying the SQL*Loader data type 10.3.2
• datafiles
  • preventing overwrite during import 25.7.7
  • reusing during import 25.7.7
  • specifying 8.2.5, 13.3.4
  • specifying format for SQL*Loader 9.9
• data files
  • specifying buffering for SQL*Loader 9.9
  • specifying for SQL*Loader 9.6
• DATAFILES parameter
  • Import utility 25.7.6
• data mode 17.4.2
• DATA parameter
  • SQL*Loader command line 8.2.5, 13.3.4
  • SQL*Loader express mode 13.3.4
• DATAPUMP_EXP_FULL_DATABASE role 1.4
• DATAPUMP_IMP_FULL_DATABASE role 1.4
• Data Pump Export utility
  • ABORT_STEP parameter 2.4.2
  • ACCESS_METHOD parameter 2.4.3
  • adding additional dump files 1.8.2
  • ATTACH parameter 2.4.4
  • CLUSTER parameter 2.4.5
  • command-line mode 2.4.1, 3.4
  • COMPRESSION_ALGORITHM parameter 2.4.7
  • COMPRESSION parameter 2.4.6
  • CONTENT parameter 2.4.8
  • controlling resource consumption 5.2.1
  • DATA_OPTIONS parameter 2.4.9
  • DIRECTORY parameter 2.4.10
  • DUMPFILE parameter 2.4.11
  • dump file set 2.1
  • ENCRYPTION_ALGORITHM parameter 2.4.13
  • ENCRYPTION_MODE parameter 2.4.14
  • ENCRYPTION_PASSWORD parameter 2.4.15
  • ENCRYPTION_PWD_PROMPT parameter 2.4.16
  • encryption of SecureFiles 2.4.12
  • ENCRYPTION parameter 2.4.12
  • ESTIMATE_ONLY parameter 2.4.18
  • ESTIMATE parameter 2.4.17
  • EXCLUDE parameter 2.4.19
  • excluding objects 2.4.19
  • export modes 2.2.2
  • FILESIZE command
    • interactive-command mode 2.5.5
  • FILESIZE parameter 2.4.20
  • filtering data that is exported
    • using EXCLUDE parameter 2.4.19
    • using INCLUDE parameter 2.4.25
  • FLASHBACK_SCN parameter 2.4.21
  • FLASHBACK_TIME parameter 2.4.22
  • FULL parameter 2.4.23
  • HELP parameter
    • interactive-command mode 2.5.6
  • INCLUDE parameter 2.4.25
  • interactive-command mode 2.5
    • ADD_FILE parameter 2.5.2
    • CONTINUE_CLIENT parameter 2.5.3
    • EXIT_CLIENT parameter 2.5.4
    • FILESIZE 2.5.5
    • HELP parameter 2.5.6
    • KILL_JOB parameter 2.5.7
    • PARALLEL parameter 2.5.8
    • START_JOB parameter 2.5.9
    • STATUS parameter 2.5.10, 3.5.8
    • STOP_JOB parameter 2.5.11, 3.5.9
  • interfaces 2.2.1
  • invoking
    • as SYSDBA 2.2, 3.2
  • JOB_NAME parameter 2.4.26
  • job names
    • specifying 2.4.26
  • KEEP_MASTER parameter 2.4.27
  • LOGFILE parameter 2.4.28
  • LOGTIME parameter 2.4.29
  • METRICS parameter 2.4.30
  • NETWORK_LINK parameter 2.4.31
  • NOLOGFILE parameter 2.4.32
  • PARALLEL parameter
    • command-line mode 2.4.33
    • interactive-command mode 2.5.8
  • PARFILE parameter 2.4.34
  • QUERY parameter 2.4.35
  • REMAP_DATA parameter 2.4.36
  • REUSE_DUMPFILES parameter 2.4.37
  • SAMPLE parameter 2.4.38
  • SCHEMAS parameter 2.4.39
  • SecureFiles LOB considerations 1.10
  • SERVICE_NAME parameter 2.4.40
  • SOURCE_EDITION parameter 2.4.41
  • specifying a job name 2.4.26
  • STATUS parameter 2.4.42
  • syntax diagrams 2.7
  • TABLESPACES parameter 2.4.44
  • TABLES parameter 2.4.43
  • transparent data encryption 2.4.15
  • TRANSPORT_FULL_CHECK parameter 2.4.45
  • TRANSPORT_TABLESPACES parameter 2.4.46
  • TRANSPORTABLE parameter 2.4.47
  • versioning 1.9
  • VERSION parameter 2.4.48
  • VIEWS_AS_TABLES parameter 2.4.49
• Data Pump Import utility
  • ABORT_STEP parameter 3.4.2
  • ACCESS_METHOD parameter 3.4.3
  • attaching to an existing job 3.4.4
  • ATTACH parameter 3.4.4
  • changing name of source datafile 3.4.32
  • CLUSTER parameter 3.4.5
  • CONTENT parameter 3.4.6
  • controlling resource consumption 5.2.1
  • DATA_OPTIONS parameter 3.4.7
  • DIRECTORY parameter 3.4.8
  • DUMPFILE parameter 3.4.9
  • ENCRYPTION_PASSWORD parameter 3.4.10
  • ENCRYPTION_PWD_PROMPT parameter 3.4.11
  • ESTIMATE parameter 3.4.12
  • estimating size of job 3.4.12
  • EXCLUDE parameter 3.4.13
  • filtering data that is imported
    • using EXCLUDE parameter 3.4.13
    • using INCLUDE parameter 3.4.18
  • FLASHBACK_SCN parameter 3.4.14
  • FLASHBACK_TIME parameter 3.4.15
  • full import mode 3.2.2.2
  • FULL parameter 3.4.16
  • HELP parameter
    • command-line mode 3.4.17
    • interactive-command mode 3.5.4
  • INCLUDE parameter 3.4.18
  • interactive-command mode 3.5.1
    • CONTINUE_CLIENT parameter 3.5.2
    • EXIT_CLIENT parameter 3.5.3
    • HELP parameter 3.5.4
    • KILL_JOB parameter 3.5.5
    • PARALLEL parameter 3.5.6
    • START_JOB parameter 3.5.7
    • STATUS 3.5.8
    • STOP_JOB parameter 3.5.9
  • interfaces 3.2.1
  • JOB_NAME parameter 3.4.19
  • KEEP_MASTER parameter 3.4.20
  • LOGTIME parameter 3.4.22
  • MASTER_ONLY parameter 3.4.23
  • METRICS parameter 3.4.24
  • NETWORK_LINK parameter 3.4.25
  • NOLOGFILE parameter 3.4.26
  • PARALLEL parameter
    • command-line mode 3.4.27
  • PARFILE parameter 3.4.28
  • PARTITION_OPTIONS parameter 3.4.29
  • QUERY parameter 3.4.30
  • REMAP_DATAFILE parameter 3.4.32
  • REMAP_DATA parameter 3.4.31
  • REMAP_SCHEMA parameter 3.4.34
  • REMAP_TABLE parameter 3.4.35
  • REMAP_TABLESPACE parameter 3.4.36
  • REUSE_DATAFILES parameter 3.4.45
  • schema mode 3.2.2.3
  • SCHEMAS parameter 3.4.37
  • SERVICE_NAME parameter 3.4.38
  • SKIP_UNUSABLE_INDEXES parameter 3.4.39
  • SOURCE_EDITION parameter 3.4.40
  • specifying a job name 3.4.19
  • specifying dump file set to import 3.4.9
  • SQLFILE parameter 3.4.41
  • STATUS parameter 3.4.42
  • STREAMS_CONFIGURATION parameter 3.4.43
  • syntax diagrams 3.7
  • TABLE_EXISTS_ACTION parameter 3.4.44
  • table mode 3.2.2.4
  • tablespace mode 3.2.2.5
  • TABLESPACES parameter 3.4.47
  • TABLES parameter 3.4.46
  • TARGET_EDITION parameter 3.4.48
  • TRANSFORM parameter 3.4.49
  • transparent data encryption 3.4.10
  • TRANSPORT_FULL_CHECK parameter 3.4.51
  • TRANSPORT_TABLESPACES parameter 3.4.52
  • TRANSPORTABLE parameter 3.4.53
  • transportable tablespace mode 3.2.2.6
  • versioning 1.9
  • VERSION parameter 3.4.54
  • VIEWS_AS_TABLES parameter (Network Import) 3.4.55
  • VIEWS_AS_TABLES parameter (Non-Network Import) 3.4.56
• Data Pump legacy mode 4
• data source name 17.4.10
• data types
  • BFILEs
    • in original Export 24.14.6
    • in original Import 25.16.5
    • loading with SQL*Loader 11.4
  • BLOBs
    • loading with SQL*Loader 11.4
  • CLOBs
    • loading with SQL*Loader 11.4
  • converting SQL*Loader 10.4.3
  • describing for external table fields 15.3.6
  • determining character field lengths for SQL*Loader 10.4.7
  • determining DATE length 10.4.7.3
  • identifying for external tables 15.3.4
  • native
    • conflicting length specifications in SQL*Loader 10.4.2.9
  • NCLOBs
    • loading with SQL*Loader 11.4
  • nonscalar 11.1.5
  • specifying in SQL*Loader 10.3.2
  • supported by the LogMiner utility 22.14.1
  • types used by SQL*Loader 10.4
  • unsupported by LogMiner utility 22.14.2
• data types (HDFS) 17.4.4
• DATE_CACHE parameter
  • SQL*Loader utility 8.2.6
• DATE_FORMAT parameter
  • SQL*Loader express mode 13.3.5
• date cache feature
  • DATE_CACHE parameter 8.2.6
  • external tables 15.6
  • SQL*Loader 12.5.6
• DATE data type
  • delimited form and SQL*Loader 10.4.5
  • determining length 10.4.7.3
  • mask
    • SQL*Loader 10.4.7.3
• DBID (database identifier)
  • changing 21.4.1
• DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure
  • LogMiner utility and 22.2.2
• DBMS_LOGMNR_D.BUILD PL/SQL procedure
  • LogMiner utility and 22.2.2
• DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure
  • LogMiner utility and 22.2.2
• DBMS_LOGMNR_D PL/SQL procedure
  • LogMiner utility and 22.2.2
• DBMS_LOGMNR.COLUMN_PRESENT function 22.6.2
• DBMS_LOGMNR.MINE_VALUE function 22.6.2
  • null values and 22.6.2.1
• DBMS_LOGMNR.START_LOGMNR PL/SQL procedure 22.5
  • calling multiple times 22.9
  • COMMITTED_DATA_ONLY option 22.7.1
  • LogMiner utility and 22.2.2
  • options for 22.5
  • PRINT_PRETTY_SQL option 22.7.6
  • SKIP_CORRUPTION option 22.7.2
• DBMS_LOGMNR.START_LOGMNR procedure
  • ENDTIME parameter 22.7.3, 22.7.4
  • STARTTIME parameter 22.7.3, 22.7.4
• DBMS_LOGMNR PL/SQL procedure
  • LogMiner utility and 22.2.2
• DBMS_METADATA PL/SQL package 23.3.1
• DBNAME
  • changing 21.4.3
• DBNEWID utility 21
  • changing a database ID 21.4.1
  • changing a database name 21.4.3
  • effect on global database names 21.2.1
  • restrictions 21.5.2
  • syntax 21.5
  • troubleshooting a database ID change 21.4.4
• DBVERIFY utility
  • output 20.1.3
  • restrictions 20
  • syntax 20.1.1
  • validating a segment 20.2
  • validating disk blocks 20.1
• DEFAULTIF parameter
  • SQL*Loader 10.5
• default schema
  • as determined by SQL*Loader 9.17.1.1
• DEGREE_OF_PARALLELISM parameter
  • SQL*Loader command line 8.2.8
  • SQL*Loader express mode 13.3.6
• DELETE ANY TABLE privilege
  • SQL*Loader 9.17.2.2.4
• DELETE CASCADE
  • effect on loading nonempty tables 9.17.2.2.2
  • SQL*Loader 9.17.2.2.4
• DELETE privilege
  • SQL*Loader 9.17.2.2.2
• delimited data
  • maximum length for SQL*Loader 10.4.5.3
• delimited fields
  • field length 10.4.7.2
• delimited LOBs 11.4.2.2.3
• delimited text files 17.4.9
• delimiters
  • in external tables 15.2.3
  • loading trailing blanks 10.4.5.4
  • marks in data and SQL*Loader 10.4.5.2
  • specifying for external tables 15.3.1
  • specifying for SQL*Loader 9.17.5, 10.4.5
  • SQL*Loader enclosure 10.11.2.2
  • SQL*Loader field specifications 10.11.2.2
  • termination 10.11.2.2
• DESTROY parameter
  • Import utility 25.7.7
• dictionary
  • requirements for LogMiner utility 22.2.1.2
• dictionary version mismatch 22.10.4
• Direct NFS Client
  • controlling number of read buffers 8.2.14
  • use during SQL*Loader operations 8.2.13
  • using with external tables 15.2.27
• directory aliases
  • exporting 24.14.5
  • importing 25.16.5
• directory objects
  • using with Data Pump
    • effect of Oracle ASM 1.8.3.3
• DIRECTORY parameter
  • Data Pump Export utility 2.4.10
  • Data Pump Import utility 3.4.8
• DIRECT parameter
  • Export utility 24.5.5
  • SQL*Loader command-line 8.2.9
  • SQL*Loader express mode 13.3.7
• direct path Export 24.9, 24.10
  • compared to conventional path 24.9
  • effect of EXEMPT ACCESS POLICY privilege 24.10.1
  • performance issues 24.10.2
  • restrictions 24.10.3
  • security considerations 24.10.1
• direct path load
  • advantages 12.3.4
  • behavior when discontinued 9.15.2
  • choosing sort order
    • SQL*Loader 12.5.2.4
  • compared to conventional path load 12.3.7
  • concurrent 12.9.3
  • conditions for use 12.3.5
  • data saves 12.4.5, 12.5.3
  • dropping indexes 12.7
  • effect of disabling archiving 12.5.4
  • effect of PRIMARY KEY constraints 12.9.8
  • effect of UNIQUE KEY constraints 12.9.8
  • field defaults 12.3.9
  • improper sorting
    • SQL*Loader 12.5.2.2
  • indexes 12.4.3
  • instance recovery 12.4.6
  • intersegment concurrency 12.9.3
  • intrasegment concurrency 12.9.3
  • location of data conversion 12.3.1
  • media recovery 12.4.6.1
  • optimizing on multiple-CPU systems 12.6
  • partitioned load
    • SQL*Loader 12.8.4
  • performance 12.4.3, 12.5
  • preallocating storage 12.5.1
  • presorting data 12.5.2
  • recovery 12.4.6
  • ROWS command-line parameter 12.4.5.1
  • setting up 12.4.1
  • specifying 12.4.2
  • specifying number of rows to be read 8.2.31
  • SQL*Loader data loading method 7.9.2
  • table insert triggers 12.8.2
  • temporary segment storage requirements 12.4.3.2
  • triggers 12.8
  • using 12.3.7, 12.4
  • version requirements 12.3.5
• disabled unique indexes
  • loading tables with 1.2
• discarded SQL*Loader records 7.7
  • causes 9.11.3
  • discard file 9.11
  • limiting 9.11.1.1
• discard files
  • SQL*Loader 9.11
    • specifying a maximum 9.11.5
• DISCARD parameter
  • SQL*Loader command-line 8.2.11
• discontinued loads 9.15
  • continuing 9.15.5
  • conventional path behavior 9.15.1
  • direct path behavior 9.15.2
• DNFS_ENABLE parameter
  • SQL*Loader command-line 8.2.13
  • SQL*Loader express mode 13.3.8
• DNFS_READBUFFERS parameter
  • SQL*Loader command-line 8.2.14
  • SQL*Loader express mode 13.3.9
• dropped snapshots
  • Import 25.18.2.1
• DUMPFILE parameter
  • Data Pump Export utility 2.4.11
  • Data Pump Import utility 3.4.9
• dump files
  • maximum size 24.5.8

---

E

• EBCDIC character set
  • Import 24.12.3, 25.14.3
• ECHO command, ADRCI utility 19.9.2
• eight-bit character set support 24.12.3, 25.14.3
• ENCLOSED_BY parameter
  • SQL*Loader express mode 13.3.10
• enclosed fields
  • whitespace 10.11.6
• enclosure delimiters 10.4.5
  • SQL*Loader 10.11.2.2
• encrypted columns
  • in external tables 16.2.6
• ENCRYPTION_ALGORITHM parameter
  • Data Pump Export utility 2.4.13
• ENCRYPTION_MODE parameter
  • Data Pump Export utility 2.4.14
• ENCRYPTION_PASSWORD parameter
  • Data Pump Export utility 2.4.15
  • Data Pump Import utility 3.4.10
• ENCRYPTION_PWD_PROMPT parameter
  • Data Pump Export utility 2.4.16
  • Data Pump Import utility 3.4.11
• ENCRYPTION parameter
  • Data Pump Export utility 2.4.12
• encryption password
  • Data Pump export 2.4.16
  • Data Pump Import 3.4.11
• error handling 17.4.3
• errors
  • caused by tab characters in SQL*Loader data 10.2.1
  • LONG data 25.10.1.2
  • object creation 25.10.2.1
    • Import parameter IGNORE 25.7.15
  • resource errors on import 25.10.2.3
  • writing to export log file 24.5.15
• ERRORS parameter
  • SQL*Loader command line 8.2.16
• escape character
  • quoted strings and 9.3.3.2
  • usage in Data Pump Export 2.4.1
  • usage in Data Pump Import 3.4
  • usage in Export 24.5.26.1
  • usage in Import 25.7.30
• ESTIMATE_ONLY parameter
  • Data Pump Export utility 2.4.18
• ESTIMATE parameter
  • Data Pump Export utility 2.4.17
  • Data Pump Import utility 3.4.12
• estimating size of job
  • Data Pump Export utility 2.4.17
• EVALUATE CHECK_CONSTRAINTS clause 12.8.1.2
• EXCLUDE parameter
  • Data Pump Export utility 2.4.19
  • Data Pump Import utility 3.4.13
• EXIT_CLIENT parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.4
  • Data Pump Import utility
    • interactive-command mode 3.5.3
• exit codes
  • Export and Import 24.8, 25.9
  • SQL*Loader 1.11, 8.3
• EXIT command, ADRCI utility 19.9.3
• EXP_FULL_DATABASE role
  • assigning in Export 24.2.1, 25.2.1
• expdat.dmp
  • Export output file 24.5.7
• Export
  • BUFFER parameter 24.5.1
  • character set conversion 24.12.1, 25.14.1
  • COMPRESS parameter 24.5.2
  • CONSISTENT parameter 24.5.3
  • CONSTRAINTS parameter 24.5.4
  • conventional path 24.9
  • creating
    • necessary privileges 24.2.1, 25.2.1
    • necessary views 24.2.1, 25.2.1
  • DIRECT parameter 24.5.5
  • direct path 24.9
  • displaying online help 24.5.13
  • example sessions 24.6
    • full database mode 24.6.1
    • partition-level 24.6.4
    • table mode 24.6.3
    • user mode 24.5.17, 24.6.2
  • exit codes 24.8, 25.9
  • exporting an entire database 24.5.11
  • exporting indexes 24.5.14
  • exporting sequence numbers 24.14.1
  • exporting synonyms 24.14.11
  • exporting to another operating system 24.5.20, 25.7.20
  • FEEDBACK parameter 24.5.6
  • FILE parameter 24.5.7
  • FILESIZE parameter 24.5.8
  • FLASHBACK_SCN parameter 24.5.9
  • FLASHBACK_TIME parameter 24.5.10
  • full database mode
    • example 24.6.1
  • FULL parameter 24.5.11
  • GRANTS parameter 24.5.12
  • HELP parameter 24.5.13
  • INDEXES parameter 24.5.14
  • invoking 24.3, 25.5
  • log files
    • specifying 24.5.15
  • logging error messages 24.5.15
  • LOG parameter 24.5.15
  • LONG columns 24.14.2
  • OBJECT_CONSISTENT parameter 24.5.16
  • online help 24.3.5
  • OWNER parameter 24.5.17
  • parameter file 24.5.18
    • maximum size 24.3.3, 25.5.2
  • parameter syntax 24.5
  • PARFILE parameter 24.5.18
  • partitioning a database migration 24.17, 25.25
  • QUERY parameter 24.5.19
  • RECORDLENGTH parameter 24.5.20
  • redirecting output to a log file 24.7.1
  • remote operation 24.11.2, 25.13
  • restrictions based on privileges 24.2.3
  • RESUMABLE_NAME parameter 24.5.22
  • RESUMABLE_TIMEOUT parameter 24.5.23
  • RESUMABLE parameter 24.5.21
  • ROWS parameter 24.5.24
  • sequence numbers 24.14.1
  • storage requirements 24.2.2
  • table mode
    • example session 24.6.3
  • table name restrictions 24.5.26.1
  • TABLESPACES parameter 24.5.27
  • TABLES parameter 24.5.26
  • TRANSPORT_TABLESPACE parameter 24.5.28
  • TRIGGERS parameter 24.5.29
  • TTS_FULL_CHECK parameter 24.5.30
  • user access privileges 24.2.3, 25.2.2
  • USERID parameter 24.5.31
  • user mode
    • example session 24.5.17, 24.6.2
    • specifying 24.5.17
  • VOLSIZE parameter 24.5.32
• export dump file
  • importing the entire file 25.7.12
• export file
  • listing contents before importing 25.7.25
  • specifying 24.5.7
• exporting
  • archived LOBs 2.4.48
• EXPRESSION parameter
  • SQL*Loader 10.15.3, 10.15.3.1
• extents
  • consolidating 24.5.2
• EXTERNAL_TABLE parameter
  • SQL*Loader command line 8.2.17
  • SQL*Loader express mode 13.3.11
• EXTERNAL parameter
  • SQL*Loader 10.4.2.5
• EXTERNAL SQL*Loader data types
  • numeric
    • determining len 10.4.7
• external tables 14
  • access parameters 14.3, 15.1, 16.2
  • and encrypted columns 16.2.6
  • big-endian data 15.2.10
  • cacheing data during reads 15.2.26
  • column_transforms clause 15.1
  • data types 15.3.6
  • date cache feature 15.6
  • delimiters 15.2.3
  • describing data type of a field 15.3.6
  • field_definitions clause 15.1, 15.3
  • fixed-length records 15.2.1
  • identifying character sets 15.2.5
  • identifying data types 15.3.4
  • improving performance when using
    • date cache feature 15.6
  • IO_OPTIONS clause 15.2.26
  • little-endian data 15.2.10
  • opaque_format_spec 14.3, 15.1, 16.2
  • preprocessing data 15.2.7
  • record_format_info clause 15.1, 15.2
  • reserved words 15.7, 16.7
  • restrictions 15.7
  • setting a field to a default value 15.3.7
  • setting a field to null 15.3.7
  • skipping records when loading data 15.2.17
  • specifying compression level 16.2.2
  • specifying delimiters 15.3.1
  • specifying load conditions 15.2.13
  • trimming blanks 8.2.38, 13.3.21, 15.3.2
  • use of SQL strings 15.7
  • using comments 15.1, 16.2.1
  • variable-length records 15.2.2

---

F

• fatal errors
  • See: nonrecoverable error messages
• FEEDBACK parameter
  • Export utility 24.5.6
  • Import utility 25.7.8
• FIELD_NAMES parameter
  • SQL*Loader express mode 13.3.12
• field conditions
  • specifying for SQL*Loader 10.5
• field extraction 17.4.9
• field length
  • SQL*Loader specifications 10.11.2
• field location
  • SQL*Loader 10.2
• field names 17.4.4
• fields
  • comparing to literals with SQL*Loader 10.5.2
  • delimited
    • determining length 10.4.7.2
    • SQL*Loader 10.4.5
  • loading all blanks 10.10
  • predetermined size
    • length 10.4.7.1
    • SQL*Loader 10.11.2.1
  • relative positioning and SQL*Loader 10.11.3
  • specifying default delimiters for SQL*Loader 9.17.5
  • specifying for SQL*Loader 10.3
  • SQL*Loader delimited
    • specifications 10.11.2.2
• FIELDS clause
  • SQL*Loader 9.17.5
• file allocation in Data Pump
  • adding dump files 1.8.2
  • default file locations 1.8.3.1
  • NFS errors 1.8
• file names
  • quotation marks and 9.3.3.1
  • specifying multiple SQL*Loader 9.6.2
  • SQL*Loader 9.3
  • SQL*Loader bad file 9.10
• FILE parameter
  • Export utility 24.5.7
  • Import utility 25.7.9
  • SQL*Loader command line 8.2.18
  • SQL*Loader utility 12.9.6.1
• FILESIZE parameter
  • Data Pump Export utility 2.4.20
  • Export utility 24.5.8
  • Import utility 25.7.10
• FILLER field
  • using as argument to init_spec 10.3.1
• filtering data
  • using Data Pump Export utility 2.1
  • using Data Pump Import utility 3.1
• filtering metadata that is imported
  • Data Pump Import utility 3.4.13
• finalizing
  • in ADRCI utility 19.2
• fine-grained access support
  • Export and Import 25.17
• fixed-format records 7.4.1
• fixed-length records
  • external tables 15.2.1
• FLASHBACK_SCN parameter
  • Data Pump Export utility 2.4.21
  • Data Pump Import utility 3.4.14
  • Export utility 24.5.9
• FLASHBACK_TIME parameter
  • Data Pump Export utility 2.4.22
  • Data Pump Import utility 3.4.15
  • Export utility 24.5.10
• foreign function libraries
  • exporting 24.14.3
  • importing 25.16.6, 25.16.9
• formats
  • SQL*Loader input records and 9.19.2
• formatting errors
  • SQL*Loader 9.10
• FROMUSER parameter
  • Import utility 25.7.11
• full database mode
  • Import 25.7.12
  • specifying with FULL 24.5.11
• full export mode
  • Data Pump Export utility 2.2.2.1
• FULL parameter
  • Data Pump Export utility 2.4.23
  • Data Pump Import utility 3.4.16
  • Export utility 24.5.11
  • Import utility 25.7.12
• full transportable export 2.2.2.1
• full transportable import 3.2.2.2

---

G

• globalization
  • SQL*Loader 9.14
• grants
  • exporting 24.5.12
  • importing 25.7.13
• GRANTS parameter
  • Export utility 24.5.12
  • Import utility 25.7.13

---

H

• HELP parameter
  • Data Pump Export utility
    • command-line mode 2.4.24
    • interactive-command mode 2.5.6
  • Data Pump Import utility
    • command-line mode 3.4.17
    • interactive-command mode 3.5.4
  • Export utility 24.5.13
  • Import utility 25.7.14
• hexadecimal strings
  • SQL*Loader 10.5.2
• Hive table sources 17.4.10
• homepath
  • in ADRCI utility 19.2
• HOST command, ADRCI utility 19.9.4

---

I

• IGNORE parameter
  • Import utility 25.7.15
• IMP_FULL_DATABASE role
  • assigning in Import 24.2.1, 25.2.1
• Import
  • BUFFER parameter 25.7.1
  • character set conversion 24.12.1, 25.14.1, 24.12.3, 25.14.3
  • COMMIT parameter 25.7.2
  • committing after array insert 25.7.2
  • COMPILE parameter 25.7.3
  • CONSTRAINTS parameter 25.7.4
  • creating
    • necessary privileges 24.2.1, 25.2.1
    • necessary views 24.2.1, 25.2.1
  • creating an index-creation SQL script 25.7.17
  • database optimizer statistics 25.7.27
  • DATAFILES parameter 25.7.6
  • DESTROY parameter 25.7.7
  • disabling referential constraints 25.3.2
  • displaying online help 25.7.14
  • dropping a tablespace 25.22
  • errors importing database objects 25.10.2
  • example sessions 25.8
    • all tables from one user to another 25.8.3
    • selected tables for specific user 25.8.1
    • tables exported by another user 25.8.2
    • using partition-level Import 25.8.4
  • exit codes 24.8, 25.9
  • export file
    • importing the entire file 25.7.12
    • listing contents before import 25.7.25
  • FEEDBACK parameter 25.7.8
  • FILE parameter 25.7.9
  • FILESIZE parameter 25.7.10
  • FROMUSER parameter 25.7.11
  • FULL parameter 25.7.12
  • grants
    • specifying for import 25.7.13
  • GRANTS parameter 25.7.13
  • HELP parameter 25.7.14
  • IGNORE parameter 25.7.15
  • importing grants 25.7.13
  • importing objects into other schemas 25.2.2.3
  • importing tables 25.7.30
  • INDEXFILE parameter 25.7.17
  • INSERT errors 25.10.1.2
  • invalid data 25.10.1.2
  • invoking 24.3, 25.5
  • LOG parameter 25.7.18
  • LONG columns 25.16.11
  • manually creating tables before import 25.3.1
  • manually ordering tables 25.3.3
  • NLS_LANG environment variable 24.12.3, 25.14.3
  • object creation errors 25.7.15
  • online help 24.3.5
  • parameter file 25.7.19
    • maximum size 24.3.3, 25.5.2
  • parameter syntax 25.7
  • PARFILE parameter 25.7.19
  • partition-level 25.11
  • pattern matching of table names 25.7.30
  • read-only tablespaces 25.21
  • RECORDLENGTH parameter 25.7.20
  • records
    • specifying length 25.7.20
  • redirecting output to a log file 24.7.1
  • refresh error 25.18.1
  • remote operation 24.11.2, 25.13
  • reorganizing tablespace during 25.23
  • resource errors 25.10.2.3
  • restrictions
    • importing into own schema 25.2.2.1
  • RESUMABLE_NAME parameter 25.7.22
  • RESUMABLE_TIMEOUT parameter 25.7.23
  • RESUMABLE parameter 25.7.21
  • reusing existing datafiles 25.7.7
  • schema objects 25.2.2.3
  • sequences 25.10.2.2
  • SHOW parameter 25.7.25
  • single-byte character sets 24.12.3, 25.14.3
  • SKIP_UNUSABLE_INDEXES parameter 25.7.26
  • snapshot master table 25.18.1
  • snapshots 25.18
    • restoring dropped 25.18.2.1
  • specifying by user 25.7.11
  • specifying index creation commands 25.7.17
  • specifying the export file 25.7.9
  • STATISTICS parameter 25.7.27
  • storage parameters
    • overriding 25.20.3
  • stored functions 25.16.7
  • stored procedures 25.16.7
  • STREAMS_CONFIGURATION parameter 25.7.28
  • STREAMS_INSTANTIATION parameter 25.7.29
  • system objects 25.2.2.4
  • table-level 25.11
  • table name restrictions 2.4.43, 3.4.46, 25.7.30.1
  • table objects
    • import order 25.1.1
  • TABLESPACES parameter 25.7.31
  • TABLES parameter 25.7.30
  • TOID_NOVALIDATE parameter 25.7.32
  • TOUSER parameter 25.7.33
  • TRANSPORT_TABLESPACE parameter 25.7.34
  • TTS_OWNER parameter 25.7.35
  • tuning considerations 25.26
  • user access privileges 24.2.3, 25.2.2
  • USERID parameter 25.7.36
  • VOLSIZE parameter 25.7.37
• incident
  • fault diagnosability infrastructure 19.2
  • packaging 19.8
• incident package
  • fault diagnosability infrastructure 19.2
• INCLUDE parameter
  • Data Pump Export utility 2.4.25
  • Data Pump Import utility 3.4.18
• indexes
  • creating manually 25.7.17
  • direct path load
    • left in direct load state 12.4.4
  • dropping
    • SQL*Loader 12.7
  • estimating storage requirements 12.4.3.1
  • exporting 24.5.14
  • index-creation commands
    • Import 25.7.17
  • left in unusable state 9.15.3, 12.5.2.2
  • multiple-column
    • SQL*Loader 12.5.2.3
  • presorting data
    • SQL*Loader 12.5.2
  • skipping unusable 8.2.36
  • SQL*Loader 9.18
  • state after discontinued load 9.15.3
  • unique 25.7.16
• INDEXES parameter
  • Export utility 24.5.14
• INDEXFILE parameter
  • Import utility 25.7.17
• index options
  • SORTED INDEXES with SQL*Loader 9.18.1
  • SQL*Loader SINGLEROW parameter 9.18.2
• Index Unusable state
  • indexes left in Index Unusable state 9.15.3, 12.4.4
• INFILE parameter
  • SQL*Loader utility 9.6
• insert errors
  • Import 25.10.1.2
  • specifying 8.2.16
• INSERT into table
  • SQL*Loader 9.17.2.1, 9.17.2.1.1
• instance affinity
  • Export and Import 24.13
• instance recovery 12.4.6.2
• integrity constraints
  • disabled during direct path load 12.8.1.2
  • enabled during direct path load 12.8.1.1
  • failed on Import 25.10.1.1
  • load method 12.3.8
• interactive method
  • Data Pump Export utility 2.2.1
• internal LOBs
  • loading 11.4.1
• interrupted loads 9.15
• INTO TABLE statement
  • effect on bind array size 9.20.6
  • multiple statements with SQL*Loader 9.19
  • SQL*Loader 9.17
    • column names 10.3
    • discards 9.11.3
• invalid data
  • Import 25.10.1.2
• invoking
  • Export 24.3, 25.5
    • at the command line 24.3.2, 25.5.1
    • direct path 24.10
    • interactively 24.3.4, 25.5.3
    • with a parameter file 24.3.3, 25.5.2
  • Import 24.3, 25.5
    • as SYSDBA 24.3.1, 25.5.4
    • at the command line 24.3.2, 25.5.1
    • interactively 24.3.4, 25.5.3
    • with a parameter file 24.3.3, 25.5.2
• IPS command, ADRCI utility 19.9.5

---

J

• JOB_NAME parameter
  • Data Pump Export utility 2.4.26
  • Data Pump Import utility 3.4.19

---

K

• KEEP_MASTER parameter
  • Data Pump Export utility 2.4.27
  • Data Pump Import utility 3.4.20
• key values
  • generating with SQL*Loader 10.15.6
• KILL_JOB parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.7
  • Data Pump Import utility 3.5.5

---

L

• leading whitespace
  • definition 10.11.1
  • trimming and SQL*Loader 10.11.4
• legacy mode in Data Pump 4
• length indicator
  • determining size 9.20.4.1
• length-value pair specified LOBs 11.4.2.2.4
• libraries
  • foreign function
    • exporting 24.14.3
    • importing 25.16.6, 25.16.9
• little-endian data
  • external tables 15.2.10
• loading
  • collections 11.6
  • column objects 11.1
    • in variable record format 11.1.2
    • with a derived subtype 11.1.4
    • with user-defined constructors 11.1.6
  • datafiles containing tabs
    • SQL*Loader 10.2.1
  • external table data
    • skipping records 15.2.17
    • specifying conditions 15.2.10, 15.2.23
  • LOBs 11.4
  • nested column objects 11.1.3
  • object tables 11.2
  • object tables with a subtype 11.2.1
  • REF columns 11.3
  • subpartitioned tables 12.3.2
  • tables 12.3.2
• LOAD parameter
  • SQL*Loader command line 8.2.20, 13.3.13
  • SQL*Loader express mode 13.3.13
• LOB data
  • in delimited fields 11.4.1.2
  • in length-value pair fields 11.4.1.3
  • in predetermined size fields 11.4.1.1
  • loading with SQL*Loader 11.4
  • no compression during export 24.5.2
  • size of read buffer 8.2.27
  • specifying storage in Data Pump 3.4.49
  • types supported by SQL*Loader 7.10.3, 11.4
• LOB data types 7.5
• LOBFILEs 7.5, 11.4, 11.4.2
• LOGFILE parameter
  • Data Pump Export utility 2.4.28
  • Data Pump Import utility 3.4.21
    • LOGFILE parameter 3.4.21
• log files 17.4.7
  • after a discontinued load 9.15.4
  • Export 24.5.15, 24.7.1
  • Import 24.7.1, 25.7.18
  • limiting data written to by Data Pump 3.4.49
  • specifying for SQL*Loader 8.2.21
  • SQL*Loader 7.8
• logical records
  • consolidating multiple physical records using SQL*Loader 9.16
• LogMiner utility
  • accessing redo data of interest 22.6
  • adjusting redo log file list 22.9
  • analyzing output 22.6.1
  • configuration 22.2.1
  • considerations for reapplying DDL statements 22.8
  • current log file list
    • stored information about 22.11.1
  • DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and 22.2.2
  • DBMS_LOGMNR_D.BUILD PL/SQL procedure and 22.2.2
  • DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and 22.2.2
  • DBMS_LOGMNR_D PL/SQL procedure and 22.2.2
  • DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and 22.2.2
  • DBMS_LOGMNR PL/SQL procedure and 22.2.2
  • DDL tracking
    • time or SCN ranges 22.10.6
  • determining redo log files being analyzed 22.4.2
  • dictionary
    • purpose of 22.2.1
  • dictionary extracted to flat file
    • stored information about 22.11
  • dictionary options 22.4.1
    • flat file and 22.4.1
    • online catalog and 22.4.1
    • redo log files and 22.4.1
  • ending a session 22.12.6
  • executing reconstructed SQL 22.7.5
  • extracting data values from redo logs 22.6.2
  • filtering data by SCN 22.7.4
  • filtering data by time 22.7.3
  • formatting returned data 22.7.6
  • graphical user interface 22
  • levels of supplemental logging 22.10
  • LogMiner dictionary defined 22.2.1
  • mining a subset of data in redo log files 22.9
  • mining database definition for 22.2.1
  • Object or Data type Unsupported 22.2.1.2
  • operations overview 22.2.2
  • parameters
    • stored information about 22.11
  • redo log files
    • on a remote database 22.9
    • stored information about 22.11
  • requirements for dictionary 22.2.1.2
  • requirements for redo log files 22.2.1.2
  • requirements for source and mining databases 22.2.1.2
  • restrictions with XMLType data 22.6.3.1
  • sample configuration 22.2.1.1
  • showing committed transactions only 22.7.1
  • skipping corruptions 22.7.2
  • source database definition for 22.2.1
  • specifying redo log files to mine 22.4.2
    • automatically 22.4.2
    • manually 22.4.2
  • specifying redo logs for analysis 22.12.3
  • starting 22.5, 22.12.4
  • starting multiple times within a session 22.9
  • steps for extracting dictionary to a flat file 22.4.1.3
  • steps for extracting dictionary to redo log files 22.4.1.2
  • steps for using dictionary in online catalog 22.4.1.1
  • steps in a typical session 22.12
  • supplemental logging 22.10
    • database level 22.10.1
    • database-level identification keys 22.10.1.2
    • disabling database-level 22.10.2
    • interactions with DDL tracking 22.10.5
    • log groups 22.10
    • minimal 22.10.1.1
    • stored information about 22.11
    • table-level identification keys 22.10.3.1
    • table-level log groups 22.10.3.2
    • user-defined log groups 22.10.3.3
  • supplemental log groups 22.10
    • conditional 22.10
    • unconditional 22.10
  • supported database versions 22.14.3
  • supported data types 22.14.1
  • supported redo log file versions 22.14.3
  • support for transparent data encryption 22.6
  • suppressing delimiters in SQL_REDO and SQL_UNDO 22.7.5
  • table-level supplemental logging 22.10.3
  • tracking DDL statements 22.10.4
    • requirements 22.10.4
  • unsupported data types 22.14.2
  • using in a CDB 22.3
  • using the online catalog 22.4.1.1
  • using to analyze redo log files 22
  • V$DATABASE view 22.11
  • V$LOGMNR_CONTENTS view 22.2.2, 22.6.1, 22.7
  • V$LOGMNR_LOGS view
    • querying 22.11.1
  • views 22.11
• LogMiner Viewer 22
• LOG parameter
  • Export utility 24.5.15
  • Import utility 25.7.18
  • SQL*Loader command line 8.2.21
• LOGTIME parameter
  • Data Pump Export utility 2.4.29
  • Data Pump Import utility 3.4.22
• LONG data
  • exporting 24.14.2
  • importing 25.16.11

---

M

• MASTER_ONLY parameter
  • Data Pump Import utility 3.4.23
• master tables
  • Oracle Data Pump API 1.5.2
  • snapshots
    • original Import 25.18.1
• materialized views 25.18
• media recovery
  • direct path load 12.4.6.1
• Metadata API
  • enhancing performance 23.7
  • retrieving collections 23.5
  • using to retrieve object metadata 23.3
• METRICS parameter
  • Data Pump Export utility 2.4.30
  • Data Pump Import utility 3.4.24
• missing data columns
  • SQL*Loader 9.17.6
• multibyte character sets
  • blanks with SQL*Loader 10.5.1
  • SQL*Loader 9.14.1
• multiple-column indexes
  • SQL*Loader 12.5.2.3
• multiple-CPU systems
  • optimizing direct path loads 12.6
• multiple-table load
  • generating unique sequence numbers using SQL*Loader 10.15.7
  • SQL*Loader control file specification 9.19
• multitenant architecture 22.3.2
• multitenant container databases 1.3, 22.3
• multithreading
  • on multiple-CPU systems 12.6
• MULTITHREADING parameter
  • SQL*Loader command line 8.2.22

---

N

• named pipes
  • external table loads 7.9.3
• native data types
  • conflicting length specifications
    • SQL*Loader 10.4.2.9
• NCLOBs
  • loading with SQL*Loader 11.4
• nested column objects
  • loading 11.1.3
• nested tables
  • exporting 24.14.9
    • consistency and 24.5.3
  • importing 25.16.3
• NETWORK_LINK parameter
  • Data Pump Export utility 2.4.31
  • Data Pump Import utility 3.4.25
• networks
  • Export and Import 24.11, 25.13
• NFS errors when using Data Pump 1.8
• NLS_LANG environment variable 24.12.2, 25.14.2
  • with Export and Import 24.12.3, 25.14.3
• NO_INDEX_ERRORS parameter
  • SQL*Loader command line 8.2.23
• NOLOGFILE parameter
  • Data Pump Export utility 2.4.32
  • Data Pump Import utility 3.4.26
• nonrecoverable error messages
  • Export 24.7.3
  • Import 24.7.3
• nonscalar data types 11.1.5
• NOT NULL constraint
  • load method 12.3.8
• null data
  • missing columns at end of record during load 9.17.6
  • unspecified columns and SQL*Loader 10.3
• NULLIF...BLANKS clause
  • SQL*Loader 10.5.1
• NULLIF clause
  • SQL*Loader 10.5, 10.10
• NULLIF parameter
  • SQL*Loader express mode 13.3.14
• nulls
  • atomic 11.1.5.2
  • attribute 11.1.5.1
• NULL values
  • objects 11.1.5
• NUMBER data type
  • SQL*Loader 10.4.3, 10.4.4
• numeric EXTERNAL data types
  • delimited form and SQL*Loader 10.4.5
  • determining length 10.4.7

---

O

• OBJECT_CONSISTENT parameter
  • Export utility 24.5.16
• object identifiers 11.2
  • importing 25.16.1
• object names
  • SQL*Loader 9.3
• objects 7.10
  • creation errors 25.10.2.1
  • ignoring existing objects during import 25.7.15
  • import creation errors 25.7.15
  • loading nested column objects 11.1.3
  • NULL values 11.1.5
  • stream record format 11.1.1
  • variable record format 11.1.2
• object tables
  • loading 11.2
  • with a subtype
    • loading 11.2.1
• object type definitions
  • exporting 24.14.8
• object types supported by SQL*Loader 7.10.1
• offline locally-managed tablespaces
  • exporting 24.14.4
• OID
  • See: object identifiers
• online help
  • Export and Import 24.3.5
• opaque_format_spec 14.3, 15.1, 16.2
• operating systems
  • moving data to different systems using SQL*Loader 10.8
• OPTIMAL storage parameter
  • used with Export/Import 25.20.1
• optimizer statistics 25.24
• optimizing
  • direct path loads 12.5
  • SQL*Loader input file processing 9.9
• OPTIONALLY_ENCLOSED_BY parameter
  • SQL*Loader express mode 13.3.15
• OPTIONALLY ENCLOSED BY clause
  • SQL*Loader 10.11.2.2
• OPTIONS parameter
  • for parallel loads 9.17.3
  • SQL*Loader utility 9.2.1
• ora-39095: dump file space has been exhausted 2.4.33
• ORA-39181: Only Partial Data Exported Due to Fine Grain Access Control 1.4
• ORA-39357: Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database 1.3.1
• ORACLE_DATAPUMP access driver
  • effect of SQL ENCRYPT clause on 16.2.6
  • reserved words 16, 16.8
• ORACLE_HIVE
  • access parameters 17.3
• ORACLE_LOADER access driver
  • reserved words 15, 15.8
• Oracle Advanced Queuing
  • See: Advanced Queuing
• Oracle Automatic Storage Management (ASM)
  • Data Pump and 1.8.3.3
• Oracle Data Pump
  • direct path loads
    • restrictions 1.2.2
  • master table 1.5.2
  • tuning performance 5.2
• Oracle Data Pump API 6
  • client interface 6.1
  • job states 6.1.1
  • monitoring job progress 1.7
• ORC files 17.4.5
• overflow handling 17.4.8
• OWNER parameter
  • Export utility 24.5.17

---

P

• packages
  • creating 19.8.2
• padding of literal strings
  • SQL*Loader 10.5.2
• parallel loads 12.9
  • restrictions on direct path 12.9.4
  • when using PREPROCESSOR clause 15.2.7.1
• PARALLEL parameter
  • Data Pump Export utility
    • command-line interface 2.4.33
    • interactive-command mode 2.5.8
  • Data Pump Import utility
    • command-line mode 3.4.27
    • interactive-command mode 3.5.6
  • SQL*Loader command line 8.2.24
• parameter files
  • Export 24.5.18
  • Export and Import
    • comments in 24.3.3, 25.5.2
    • maximum size 24.3.3, 25.5.2
  • Import 25.7.19
  • SQL*Loader 8.2.25
• PARFILE parameter
  • Data Pump Export utility 2.4.34
  • Data Pump Import utility 3.4.28
  • Export command line 24.5.18
  • Import command line 25.7.19
  • SQL*Loader express mode 13.3.16
• Parquet files 17.4.5
• parsing HDFS files 17.4.9
• PARTITION_MEMORY parameter
  • SQL*Loader utility 8.2.26
• PARTITION_OPTIONS parameter
  • Data Pump Import utility 3.4.29
• partitioned loads
  • concurrent conventional path loads 12.8.4
  • SQL*Loader 12.8.4
• partitioned object support in SQL*Loader 7.11
• partitioned tables
  • export consistency and 24.5.3
  • exporting 24.4.1
  • importing 25.8.1, 25.11.1
  • loading 12.3.2
• partitioning a database migration 24.17, 25.25
  • advantages of 24.17, 25.25
  • disadvantages of 24.17, 25.25
  • procedure during export 24.17.3, 25.25.3
• partition-level Export 24.4.1
  • example session 24.6.4
• partition-level Import 25.11
  • specifying 24.5.26
• pattern matching
  • table names during import 25.7.30
• performance
  • improving when using integrity constraints 12.8.4
  • optimizing for direct path loads 12.5
  • optimizing reading of SQL*Loader data files 9.9
  • tuning original Import 25.26
• PIECED parameter
  • SQL*Loader 12.4.7.1
• POSITION parameter
  • using with data containing tabs 10.2.1
  • with multiple SQL*Loader INTO TABLE clauses 9.19.2.1, 10.2, 10.2.2
• predetermined size fields
  • SQL*Loader 10.11.2.1
• predetermined size LOBs 11.4.2.2.2
• preprocessing data for external tables 15.2.7
  • effects of parallel processing 15.2.7.1
• prerequisites
  • SQL*Loader 12.1
• PRESERVE parameter 9.16.2
• preserving
  • whitespace 10.12
• PRIMARY KEY constraints
  • effect on direct path load 12.9.8
• primary key OIDs
  • example 11.2
• primary key REF columns 11.3.3
• privileges
  • EXEMPT ACCESS POLICY
    • effect on direct path export 24.10.1
  • required for Export and Import 24.2.1, 25.2.1
  • required for SQL*Loader 12.1
• problem
  • fault diagnosability infrastructure 19.2
• problem key
  • fault diagnosability infrastructure 19.2
• PURGE command, ADRCI utility 19.9.6

---

Q

• QUERY parameter
  • Data Pump Export utility 2.4.35
  • Data Pump Import utility 3.4.30
  • Export utility 24.5.19
    • restrictions 24.5.19.1
• QUIT command, ADRCI utility 19.9.7
• quotation marks
  • escape characters and 9.3.3.2
  • file names and 9.3.3.1
  • SQL strings and 9.3.2
  • table names and 2.4.43, 3.4.46, 24.5.26.1, 25.7.30.1
  • usage in Data Pump Export 2.4.1
  • usage in Data Pump Import 3.4
  • use with database object names 9.3.1

---

R

• RC files 17.4.5
• read-consistent export 24.5.3
• read-only tablespaces
  • Import 25.21
• READSIZE parameter
  • SQL*Loader command line 8.2.27
    • effect on LOBs 8.2.27
    • maximum size 8.2.27
• RECNUM parameter
  • use with SQL*Loader SKIP parameter 10.15.4
• RECORDLENGTH parameter
  • Export utility 24.5.20
  • Import utility 25.7.20
• records
  • consolidating into a single logical record
    • SQL*Loader 9.16
  • discarded by SQL*Loader 7.7, 9.11
  • distinguishing different formats for SQL*Loader 9.19.2
  • extracting multiple logical records using SQL*Loader 9.19
  • fixed format 7.4.1
  • missing data columns during load 9.17.6
  • rejected by SQL*Loader 7.7, 7.7.1.1, 7.7.1.2, 9.10
  • setting column to record number with SQL*Loader 10.15.4
  • specifying how to load 8.2.20, 13.3.13
  • specifying length for export 24.5.20
  • specifying length for import 25.7.20
  • stream record format 7.4.3
• recovery
  • direct path load
    • SQL*Loader 12.4.6
  • replacing rows 9.17.2.2
• redo log file
  • LogMiner utility
    • versions supported 22.14.3
• redo log files
  • analyzing 22
  • requirements for LogMiner utility 22.2.1.2
  • specifying for the LogMiner utility 22.4.2
• redo logs
  • direct path load 12.4.6.1
  • instance and media recovery
    • SQL*Loader 12.4.6.1
  • minimizing use during direct path loads 12.5.4
  • saving space
    • direct path load 12.5.4.2
• REF columns 11.3
  • loading 11.3
  • primary key 11.3.3
  • system-generated 11.3.2
• REF data
  • importing 25.16.4
• referential integrity constraints
  • disabling for import 25.3.2
  • SQL*Loader 12.8
• refresh error
  • snapshots
    • Import 25.18.1
• rejected records
  • SQL*Loader 7.7, 9.10
• reject files
  • specifying for SQL*Loader 9.10
• relative field positioning
  • where a field starts and SQL*Loader 10.11.3
  • with multiple SQL*Loader INTO TABLE clauses 9.19.1.1
• REMAP_DATAFILE parameter
  • Data Pump Import utility 3.4.32
• REMAP_DATA parameter
  • Data Pump Export utility 2.4.36
  • Data Pump Import utility 3.4.31
• REMAP_SCHEMA parameter
  • Data Pump Import utility 3.4.34
• REMAP_TABLE parameter
  • Data Pump Import utility 3.4.35
• REMAP_TABLESPACE parameter
  • Data Pump Import utility 3.4.36
• remote operation
  • Export/Import 24.11.2, 25.13
• REPLACE table
  • replacing a table using SQL*Loader 9.17.2.2.2
• reserved words
  • external tables 15.7, 16.7
  • ORACLE_DATAPUMP access driver 16, 16.8
  • ORACLE_LOADER access driver 15, 15.8
  • SQL*Loader 7.3
• resource consumption
  • controlling in Data Pump Export utility 5.2.1
  • controlling in Data Pump Import utility 5.2.1
• resource errors
  • Import 25.10.2.3
• RESOURCE role 25.2.2.1
• restrictions
  • importing into another user’s schema 25.2.2.3
  • table names in Export parameter file 24.5.26.1
  • table names in Import parameter file 2.4.43, 3.4.46, 25.7.30.1
• RESUMABLE_NAME parameter
  • Export utility 24.5.22
  • Import utility 25.7.22
  • SQL*Loader command line 8.2.29
• RESUMABLE_TIMEOUT parameter
  • Export utility 24.5.23
  • Import utility 25.7.23
  • SQL*Loader command line 8.2.30
• RESUMABLE parameter
  • Export utility 24.5.21
  • Import utility 25.7.21
  • SQL*Loader command line 8.2.28
• resumable space allocation
  • enabling and disabling 8.2.28, 24.5.21, 25.7.21
• retrieving object metadata
  • using Metadata API 23.3
• REUSE_DATAFILES parameter
  • Data Pump Import utility 3.4.45
• REUSE_DUMPFILES parameter
  • Data Pump Export utility 2.4.37
• roles
  • DATAPUMP_EXP_FULL_DATABASE 1.4
  • DATAPUMP_IMP_FULL_DATABASE 1.4
  • EXP_FULL_DATABASE 24.2.1
  • IMP_FULL_DATABASE 25.2.1
  • RESOURCE 25.2.2.1
• rollback segments
  • effects of CONSISTENT Export parameter 24.5.3
• row errors
  • Import 25.10.1.1
• row format description 17.4.5
• row formats 17.4.9
• ROWID columns
  • loading with SQL*Loader 12.1.1
• rows
  • choosing which to load using SQL*Loader 9.17.4
  • exporting 24.5.24
  • specifying number to insert before save
    • SQL*Loader 12.4.5.1
  • updates to existing rows with SQL*Loader 9.17.2.2.3
• ROWS parameter
  • Export utility 24.5.24
  • performance issues
    • SQL*Loader 12.5.3
  • SQL*Loader command line 8.2.31
  • using to specify when data saves occur 12.4.5.1
• RUN command, ADRCI utility 19.9.8

---

S

• SAMPLE parameter
  • Data Pump Export utility 2.4.38
• schema mode export
  • Data Pump Export utility 2.2.2.2
• schemas
  • specifying for Export 24.5.26
• SCHEMAS parameter
  • Data Pump Export utility 2.4.39
  • Data Pump Import utility 3.4.37
• scientific notation for FLOAT EXTERNAL 10.4.2.5
• script files
  • running before Export and Import 24.2.1, 25.2.1
• SDFs
  • See: secondary datafiles
• secondary datafiles 7.5, 11.6.2
• SecureFiles
  • encryption during Data Pump export 2.4.12
• SecureFiles LOB
  • export considerations 1.10
• security considerations
  • direct path export 24.10.1
• segments
  • temporary
    • FILE parameter in SQL*Loader 12.9.6.1
• SELECT command, ADRCI utility 19.9.9
  • functions 19.9.9
• sequence files 17.4.5
• sequence numb 10.15.6
• sequence numbers
  • cached 24.14.1
  • exporting 24.14.1
  • for multiple tables and SQL*Loader 10.15.7
  • generated, not read and SQL*Loader 10.3
  • generated by SQL*Loader SEQUENCE clause 10.15.6
• SerDe parsing 17.4.9
• SERVICE_NAME parameter
  • Data Pump Export utility 2.4.40
  • Data Pump Import utility 3.4.38
• SET BASE command, ADRCI utility 19.9.10
• SET BROWSER command, ADRCI utility 19.9.11
• SET CONTROL command, ADRCI utility 19.9.12
• SET ECHO command, ADRCI utility 19.9.13
• SET EDITOR command, ADRCI utility 19.9.14
• SET HOMEPATH command, ADRCI utility 19.9.15
• SET TERMOUT command, ADRCI utility 19.9.16
• short records with missing data
  • SQL*Loader 9.17.6
• SHOW ALERT command, ADRCI utility 19.9.17
• SHOW BASE command, ADRCI utility 19.9.18
• SHOW CONTROL command, ADRCI utility 19.9.19
• SHOW HM_RUN command, ADRCI utility 19.9.20
• SHOW HOMEPATH command, ADRCI utility 19.9.21
• SHOW HOMES command, ADRCI utility 19.9.22
• SHOW INCDIR command, ADRCI utility 19.9.23
• SHOW INCIDENT command, ADRCI utility 19.9.24
• SHOW LOG command, ADRCI utility 19.9.25
• SHOW parameter
  • Import utility 25.7.25
• SHOW PROBLEM command, ADRCI utility 19.9.26
• SHOW REPORT command, ADRCI utility 19.9.27
• SHOW TRACEFILE command, ADRCI utility 19.9.28
• SILENT parameter
  • SQL*Loader command line 13.3.17
  • SQL*Loader express mode 13.3.17
• single-byte character sets
  • Export and Import 24.12.3, 25.14.3
• SINGLEROW parameter 9.18.2
• single-table loads
  • continuing 9.15.5
• SKIP_INDEX_MAINTENANCE parameter
  • SQL*Loader command line 8.2.35
• SKIP_UNUSABLE_INDEXES parameter
  • Import utility 25.7.26
  • SQL*Loader command line 8.2.36
• SKIP_USABLE_INDEXES parameter
  • Data Pump Import utility 3.4.39
• SKIP parameter
  • effect on SQL*Loader RECNUM specification 10.15.4
  • SQL*Loader command line 8.2.34
• skipping unusable indexes 8.2.36
• SmartScan mode 17.4.2
• snapshot log
  • Import 25.18.1
• snapshots 25.18.2
  • importing 25.18
  • master table
    • Import 25.18.1
  • restoring dropped
    • Import 25.18.2.1
• SORTED INDEXES clause
  • direct path loads 9.18.1
  • SQL*Loader 12.5.2.1
• sorting
  • multiple-column indexes
    • SQL*Loader 12.5.2.3
  • optimum sort order
    • SQL*Loader 12.5.2.4
  • presorting in direct path load 12.5.2
  • SORTED INDEXES clause
    • SQL*Loader 12.5.2.1
• SOURCE_EDITION parameter
  • Data Pump Export utility 2.4.41
  • Data Pump Import utility 3.4.40
• source name 17.4.10
• SPOOL command, ADRCI utility 19.9.29
• SQL*Loader
  • appending rows to tables 9.17.2.2.1
  • auditing direct path loads 12.4.8
  • BAD command-line parameter 8.2.1
  • bad file 13.3.1
  • BADFILE parameter 9.10
  • bad files 8.2.1
  • bind arrays and performance 9.20.2
  • BINDSIZE command-line parameter 8.2.2, 9.20.3
  • choosing which rows to load 9.17.4
  • COLUMNARRAYROWS command-line parameter 8.2.3
  • command-line parameters 8.1
  • continuing single-table loads 9.15.5
  • CONTROL command-line parameter 8.2.4
  • control file 9.1
  • conventional path loads 7.9.1, 12.2
  • DATA command-line parameter 8.2.5, 13.3.4
  • data conversion 7.6
  • data definition language
    • syntax diagrams A
  • data type specifications 7.6
  • DATE_CACHE command-line parameter 8.2.6
  • DEGREE_OF_PARALLELISM command-line parameter 8.2.8
  • determining default schema 9.17.1.1
  • DIRECT command-line parameter 8.2.9
  • direct path method 7.9.2
    • auditing 12.4.8
    • using the date cache feature to improve performance 12.5.6
  • DISCARD command-line parameter 8.2.11
  • discarded records 7.7
  • DISCARDFILE parameter 9.11.1
  • DISCARDMAX parameter 9.11.1.1
  • DISCARDS parameter 9.11.1.1
  • DNFS_ENABLE command-line parameter 8.2.13
  • DNFS_READBUFFERS command-line parameter 8.2.14
  • errors caused by tabs 10.2.1
  • ERRORS command-line parameter 8.2.16
  • exclusive access 12.8.3
  • express mode 13
  • EXTERNAL_TABLE command-line parameter 8.2.17
  • external table loads 7.9.3
  • FILE command-line parameter 8.2.18
  • file names 9.3
  • globalization technology 9.14
  • index options 9.18
  • inserting rows into tables 9.17.2.1, 9.17.2.1.1
  • INTO TABLE statement 9.17
  • LOAD command-line parameter 8.2.20, 13.3.13
  • loading column objects 11.1
  • loading data across different platforms 10.8
  • loading data contained in the control file 10.15.1
  • loading object tables 11.2
  • load methods 12.1
  • LOG command-line parameter 8.2.21
  • log files 7.8
  • methods of loading data 7.9
  • multiple INTO TABLE statements 9.19
  • MULTITHREADING command-line parameter 8.2.22
  • NO_INDEX_ERRORS command-line parameter 8.2.23
  • object names 9.3
  • PARALLEL command-line parameter 8.2.24
  • parallel data loading 12.9, 12.9.3, 12.10
  • portable data types 10.4.2
  • READSIZE command-line parameter 8.2.27
    • maximum size 8.2.27
  • rejected records 7.7
  • replacing rows in tables 9.17.2.2.2
  • required privileges 12.1
  • RESUMABLE_NAME command-line parameter 8.2.29
  • RESUMABLE_TIMEOUT command-line parameter 8.2.30
  • RESUMABLE command-line parameter 8.2.28
  • ROWS command-line parameter 8.2.31
  • SILENT command-line parameter 13.3.17
  • SINGLEROW parameter 9.18.2
  • SKIP_UNUSABLE_INDEXES command-line parameter 8.2.36
  • SKIP command-line parameter 8.2.34
  • SORTED INDEXES during direct path loads 9.18.1
  • specifying columns 10.3
  • specifying data files 9.6
  • specifying field conditions 10.5
  • specifying fields 10.3
  • specifying load method 8.2.9
  • specifying more than one data file 9.6.2
  • STREAMSIZE command-line parameter 8.2.37
  • suppressing messages 13.3.17
  • TRIM command-line parameter 8.2.38
  • USERID command-line parameter 8.2.39, 13.3.22
• SQL*Loader control files
  • guidelines when creating 7.3
• SQL*Loader data types
  • nonportable 10.4.1
• SQL*Loader express mode 13, 13.2
  • BAD parameter 13.3.1
  • byte-order handling 13.2.1.1
  • CHARACTERSET parameter 13.3.2
  • CSV parameter 13.3.3
  • DATA parameter 13.3.4
  • DATE_FORMAT parameter 13.3.5
  • default values 13.2.1
  • DEGREE_OF_PARALLELISM parameter 13.3.6
  • DIRECT parameter 13.3.7
  • DNFS_ENABLE parameter 13.3.8
  • DNFS_READBUFFERS parameter 13.3.9
  • ENCLOSED_BY parameter 13.3.10
  • EXTERNAL_TABLE parameter 13.3.11
  • FIELD_NAMES parameter 13.3.12
  • LOAD parameter 13.3.13
  • NULLIF parameter 13.3.14
  • OPTIONALLY_ENCLOSED_BY parameter 13.3.15
  • PARFILE parameter 13.3.16
  • SILENT parameter 13.3.17
  • syntax diagrams 13.4
  • TABLE parameter 13.3.18
  • TERMINATED_BY parameter 13.3.19
  • TIMESTAMP_FORMAT parameter 13.3.20
  • TRIM parameter 13.3.21
  • USERID parameter 13.3.22
• SQL*Loader utility
  • PARTITION_MEMORY parameter 8.2.26
• SQLFILE parameter
  • Data Pump Import utility 3.4.41
• SQL operators
  • applying to fields 10.14
• SQL strings
  • applying SQL operators to fields 10.14
  • quotation marks and 9.3.2
• START_JOB parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.9
  • Data Pump Import utility
    • interactive-command mode 3.5.7
• starting
  • LogMiner utility 22.5
• statistics
  • analyzer 25.24
  • optimizer 25.24
  • specifying for Import 25.7.27
• STATISTICS parameter
  • Import utility 25.7.27
• STATUS parameter
  • Data Pump Export utility 2.4.42
    • interactive-command mode 2.5.10
  • Data Pump Import utility 3.4.42
    • interactive-command mode 3.5.8
• STOP_JOB parameter
  • Data Pump Export utility
    • interactive-command mode 2.5.11
  • Data Pump Import utility
    • interactive-command mode 3.5.9
• storage parameters
  • estimating export requirements 24.2.2
  • OPTIMAL parameter 25.20.1
  • overriding
    • Import 25.20.3
  • preallocating
    • direct path load 12.5.1
  • temporary for a direct path load 12.4.3.2
  • using with Export/Import 25.20
• stored functions
  • importing 25.16.7
    • effect of COMPILE parameter 25.16.7
• stored package 25.16.7
• stored packages
  • importing 25.16.7
• stored procedures
  • direct path load 12.8.2.6
  • importing 25.16.7
    • effect of COMPILE parameter 25.16.7
• stream buffer
  • specifying size for direct path 12.5.5
• stream record format 7.4.3
  • loading column objects in 11.1.1
• STREAMS_CONFIGURATION parameter
  • Data Pump Import utility 3.4.43
  • Import utility 25.7.28
• STREAMS_INSTANTIATION parameter
  • Import utility 25.7.29
• Streams environment in Data Pump
  • setting buffer cache size 5.3.1
• STREAMSIZE parameter
  • SQL*Loader command line 8.2.37
• string comparisons
  • SQL*Loader 10.5.2
• struct overflows 17.4.8
• subpartitioned tables
  • loading 12.3.2
• subtypes
  • loading multiple 9.19.3
• supplemental logging 22.10
  • See also: LogMiner utility
  • LogMiner utility 22.10
    • database-level identification keys 22.10.1.2
    • log groups 22.10
    • table-level 22.10.3
    • table-level identification keys 22.10.3.1
    • table-level log groups 22.10.3.2
• synonyms
  • exporting 24.14.11
• syntax diagrams
  • Data Pump Export 2.7
  • Data Pump Import 3.7
  • SQL*Loader A
  • SQL*Loader express mode 13.4
• SYSDATE parameter
  • SQL*Loader 10.15.5
• system-generated OID REF columns 11.3.2
• system objects
  • importing 25.2.2.4
• system triggers
  • effect on import 25.4
  • testing 25.4

---

T

• TABLE_EXISTS_ACTION parameter
  • Data Pump Import utility 3.4.44
• table compression
  • specifying type in Data Pump jobs 3.4.49
• table-level Export 24.4.1
• table-level Import 25.11
• table-mode Export
  • Data Pump Export utility 2.2.2.3
  • specifying 24.5.26
• table-mode Import
  • examples 25.8.1
• table names
  • preserving case sensitivity 24.5.26.1
• TABLE parameter
  • SQL*Loader express mode 13.3.18
• tables
  • Advanced Queuing
    • exporting 24.14.10
    • importing 25.16.10
  • appending rows with SQL*Loader 9.17.2.2.1
  • defining before Import 25.3.1
  • definitions
    • creating before Import 25.3.1
  • exclusive access during direct path loads
    • SQL*Loader 12.8.3
  • external 14
  • importing 25.7.30
  • inserting rows using SQL*Loader 9.17.2.1, 9.17.2.1.1
  • insert triggers
    • direct path load in SQL*Loader 12.8.2
  • loading data into more than one table using SQL*Loader 9.19
  • loading object tables 11.2
  • maintaining consistency during Export 24.5.3
  • manually ordering for Import 25.3.3
  • master table
    • Import 25.18.1
  • name restrictions
    • Export 24.5.26.1
    • Import 2.4.43, 3.4.46, 25.7.30, 25.7.30.1
  • nested
    • exporting 24.14.9
    • importing 25.16.3
  • objects
    • order of import 25.1.1
  • partitioned 24.4.1
  • replacing rows using SQL*Loader 9.17.2.2.2
  • specifying for export 24.5.26
  • specifying table-mode Export 24.5.26
  • SQL*Loader method for individual tables 9.17.2
  • truncating
    • SQL*Loader 9.17.2.2.4
  • updating existing rows using SQL*Loader 9.17.2.2.3
• tablespace mode Export
  • Data Pump Export utility 2.2.2.4
• tablespaces
  • dropping during import 25.22
  • exporting a set of 24.15, 25.19
  • metadata
    • transporting 25.7.34
  • read-only
    • Import 25.21
  • reorganizing
    • Import 25.23
• TABLESPACES parameter
  • Data Pump Export utility 2.4.44
  • Data Pump Import utility 3.4.47
  • Export utility 24.5.27
  • Import utility 25.7.31
• TABLES parameter
  • Data Pump Export utility 2.4.43
  • Data Pump Import utility 3.4.46
  • Export utility 24.5.26
  • Import utility 25.7.30
• tabs
  • loading datafiles containing tabs 10.2.1
  • trimming 10.11
  • whitespace 10.11
• TARGET_EDITION parameter
  • Data Pump Import utility 3.4.48
• temporary segments 12.9.6.1
  • FILE parameter
    • SQL*Loader 12.9.6.1
• temporary storage in a direct path load 12.4.3.2
• TERMINATED_BY parameter
  • SQL*Loader express mode 13.3.19
• TERMINATED BY clause
  • with OPTIONALLY ENCLOSED BY 10.11.2.2
• terminated fields
  • specified with a delimiter 10.11.2.2
• text files 17.4.5
• text overflows 17.4.8
• TIMESTAMP_FORMAT parameter
  • SQL*Loader express mode 13.3.20
• timestamps
  • on Data Pump Export operations 2.4.29
  • on Data Pump Import operations 3.4.22
• TOID_NOVALIDATE parameter
  • Import utility 25.7.32
• TOUSER parameter
  • Import utility 25.7.33
• trace files
  • viewing with ADRCI 19.6
• trailing blanks
  • loading with delimiters 10.4.5.4
• TRAILING NULLCOLS parameter
  • SQL*Loader utility 9.1, 9.17.6.1
• trailing whitespace
  • trimming 10.11.5
• TRANSFORM parameter
  • Data Pump Import utility 3.4.49
• transparent data encryption
  • as handled by Data Pump Export 2.4.15
  • as handled by Data Pump Import 3.4.10
  • LogMiner support 22.6
• TRANSPORT_DATAFILES parameter
  • Data Pump Import utility 3.4.50
• TRANSPORT_FULL_CHECK parameter
  • Data Pump Export utility 2.4.45
  • Data Pump Import utility 3.4.51
• TRANSPORT_TABLESPACE parameter
  • Export utility 24.5.28
  • Import utility 25.7.34
• TRANSPORT_TABLESPACES parameter
  • Data Pump Export utility 2.4.46
  • Data Pump Import utility 3.4.52
• transportable option
  • used during full-mode export 2.2.2.1
  • used during full-mode import 3.2.2.2
  • used during table-mode export 2.4.43
• TRANSPORTABLE parameter
  • Data Pump Export utility 2.4.47
  • Data Pump Import utility 3.4.53
• transportable-tablespace mode Export
  • Data Pump Export utility 2.2.2.5
• transportable tablespaces 24.15, 25.19
• triggers
  • database insert 12.8.2
  • logon
    • effect in SQL*Loader 9.17.1.1
  • permanently disabled 12.8.3
  • replacing with integrity constraints 12.8.2.1
  • system
    • testing 25.4
  • update
    • SQL*Loader 12.8.2.4
• TRIGGERS parameter
  • Export utility 24.5.29
• trimming
  • summary 10.11
  • trailing whitespace
    • SQL*Loader 10.11.5
• TRIM parameter
  • SQL*Loader command line 8.2.38
  • SQL*Loader express mode 13.3.21
• TTS_FULL_CHECK parameter
  • Export utility 24.5.30
• TTS_OWNERS parameter
  • Import utility 25.7.35

---

U

• unified auditing
  • during SQL*Loader operations 12.4.8
• union overflows 17.4.8
• UNIQUE KEY constraints
  • effect on direct path load 12.9.8
• unique values
  • generating with SQL*Loader 10.15.6
• unloading entire database
  • Data Pump Export utility 2.2.2.1
• UNRECOVERABLE clause
  • SQL*Loader 12.5.4.2
• unsorted data
  • direct path load
    • SQL*Loader 12.5.2.2
• USER_SEGMENTS view
  • Export and 24.2.2
• user-defined constructors 11.1.6
  • loading column objects with 11.1.6
• USERID parameter
  • Export utility 24.5.31
  • Import utility 25.7.36
  • SQL*Loader command line 8.2.39, 13.3.22
  • SQL*Loader express mode 13.3.22
• user mode export
  • specifying 24.5.17

---

V

• V$DATABASE view 22.11
• V$LOGMNR_CONTENTS view 22.6.1
  • formatting information returned to 22.7
  • impact of querying 22.6.1
  • information within 22.6
  • limiting information returned to 22.7
  • LogMiner utility 22.2.2
  • requirements for querying 22.5, 22.6.1
• V$LOGMNR_LOGS view 22.4.2
  • querying 22.11.1
• V$SESSION_LONGOPS view
  • monitoring Data Pump jobs with 1.7
• VARCHAR2 data type
  • SQL*Loader 10.4.3
• variable-length records
  • external tables 15.2.2
• variable records 7.4.2
  • format 11.1.2
• VARRAY columns
  • memory issues when loading 11.8.1
• VERSION parameter
  • Data Pump Export utility 2.4.48
  • Data Pump Import utility 3.4.54
• viewing
  • trace files with ADRCI 19.6
• views
  • exporting as tables 2.4.49
• VIEWS_AS_TABLES
  • Data Pump Export parameter 2.4.49
• VIEWS_AS_TABLES (Network Import)
  • Data Pump Import parameter 3.4.55
• VIEWS_AS_TABLES (Non-Network Import)
  • Data Pump Import parameter 3.4.56
• VIEWS_AS_TABLES parameter
  • Data Pump Export utility 2.4.49
• VIEWS_AS_TABLES parameter (Network Import)
  • Data Pump Import utility 3.4.55
• VIEWS_AS_TABLES parameter (Non_Network Import)
  • Data Pump Import utility 3.4.56
• VOLSIZE parameter
  • Export utility 24.5.32
  • Import utility 25.7.37

---

W

• warning messages
  • Export 24.7.2
  • Import 24.7.2
• WHEN clause
  • SQL*Loader 9.17.4, 10.5
  • SQL*Loader discards resulting from 9.11.3
• whitespace
  • included in a field 10.11.4
  • leading 10.11.1
  • preserving 10.12
  • terminating a field 10.11.4.1
  • trimming 10.11

---

X

• XML columns
  • loading with SQL*Loader 11.4
  • treatment by SQL*Loader 11.4
• XMLTYPE clause
  • in SQL*Loader control file 9.4
• XML type tables
  • identifying in SQL*Loader 9.4