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 [1]
    • Data Pump Import utility [1]
  • ACCESS_METHOD parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • access privileges
    • Export and Import [1]
  • ADD_FILE parameter
    • Data Pump Export utility
      • interactive-command mode [1]
  • ADR
    • See: automatic diagnostic repository
  • ADR base
    • in ADRCI utility [1]
  • ADRCI
    • troubleshooting [1]
  • ADRCI utility
  • ADR home
    • in ADRCI utility [1]
  • Advanced Queuing
    • exporting advanced queue tables [1]
    • importing advanced queue tables [1]
  • aliases
    • directory
  • analyzer statistics [1]
  • analyzing redo log files [1]
  • ANYDATA type
    • using SQL strings to load [1]
  • APPEND parameter
    • SQL*Loader utility [1]
  • append to table
    • SQL*Loader [1]
  • archived LOBs
    • restrictions on export [1]
  • archive logging
    • disabling in Data Pump jobs [1]
    • enabling in Data Pump jobs [1]
  • archiving
    • disabling
      • effect on direct path loads [1]
  • arrays
    • committing after insert [1]
  • atomic null [1]
  • attaching to an existing job
    • Data Pump Export utility [1]
  • ATTACH parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • attributes
  • attribute-value constructors
    • overriding [1]
  • auditing Data Pump jobs
    • unified auditing
      • Data Pump [1]
  • auditing direct path loads
    • when using SQL*Loader [1]
  • automatic diagnostic repository [1]

B

  • backslash escape character [1]
  • backups
    • restoring dropped snapshots
  • BADFILE parameter
    • SQL*Loader utility [1]
  • bad files
    • specifying for SQL*Loader [1]
  • BAD parameter
    • SQL*Loader command line [1]
    • SQL*Loader express mode [1]
  • BEGINDATA parameter
    • SQL*Loader control file [1]
  • BFILEs
    • in original Export [1]
    • in original Import [1]
    • loading with SQL*Loader [1]
  • big-endian data
    • external tables [1]
  • bind arrays
    • determining size of for SQL*Loader [1]
    • minimizing SQL*Loader memory requirements [1]
    • minimum requirements [1]
    • size with multiple SQL*Loader INTO TABLE statements [1]
    • specifying maximum size [1]
    • specifying number of rows [1]
    • SQL*Loader performance implications [1]
  • BINDSIZE parameter
    • SQL*Loader command line [1] , [2]
  • blanks
    • loading fields consisting of blanks [1]
    • SQL*Loader BLANKS parameter for field comparison [1]
    • trailing [1]
    • trimming
    • whitespace [1]
  • BLANKS parameter
    • SQL*Loader utility [1]
  • BLOBs
    • loading with SQL*Loader [1]
  • buffer cache size
    • and Data Pump operations involving Streams [1]
  • BUFFER parameter
    • Export utility [1]
    • Import utility [1]
  • buffers
    • calculating for export [1]
    • specifying with SQL*Loader BINDSIZE parameter [1]
  • byte order
    • big-endian [1]
    • little-endian [1]
    • specifying in SQL*Loader control file [1]
  • BYTEORDERMARK parameter
    • SQL*Loader utility [1]
  • byte order marks
    • precedence
      • for first primary datafile [1]
      • for LOBFILEs and SDFs [1]
    • suppressing checks for [1]
  • BYTEORDER parameter
    • SQL*Loader utility [1]

C

  • cached sequence numbers
  • catalog.sql script
    • preparing database for Export and Import [1]
  • catexp.sql script
    • preparing database for Export and Import [1]
  • CDBs
    • Oracle Data Pump support [1]
    • using Data Pump to move data into [1]
  • changing a database ID [1]
  • changing a database name [1]
  • character fields
    • delimiters and SQL*Loader [1] , [2]
    • determining length for SQL*Loader [1]
    • SQL*Loader data types [1]
  • character-length semantics [1]
  • CHARACTERSET parameter
    • SQL*Loader express mode [1]
    • SQL*Loader utility [1] , [2]
  • character sets
    • conversion
      • during Export and Import [1]
    • eight-bit to seven-bit conversions
    • identifying for external tables [1]
    • multibyte
      • Export/Import [1]
      • SQL*Loader [1]
    • single-byte
    • SQL*Loader control file [1]
    • SQL*Loader conversion between [1]
    • Unicode [1]
  • character strings
    • external tables
      • specifying bytes or characters [1]
    • SQL*Loader [1]
  • CHAR data type
    • delimited form and SQL*Loader [1]
  • check constraints
    • overriding disabling of [1]
  • CLOBs
    • loading with SQL*Loader [1]
  • CLUSTER parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • collections
  • collection types supported by SQL*Loader [1]
  • column array rows
    • specifying number of [1]
  • COLUMNARRAYROWS parameter
    • SQL*Loader command line [1]
  • column objects
    • loading
      • with user-defined constructors [1]
  • columns
    • exporting LONG data types [1]
    • loading REF columns [1]
    • naming
      • SQL*Loader [1]
    • objects
      • loading nested column objects [1]
      • stream record format [1]
      • variable record format [1]
    • reordering before Import [1]
    • setting to a constant value with SQL*Loader [1]
    • setting to an expression value with SQL*Loader [1]
    • setting to a unique sequence number with SQL*Loader [1]
    • setting to null with SQL*Loader [1]
    • setting to the current date with SQL*Loader [1]
    • setting to the datafile record number with SQL*Loader [1]
    • specifying
      • SQL*Loader [1]
    • specifying as PIECED
      • SQL*Loader [1]
    • using SQL*Loader [1]
  • comments
    • in Export and Import parameter files [1]
    • with external tables [1] , [2]
  • COMMIT parameter
    • Import utility [1]
  • COMPILE parameter
    • Import utility [1]
  • completion messages
  • compression
    • specifying algorithm in Data Pump jobs [1]
    • specifying for tables in Data Pump jobs [1]
    • specifying level for external tables [1]
  • COMPRESSION_ALGORITHM parameter
    • Data Pump Export utility [1]
  • compression algorithms
    • specifying in Data Pump jobs [1]
  • COMPRESSION parameter
    • Data Pump Export utility [1]
  • COMPRESS parameter
    • Export utility [1]
  • CONCATENATE parameter
    • SQL*Loader utility [1]
  • concurrent conventional path loads [1]
  • configuration
    • of LogMiner utility [1]
  • CONSISTENT parameter
    • Export utility
      • nested tables and [1]
      • partitioned table and [1]
  • consolidating
  • CONSTANT parameter
    • SQL*Loader [1]
  • constraints
    • automatic integrity and SQL*Loader [1]
    • direct path load [1]
    • disabling referential constraints [1]
    • enabling
      • after a parallel direct path load [1]
    • enforced on a direct load [1]
    • failed
    • load method [1]
  • CONSTRAINTS parameter
    • Export utility [1]
    • Import utility [1]
  • constructors
    • attribute-value
      • overriding [1]
    • user-defined
      • loading column objects with [1]
  • CONTENT parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • CONTINUE_CLIENT parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility
      • interactive-command mode [1]
  • CONTINUEIF parameter
    • SQL*Loader utility [1]
  • control files
    • character sets [1]
    • data definition language syntax [1]
    • specifying data [1]
    • specifying SQL*Loader discard file [1]
    • SQL*Loader [1]
  • CONTROL parameter
    • SQL*Loader command line [1]
  • conventional path Export
    • compared to direct path [1]
  • conventional path loads
    • behavior when discontinued [1]
    • compared to direct path loads [1]
    • concurrent [1]
    • of a single partition [1]
    • SQL*Loader bind array [1]
    • when to use [1]
  • conversion of character sets
    • during Export/Import [1]
    • effect of character set sorting on [1]
  • conversion of data
    • during direct path loads [1]
  • conversion of input characters [1]
  • CREATE REPORT command, ADRCI utility [1]
  • CREATE SESSION privilege
  • creating
    • incident package [1]
    • tables
      • manually, before import [1]
  • CSV parameter
    • SQL*Loader express mode [1]

D

  • data
    • conversion
      • direct path load [1]
    • delimiter marks in data and SQL*Loader [1]
    • distinguishing different input formats for SQL*Loader [1]
    • distinguishing different input row object subtypes [1] , [2]
    • exporting [1]
    • generating unique values with SQL*Loader [1]
    • including in control files [1]
    • loading data contained in the SQL*Loader control file [1]
    • loading in sections
      • SQL*Loader [1]
    • loading into more than one table
      • SQL*Loader [1]
    • maximum length of delimited data for SQL*Loader [1]
    • moving between operating systems using SQL*Loader [1]
    • recovery
      • SQL*Loader direct path load [1]
    • saving in a direct path load [1]
    • saving rows
      • SQL*Loader [1]
    • unsorted
      • SQL*Loader [1]
    • values optimized for SQL*Loader performance [1]
  • DATA_OPTIONS parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • database ID (DBID)
  • database identifier
  • database migration
    • partitioning of [1]
  • database name (DBNAME)
  • database objects
    • exporting LONG columns [1]
  • databases
    • changing the database ID [1]
    • changing the name [1]
    • exporting entire [1]
    • full import [1]
    • privileges for exporting and importing [1] , [2]
    • reusing existing datafiles
  • data fields
    • specifying the SQL*Loader data type [1]
  • datafiles
    • preventing overwrite during import [1]
    • reusing during import [1]
    • specifying [1] , [2]
    • specifying format for SQL*Loader [1]
  • data files
    • specifying buffering for SQL*Loader [1]
    • specifying for SQL*Loader [1]
  • DATAFILES parameter
    • Import utility [1]
  • DATA parameter
    • SQL*Loader command line [1] , [2]
    • SQL*Loader express mode [1]
  • DATAPUMP_EXP_FULL_DATABASE role [1]
  • DATAPUMP_IMP_FULL_DATABASE role [1]
  • Data Pump Export utility
    • ABORT_STEP parameter [1]
    • ACCESS_METHOD parameter [1]
    • adding additional dump files [1]
    • ATTACH parameter [1]
    • CLUSTER parameter [1]
    • command-line mode [1] , [2]
    • COMPRESSION_ALGORITHM parameter [1]
    • COMPRESSION parameter [1]
    • CONTENT parameter [1]
    • controlling resource consumption [1]
    • DATA_OPTIONS parameter [1]
    • DIRECTORY parameter [1]
    • DUMPFILE parameter [1]
    • dump file set [1]
    • ENCRYPTION_ALGORITHM parameter [1]
    • ENCRYPTION_MODE parameter [1]
    • ENCRYPTION_PASSWORD parameter [1]
    • ENCRYPTION_PWD_PROMPT parameter [1]
    • encryption of SecureFiles [1]
    • ENCRYPTION parameter [1]
    • ESTIMATE_ONLY parameter [1]
    • ESTIMATE parameter [1]
    • EXCLUDE parameter [1]
    • excluding objects [1]
    • export modes [1]
    • FILESIZE command
      • interactive-command mode [1]
    • FILESIZE parameter [1]
    • filtering data that is exported
      • using EXCLUDE parameter [1]
      • using INCLUDE parameter [1]
    • FLASHBACK_SCN parameter [1]
    • FLASHBACK_TIME parameter [1]
    • FULL parameter [1]
    • HELP parameter
      • interactive-command mode [1]
    • INCLUDE parameter [1]
    • interactive-command mode
      • ADD_FILE parameter [1]
      • CONTINUE_CLIENT parameter [1]
      • EXIT_CLIENT parameter [1]
      • FILESIZE [1]
      • HELP parameter [1]
      • KILL_JOB parameter [1]
      • PARALLEL parameter [1]
      • START_JOB parameter [1]
      • STATUS parameter [1] , [2]
      • STOP_JOB parameter [1] , [2]
    • interfaces [1]
    • invoking
    • JOB_NAME parameter [1]
    • job names
      • specifying [1]
    • KEEP_MASTER parameter [1]
    • LOGFILE parameter [1]
    • LOGTIME parameter [1]
    • METRICS parameter [1]
    • NETWORK_LINK parameter [1]
    • NOLOGFILE parameter [1]
    • PARALLEL parameter
      • command-line mode [1]
      • interactive-command mode [1]
    • PARFILE parameter [1]
    • QUERY parameter [1]
    • REMAP_DATA parameter [1]
    • REUSE_DUMPFILES parameter [1]
    • SAMPLE parameter [1]
    • SCHEMAS parameter [1]
    • SecureFiles LOB considerations [1]
    • SERVICE_NAME parameter [1]
    • SOURCE_EDITION parameter [1]
    • specifying a job name [1]
    • STATUS parameter [1]
    • syntax diagrams [1]
    • TABLESPACES parameter [1]
    • TABLES parameter [1]
    • transparent data encryption [1]
    • TRANSPORT_FULL_CHECK parameter [1]
    • TRANSPORT_TABLESPACES parameter [1]
    • TRANSPORTABLE parameter [1]
    • versioning [1]
    • VERSION parameter [1]
    • VIEWS_AS_TABLES parameter [1]
  • Data Pump Import utility
    • ABORT_STEP parameter [1]
    • ACCESS_METHOD parameter [1]
    • attaching to an existing job [1]
    • ATTACH parameter [1]
    • changing name of source datafile [1]
    • CLUSTER parameter [1]
    • CONTENT parameter [1]
    • controlling resource consumption [1]
    • DATA_OPTIONS parameter [1]
    • DIRECTORY parameter [1]
    • DUMPFILE parameter [1]
    • ENCRYPTION_PASSWORD parameter [1]
    • ENCRYPTION_PWD_PROMPT parameter [1]
    • ESTIMATE parameter [1]
    • estimating size of job [1]
    • EXCLUDE parameter [1]
    • filtering data that is imported
      • using EXCLUDE parameter [1]
      • using INCLUDE parameter [1]
    • FLASHBACK_SCN parameter [1]
    • FLASHBACK_TIME parameter [1]
    • full import mode [1]
    • FULL parameter [1]
    • HELP parameter
      • command-line mode [1]
      • interactive-command mode [1]
    • INCLUDE parameter [1]
    • interactive-command mode
      • CONTINUE_CLIENT parameter [1]
      • EXIT_CLIENT parameter [1]
      • HELP parameter [1]
      • KILL_JOB parameter [1]
      • PARALLEL parameter [1]
      • START_JOB parameter [1]
      • STATUS [1]
      • STOP_JOB parameter [1]
    • interfaces [1]
    • JOB_NAME parameter [1]
    • KEEP_MASTER parameter [1]
    • LOGFILE parameter [1]
    • LOGTIME parameter [1]
    • MASTER_ONLY parameter [1]
    • METRICS parameter [1]
    • NETWORK_LINK parameter [1]
    • NOLOGFILE parameter [1]
    • PARALLEL parameter
      • command-line mode [1]
    • PARFILE parameter [1]
    • PARTITION_OPTIONS parameter [1]
    • QUERY parameter [1]
    • REMAP_DATAFILE parameter [1]
    • REMAP_DATA parameter [1]
    • REMAP_SCHEMA parameter [1]
    • REMAP_TABLE parameter [1]
    • REMAP_TABLESPACE parameter [1]
    • REUSE_DATAFILES parameter [1]
    • schema mode [1]
    • SCHEMAS parameter [1]
    • SERVICE_NAME parameter [1]
    • SKIP_UNUSABLE_INDEXES parameter [1]
    • SOURCE_EDITION parameter [1]
    • specifying a job name [1]
    • specifying dump file set to import [1]
    • SQLFILE parameter [1]
    • STATUS parameter [1]
    • STREAMS_CONFIGURATION parameter [1]
    • syntax diagrams [1]
    • TABLE_EXISTS_ACTION parameter [1]
    • table mode [1]
    • tablespace mode [1]
    • TABLESPACES parameter [1]
    • TABLES parameter [1]
    • TARGET_EDITION parameter [1]
    • TRANSFORM parameter [1]
    • transparent data encryption [1]
    • TRANSPORT_DATAFILES parameter [1]
    • TRANSPORT_FULL_CHECK parameter [1]
    • TRANSPORT_TABLESPACES parameter [1]
    • TRANSPORTABLE parameter [1]
    • transportable tablespace mode [1]
    • versioning [1]
    • VERSION parameter [1]
    • VIEWS_AS_TABLES parameter (Network Import) [1]
    • VIEWS_AS_TABLES parameter (Non-Network Import) [1]
  • Data Pump legacy mode [1]
  • data types
    • BFILEs
      • in original Export [1]
      • in original Import [1]
      • loading with SQL*Loader [1]
    • BLOBs
      • loading with SQL*Loader [1]
    • CLOBs
      • loading with SQL*Loader [1]
    • converting SQL*Loader [1]
    • describing for external table fields [1]
    • determining character field lengths for SQL*Loader [1]
    • determining DATE length [1]
    • identifying for external tables [1]
    • native
      • conflicting length specifications in SQL*Loader [1]
    • NCLOBs
      • loading with SQL*Loader [1]
    • nonscalar [1]
    • specifying in SQL*Loader [1]
    • supported by the LogMiner utility [1]
    • types used by SQL*Loader [1]
    • unsupported by LogMiner utility [1]
  • DATE_CACHE parameter
    • SQL*Loader utility [1]
  • DATE_FORMAT parameter
    • SQL*Loader express mode [1]
  • date cache feature
    • DATE_CACHE parameter [1]
    • external tables [1]
    • SQL*Loader [1]
  • DATE data type
    • delimited form and SQL*Loader [1]
    • determining length [1]
    • mask
      • SQL*Loader [1]
  • DBID (database identifier)
  • DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure
    • LogMiner utility and [1]
  • DBMS_LOGMNR_D.BUILD PL/SQL procedure
    • LogMiner utility and [1]
  • DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure
    • LogMiner utility and [1]
  • DBMS_LOGMNR_D PL/SQL procedure
    • LogMiner utility and [1]
  • DBMS_LOGMNR.COLUMN_PRESENT function [1]
  • DBMS_LOGMNR.MINE_VALUE function
    • null values and [1]
  • DBMS_LOGMNR.START_LOGMNR PL/SQL procedure
    • calling multiple times [1]
    • COMMITTED_DATA_ONLY option [1]
    • ENDTIME parameter [1] , [2]
    • LogMiner utility and [1]
    • options for [1]
    • PRINT_PRETTY_SQL option [1]
    • SKIP_CORRUPTION option [1]
    • STARTTIME parameter [1] , [2]
  • DBMS_LOGMNR PL/SQL procedure
    • LogMiner utility and [1]
  • DBMS_METADATA PL/SQL package [1]
  • DBNAME
  • DBNEWID utility
    • changing a database ID [1]
    • changing a database name [1]
    • effect on global database names [1]
    • restrictions [1]
    • syntax [1]
    • troubleshooting a database ID change [1]
  • DBVERIFY utility
    • output [1]
    • restrictions [1]
    • syntax [1]
    • validating a segment [1]
    • validating disk blocks [1]
  • DEFAULTIF parameter
    • SQL*Loader [1]
  • default schema
    • as determined by SQL*Loader [1]
  • DEGREE_OF_PARALLELISM parameter
    • SQL*Loader command line [1]
    • SQL*Loader express mode [1]
  • DELETE ANY TABLE privilege
    • SQL*Loader [1]
  • DELETE CASCADE
    • effect on loading nonempty tables [1]
    • SQL*Loader [1]
  • DELETE privilege
    • SQL*Loader [1]
  • delimited data
    • maximum length for SQL*Loader [1]
  • delimited fields
    • field length [1]
  • delimited LOBs [1]
  • delimiters
    • in external tables [1]
    • loading trailing blanks [1]
    • marks in data and SQL*Loader [1]
    • specifying for external tables [1]
    • specifying for SQL*Loader [1] , [2]
    • SQL*Loader enclosure [1]
    • SQL*Loader field specifications [1]
    • termination [1]
  • DESTROY parameter
    • Import utility [1]
  • dictionary
    • requirements for LogMiner utility [1]
  • dictionary version mismatch [1]
  • Direct NFS Client
    • controlling number of read buffers [1]
    • use during SQL*Loader operations [1]
    • using with external tables [1]
  • directory aliases
  • directory objects
    • using with Data Pump
      • effect of Oracle ASM [1]
  • DIRECTORY parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • DIRECT parameter
    • Export utility [1]
    • SQL*Loader command-line [1]
    • SQL*Loader express mode [1]
  • direct path Export
    • compared to conventional path [1]
    • effect of EXEMPT ACCESS POLICY privilege [1]
    • performance issues [1]
    • restrictions [1]
    • security considerations [1]
  • direct path load
    • advantages [1]
    • behavior when discontinued [1]
    • choosing sort order
      • SQL*Loader [1]
    • compared to conventional path load [1]
    • concurrent [1]
    • conditions for use [1]
    • data saves [1] , [2]
    • dropping indexes [1]
    • effect of disabling archiving [1]
    • effect of PRIMARY KEY constraints [1]
    • effect of UNIQUE KEY constraints [1]
    • field defaults [1]
    • improper sorting
      • SQL*Loader [1]
    • indexes [1]
    • instance recovery [1]
    • intersegment concurrency [1]
    • intrasegment concurrency [1]
    • location of data conversion [1]
    • media recovery [1]
    • optimizing on multiple-CPU systems [1]
    • partitioned load
      • SQL*Loader [1]
    • performance [1] , [2]
    • preallocating storage [1]
    • presorting data [1]
    • recovery [1]
    • ROWS command-line parameter [1]
    • setting up [1]
    • specifying [1]
    • specifying number of rows to be read [1]
    • SQL*Loader data loading method [1]
    • table insert triggers [1]
    • temporary segment storage requirements [1]
    • triggers [1]
    • using [1] , [2]
    • version requirements [1]
  • disabled unique indexes
    • loading tables with [1]
  • discarded SQL*Loader records
  • discard files
    • SQL*Loader
      • specifying a maximum [1]
  • DISCARD parameter
    • SQL*Loader command-line [1]
  • discontinued loads
    • continuing [1]
    • conventional path behavior [1]
    • direct path behavior [1]
  • DNFS_ENABLE parameter
    • SQL*Loader command-line [1]
    • SQL*Loader express mode [1]
  • DNFS_READBUFFERS parameter
    • SQL*Loader command-line [1]
    • SQL*Loader express mode [1]
  • dropped snapshots
  • DUMPFILE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • dump files
    • maximum size [1]

E

  • EBCDIC character set
  • ECHO command, ADRCI utility [1]
  • eight-bit character set support [1] , [2]
  • ENCLOSED_BY parameter
    • SQL*Loader express mode [1]
  • enclosed fields
    • whitespace [1]
  • enclosure delimiters
    • SQL*Loader [1]
  • encrypted columns
    • in external tables [1]
  • ENCRYPTION_ALGORITHM parameter
    • Data Pump Export utility [1]
  • ENCRYPTION_MODE parameter
    • Data Pump Export utility [1]
  • ENCRYPTION_PASSWORD parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • ENCRYPTION_PWD_PROMPT parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • ENCRYPTION parameter
    • Data Pump Export utility [1]
  • encryption password
    • Data Pump export [1]
    • Data Pump Import [1]
  • errors
    • caused by tab characters in SQL*Loader data [1]
    • LONG data [1]
    • object creation
      • Import parameter IGNORE [1]
    • resource errors on import [1]
    • writing to export log file [1]
  • ERRORS parameter
    • SQL*Loader command line [1]
  • escape character
    • quoted strings and [1]
    • usage in Data Pump Export [1]
    • usage in Data Pump Import [1]
    • usage in Export [1]
    • usage in Import [1]
  • ESTIMATE_ONLY parameter
    • Data Pump Export utility [1]
  • ESTIMATE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • estimating size of job
    • Data Pump Export utility [1]
  • EVALUATE CHECK_CONSTRAINTS clause [1]
  • EXCLUDE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • EXIT_CLIENT parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility
      • interactive-command mode [1]
  • exit codes
  • EXIT command, ADRCI utility [1]
  • EXP_FULL_DATABASE role
    • assigning in Export [1] , [2]
  • expdat.dmp
    • Export output file [1]
  • Export
    • BUFFER parameter [1]
    • character set conversion [1]
    • COMPRESS parameter [1]
    • CONSISTENT parameter [1]
    • CONSTRAINTS parameter [1]
    • conventional path [1]
    • creating
    • DIRECT parameter [1]
    • direct path [1]
    • displaying online help [1]
    • example sessions
      • full database mode [1]
      • partition-level [1]
      • table mode [1]
      • user mode [1] , [2]
    • exit codes [1]
    • exporting an entire database [1]
    • exporting indexes [1]
    • exporting sequence numbers [1]
    • exporting synonyms [1]
    • exporting to another operating system [1]
    • FEEDBACK parameter [1]
    • FILE parameter [1]
    • FILESIZE parameter [1]
    • FLASHBACK_SCN parameter [1]
    • FLASHBACK_TIME parameter [1]
    • full database mode
    • FULL parameter [1]
    • GRANTS parameter [1]
    • HELP parameter [1]
    • INDEXES parameter [1]
    • invoking [1] , [2]
    • log files
      • specifying [1]
    • logging error messages [1]
    • LOG parameter [1]
    • LONG columns [1]
    • OBJECT_CONSISTENT parameter [1]
    • online help [1]
    • OWNER parameter [1]
    • parameter file
      • maximum size [1]
    • parameter syntax [1]
    • PARFILE parameter [1]
    • partitioning a database migration [1]
    • QUERY parameter [1]
    • RECORDLENGTH parameter [1]
    • redirecting output to a log file [1]
    • remote operation [1] , [2]
    • restrictions based on privileges [1]
    • RESUMABLE_NAME parameter [1]
    • RESUMABLE_TIMEOUT parameter [1]
    • RESUMABLE parameter [1]
    • ROWS parameter [1]
    • sequence numbers [1]
    • storage requirements [1]
    • table mode
      • example session [1]
    • table name restrictions [1]
    • TABLESPACES parameter [1]
    • TABLES parameter [1]
    • TRANSPORT_TABLESPACE parameter [1]
    • TRIGGERS parameter [1]
    • TTS_FULL_CHECK parameter [1]
    • user access privileges [1] , [2]
    • USERID parameter [1]
    • user mode
    • VOLSIZE parameter [1]
  • export dump file
    • importing the entire file [1]
  • export file
    • listing contents before importing [1]
    • specifying [1]
  • exporting
    • archived LOBs [1]
  • EXPRESSION parameter
  • extents
    • consolidating [1]
  • EXTERNAL_TABLE parameter
    • SQL*Loader command line [1]
    • SQL*Loader express mode [1]
  • EXTERNAL parameter
    • SQL*Loader [1]
  • EXTERNAL SQL*Loader data types
    • numeric
      • determining len [1]
  • external tables
    • access parameters [1] , [2] , [3]
    • and encrypted columns [1]
    • big-endian data [1]
    • cacheing data during reads [1]
    • column_transforms clause [1]
    • data types [1]
    • date cache feature [1]
    • delimiters [1]
    • describing data type of a field [1]
    • field_definitions clause [1] , [2]
    • fixed-length records [1]
    • identifying character sets [1]
    • identifying data types [1]
    • improving performance when using
      • date cache feature [1]
    • IO_OPTIONS clause [1]
    • little-endian data [1]
    • opaque_format_spec [1] , [2] , [3]
    • preprocessing data [1]
    • record_format_info clause [1] , [2]
    • reserved words [1] , [2]
    • restrictions [1]
    • setting a field to a default value [1]
    • setting a field to null [1]
    • skipping records when loading data [1]
    • specifying compression level [1]
    • specifying delimiters [1]
    • specifying load conditions [1]
    • trimming blanks [1] , [2] , [3]
    • use of SQL strings [1]
    • using comments [1] , [2]
    • variable-length records [1]

F

  • fatal errors
    • See: nonrecoverable error messages
  • FEEDBACK parameter
    • Export utility [1]
    • Import utility [1]
  • FIELD_NAMES parameter
    • SQL*Loader express mode [1]
  • field conditions
    • specifying for SQL*Loader [1]
  • field length
    • SQL*Loader specifications [1]
  • field location
    • SQL*Loader [1]
  • fields
    • comparing to literals with SQL*Loader [1]
    • delimited
      • determining length [1]
      • SQL*Loader [1]
    • loading all blanks [1]
    • predetermined size
    • relative positioning and SQL*Loader [1]
    • specifying default delimiters for SQL*Loader [1]
    • specifying for SQL*Loader [1]
    • SQL*Loader delimited
      • specifications [1]
  • FIELDS clause
    • SQL*Loader [1]
  • file allocation in Data Pump
    • adding dump files [1]
    • default file locations [1]
    • NFS errors [1]
  • file names
    • quotation marks and [1]
    • specifying multiple SQL*Loader [1]
    • SQL*Loader [1]
    • SQL*Loader bad file [1]
  • FILE parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1]
    • SQL*Loader utility [1]
  • FILESIZE parameter
    • Data Pump Export utility [1]
    • Export utility [1]
    • Import utility [1]
  • FILLER field
    • using as argument to init_spec [1]
  • filtering data
    • using Data Pump Export utility [1]
    • using Data Pump Import utility [1]
  • filtering metadata that is imported
    • Data Pump Import utility [1]
  • finalizing
    • in ADRCI utility [1]
  • fine-grained access support
    • Export and Import [1]
  • fixed-format records [1]
  • fixed-length records
    • external tables [1]
  • FLASHBACK_SCN parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility [1]
  • FLASHBACK_TIME parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility [1]
  • foreign function libraries
  • formats
    • SQL*Loader input records and [1]
  • formatting errors
    • SQL*Loader [1]
  • FROMUSER parameter
    • Import utility [1]
  • full database mode
    • Import [1]
    • specifying with FULL [1]
  • full export mode
    • Data Pump Export utility [1]
  • FULL parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility [1]
    • Import utility [1]
  • full transportable export [1]
  • full transportable import [1]

G

  • globalization
    • SQL*Loader [1]
  • grants
  • GRANTS parameter
    • Export utility [1]
    • Import utility [1]

H

  • HELP parameter
    • Data Pump Export utility
      • command-line mode [1]
      • interactive-command mode [1]
    • Data Pump Import utility
      • command-line mode [1]
      • interactive-command mode [1]
    • Export utility [1]
    • Import utility [1]
  • hexadecimal strings
    • SQL*Loader [1]
  • homepath
    • in ADRCI utility [1]
  • HOST command, ADRCI utility [1]

I

  • IGNORE parameter
    • Import utility [1]
  • IMP_FULL_DATABASE role
    • assigning in Import [1] , [2]
  • Import
    • BUFFER parameter [1]
    • character set conversion [1] , [2] , [3]
    • COMMIT parameter [1]
    • committing after array insert [1]
    • COMPILE parameter [1]
    • CONSTRAINTS parameter [1]
    • creating
    • creating an index-creation SQL script [1]
    • database optimizer statistics [1]
    • DATAFILES parameter [1]
    • DESTROY parameter [1]
    • disabling referential constraints [1]
    • displaying online help [1]
    • dropping a tablespace [1]
    • errors importing database objects [1]
    • example sessions
      • all tables from one user to another [1]
      • selected tables for specific user [1]
      • tables exported by another user [1]
      • using partition-level Import [1]
    • exit codes [1]
    • export file
      • importing the entire file [1]
      • listing contents before import [1]
    • FEEDBACK parameter [1]
    • FILE parameter [1]
    • FILESIZE parameter [1]
    • FROMUSER parameter [1]
    • FULL parameter [1]
    • grants
      • specifying for import [1]
    • GRANTS parameter [1]
    • HELP parameter [1]
    • IGNORE parameter [1]
    • importing grants [1]
    • importing objects into other schemas [1]
    • importing tables [1]
    • INDEXFILE parameter [1]
    • INSERT errors [1]
    • invalid data [1]
    • invoking [1] , [2]
    • LOG parameter [1]
    • LONG columns [1]
    • manually creating tables before import [1]
    • manually ordering tables [1]
    • NLS_LANG environment variable [1] , [2]
    • object creation errors [1]
    • online help [1]
    • parameter file
      • maximum size [1]
    • parameter syntax [1]
    • PARFILE parameter [1]
    • partition-level [1]
    • pattern matching of table names [1]
    • read-only tablespaces [1]
    • RECORDLENGTH parameter [1]
    • records
      • specifying length [1]
    • redirecting output to a log file [1]
    • refresh error [1]
    • remote operation [1] , [2]
    • reorganizing tablespace during [1]
    • resource errors [1]
    • restrictions
      • importing into own schema [1]
    • RESUMABLE_NAME parameter [1]
    • RESUMABLE_TIMEOUT parameter [1]
    • RESUMABLE parameter [1]
    • reusing existing datafiles [1]
    • schema objects [1]
    • sequences [1]
    • SHOW parameter [1]
    • single-byte character sets [1] , [2]
    • SKIP_UNUSABLE_INDEXES parameter [1]
    • snapshot master table [1]
    • snapshots
      • restoring dropped [1]
    • specifying by user [1]
    • specifying index creation commands [1]
    • specifying the export file [1]
    • STATISTICS parameter [1]
    • storage parameters
      • overriding [1]
    • stored functions [1]
    • stored procedures [1]
    • STREAMS_CONFIGURATION parameter [1]
    • STREAMS_INSTANTIATION parameter [1]
    • system objects [1]
    • table-level [1]
    • table name restrictions [1] , [2] , [3]
    • table objects
      • import order [1]
    • TABLESPACES parameter [1]
    • TABLES parameter [1]
    • TOID_NOVALIDATE parameter [1]
    • TOUSER parameter [1]
    • TRANSPORT_TABLESPACE parameter [1]
    • TTS_OWNER parameter [1]
    • tuning considerations [1]
    • user access privileges [1] , [2]
    • USERID parameter [1]
    • VOLSIZE parameter [1]
  • incident
    • fault diagnosability infrastructure [1]
    • packaging [1]
  • incident package
    • fault diagnosability infrastructure [1]
  • INCLUDE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • indexes
    • creating manually [1]
    • direct path load
      • left in direct load state [1]
    • dropping
      • SQL*Loader [1]
    • estimating storage requirements [1]
    • exporting [1]
    • index-creation commands
    • left in unusable state [1] , [2]
    • multiple-column
      • SQL*Loader [1]
    • presorting data
      • SQL*Loader [1]
    • skipping unusable [1]
    • SQL*Loader [1]
    • state after discontinued load [1]
    • unique [1]
  • INDEXES parameter
    • Export utility [1]
  • INDEXFILE parameter
    • Import utility [1]
  • index options
    • SORTED INDEXES with SQL*Loader [1]
    • SQL*Loader SINGLEROW parameter [1]
  • Index Unusable state
    • indexes left in Index Unusable state [1] , [2]
  • INFILE parameter
    • SQL*Loader utility [1]
  • insert errors
  • INSERT into table
    • SQL*Loader [1]
  • instance affinity
    • Export and Import [1]
  • instance recovery [1]
  • integrity constraints
    • disabled during direct path load [1]
    • enabled during direct path load [1]
    • failed on Import [1]
    • load method [1]
  • interactive method
    • Data Pump Export utility [1]
  • internal LOBs
  • interrupted loads [1]
  • INTO TABLE statement
    • effect on bind array size [1]
    • multiple statements with SQL*Loader [1]
    • SQL*Loader
      • column names [1]
      • discards [1]
  • invalid data
  • invoking
    • Export
      • at the command line [1]
      • direct path [1]
      • interactively [1] , [2]
      • with a parameter file [1]
    • Import
      • as SYSDBA [1]
      • at the command line [1]
      • interactively [1] , [2]
      • with a parameter file [1]
  • IPS command, ADRCI utility [1]

J

  • JOB_NAME parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]

K

  • KEEP_MASTER parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • key values
    • generating with SQL*Loader [1]
  • KILL_JOB parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility [1]

L

  • leading whitespace
    • definition [1]
    • trimming and SQL*Loader [1]
  • legacy mode in Data Pump [1]
  • length indicator
    • determining size [1]
  • length-value pair specified LOBs [1]
  • libraries
    • foreign function
  • little-endian data
    • external tables [1]
  • loading
    • collections [1]
    • column objects
      • in variable record format [1]
      • with a derived subtype [1]
      • with user-defined constructors [1]
    • datafiles containing tabs
      • SQL*Loader [1]
    • external table data
      • skipping records [1]
      • specifying conditions [1] , [2]
    • LOBs [1]
    • nested column objects [1]
    • object tables [1]
    • object tables with a subtype [1]
    • REF columns [1]
    • subpartitioned tables [1]
    • tables [1]
  • LOAD parameter
    • SQL*Loader command line [1] , [2]
    • SQL*Loader express mode [1]
  • LOB data
    • in delimited fields [1]
    • in length-value pair fields [1]
    • in predetermined size fields [1]
    • loading with SQL*Loader [1]
    • no compression during export [1]
    • size of read buffer [1]
    • specifying storage in Data Pump [1]
    • types supported by SQL*Loader [1] , [2]
  • LOB data types [1]
  • LOBFILEs [1] , [2] , [3]
  • LOGFILE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • log files
    • after a discontinued load [1]
    • Export [1] , [2]
    • Import [1] , [2]
    • limiting data written to by Data Pump [1]
    • specifying for SQL*Loader [1]
    • SQL*Loader [1]
  • logical records
    • consolidating multiple physical records using SQL*Loader [1]
  • LogMiner utility
    • accessing redo data of interest [1]
    • adjusting redo log file list [1]
    • analyzing output [1]
    • configuration [1]
    • considerations for reapplying DDL statements [1]
    • current log file list
      • stored information about [1]
    • DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and [1]
    • DBMS_LOGMNR_D.BUILD PL/SQL procedure and [1]
    • DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and [1]
    • DBMS_LOGMNR_D PL/SQL procedure and [1]
    • DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and [1]
    • DBMS_LOGMNR PL/SQL procedure and [1]
    • DDL tracking
      • time or SCN ranges [1]
    • determining redo log files being analyzed [1]
    • dictionary
      • purpose of [1]
    • dictionary extracted to flat file
      • stored information about [1]
    • dictionary options
      • flat file and [1]
      • online catalog and [1]
      • redo log files and [1]
    • ending a session [1]
    • executing reconstructed SQL [1]
    • extracting data values from redo logs [1]
    • filtering data by SCN [1]
    • filtering data by time [1]
    • formatting returned data [1]
    • graphical user interface [1]
    • levels of supplemental logging [1]
    • LogMiner dictionary defined [1]
    • mining a subset of data in redo log files [1]
    • mining database definition for [1]
    • operations overview [1]
    • parameters
      • stored information about [1]
    • redo log files
      • on a remote database [1]
      • stored information about [1]
    • requirements for dictionary [1]
    • requirements for redo log files [1]
    • requirements for source and mining databases [1]
    • restrictions with XMLType data [1]
    • sample configuration [1]
    • showing committed transactions only [1]
    • skipping corruptions [1]
    • source database definition for [1]
    • specifying redo log files to mine
      • automatically [1]
      • manually [1]
    • specifying redo logs for analysis [1]
    • starting [1] , [2]
    • starting multiple times within a session [1]
    • steps for extracting dictionary to a flat file [1]
    • steps for extracting dictionary to redo log files [1]
    • steps for using dictionary in online catalog [1]
    • steps in a typical session [1]
    • supplemental logging
      • database level [1]
      • database-level identification keys [1]
      • disabling database-level [1]
      • interactions with DDL tracking [1]
      • log groups [1]
      • minimal [1]
      • stored information about [1]
      • table-level identification keys [1]
      • table-level log groups [1]
      • user-defined log groups [1]
    • supplemental log groups
      • conditional [1]
      • unconditional [1]
    • supported database versions [1]
    • supported data types [1]
    • supported redo log file versions [1]
    • support for transparent data encryption [1]
    • suppressing delimiters in SQL_REDO and SQL_UNDO [1]
    • table-level supplemental logging [1]
    • tracking DDL statements
      • requirements [1]
    • unsupported data types [1]
    • using in a CDB [1]
    • using the online catalog [1]
    • using to analyze redo log files [1]
    • V$DATABASE view [1]
    • V$LOGMNR_CONTENTS view [1] , [2] , [3]
    • V$LOGMNR_LOGS view
    • views [1]
  • LogMiner Viewer [1]
  • LOG parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1]
  • LOGTIME parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • LONG data

M

  • MASTER_ONLY parameter
    • Data Pump Import utility [1]
  • master tables
    • Oracle Data Pump API [1]
    • snapshots
      • original Import [1]
  • materialized views [1]
  • media recovery
    • direct path load [1]
  • Metadata API
    • enhancing performance [1]
    • retrieving collections [1]
    • using to retrieve object metadata [1]
  • METRICS parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • missing data columns
    • SQL*Loader [1]
  • multibyte character sets
    • blanks with SQL*Loader [1]
    • SQL*Loader [1]
  • multiple-column indexes
    • SQL*Loader [1]
  • multiple-CPU systems
    • optimizing direct path loads [1]
  • multiple-table load
    • generating unique sequence numbers using SQL*Loader [1]
    • SQL*Loader control file specification [1]
  • multitenant container databases [1] , [2]
  • multithreading
    • on multiple-CPU systems [1]
  • MULTITHREADING parameter
    • SQL*Loader command line [1]

N

  • named pipes
    • external table loads [1]
  • native data types
    • conflicting length specifications
      • SQL*Loader [1]
  • NCLOBs
    • loading with SQL*Loader [1]
  • nested column objects
  • nested tables
    • exporting
      • consistency and [1]
    • importing [1]
  • NETWORK_LINK parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • networks
  • NFS errors when using Data Pump [1]
  • NLS_LANG environment variable
    • with Export and Import [1] , [2]
  • NO_INDEX_ERRORS parameter
    • SQL*Loader command line [1]
  • NOLOGFILE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • nonrecoverable error messages
  • nonscalar data types [1]
  • NOT NULL constraint
    • load method [1]
  • null data
    • missing columns at end of record during load [1]
    • unspecified columns and SQL*Loader [1]
  • NULLIF...BLANKS clause
    • SQL*Loader [1]
  • NULLIF clause
  • NULLIF parameter
    • SQL*Loader express mode [1]
  • nulls
  • NULL values
  • NUMBER data type
  • numeric EXTERNAL data types
    • delimited form and SQL*Loader [1]
    • determining length [1]

O

  • OBJECT_CONSISTENT parameter
    • Export utility [1]
  • object identifiers
    • importing [1]
  • object names
    • SQL*Loader [1]
  • objects
    • creation errors [1]
    • ignoring existing objects during import [1]
    • import creation errors [1]
    • loading nested column objects [1]
    • NULL values [1]
    • stream record format [1]
    • variable record format [1]
  • object tables
    • loading [1]
    • with a subtype
  • object type definitions
    • exporting [1]
  • object types supported by SQL*Loader [1]
  • offline locally managed tablespaces
    • exporting [1]
  • OID
    • See: object identifiers
  • online help
    • Export and Import [1]
  • opaque_format_spec [1] , [2] , [3]
  • operating systems
    • moving data to different systems using SQL*Loader [1]
  • OPTIMAL storage parameter
    • used with Export/Import [1]
  • optimizer statistics [1]
  • optimizing
    • direct path loads [1]
    • SQL*Loader input file processing [1]
  • OPTIONALLY_ENCLOSED_BY parameter
    • SQL*Loader express mode [1]
  • OPTIONALLY ENCLOSED BY clause
    • SQL*Loader [1]
  • OPTIONS parameter
    • for parallel loads [1]
    • SQL*Loader utility [1]
  • ORA-39357: WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database [1]
  • ORACLE_DATAPUMP access driver
    • effect of SQL ENCRYPT clause on [1]
    • reserved words [1] , [2]
  • ORACLE_LOADER access driver
  • Oracle Advanced Queuing
    • See: Advanced Queuing
  • Oracle Automatic Storage Management (ASM)
    • Data Pump and [1]
  • Oracle Data Pump
    • direct path loads
      • restrictions [1]
    • master table [1]
    • tuning performance [1]
  • Oracle Data Pump API
    • client interface [1]
    • job states [1]
    • monitoring job progress [1]
  • OWNER parameter
    • Export utility [1]

P

  • packages
  • padding of literal strings
    • SQL*Loader [1]
  • parallel loads
    • restrictions on direct path [1]
    • when using PREPROCESSOR clause [1]
  • PARALLEL parameter
    • Data Pump Export utility
      • command-line interface [1]
      • interactive-command mode [1]
    • Data Pump Import utility
      • command-line mode [1]
      • interactive-command mode [1]
    • SQL*Loader command line [1]
  • parameter files
    • Export [1]
    • Export and Import
      • comments in [1]
      • maximum size [1]
    • Import [1]
    • SQL*Loader [1]
  • PARFILE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export command line [1]
    • Import command line [1]
    • SQL*Loader express mode [1]
  • PARTITION_MEMORY parameter
    • SQL*Loader utility [1]
  • PARTITION_OPTIONS parameter
    • Data Pump Import utility [1]
  • partitioned loads
    • concurrent conventional path loads [1]
    • SQL*Loader [1]
  • partitioned object support in SQL*Loader [1]
  • partitioned tables
  • partitioning a database migration
    • advantages of [1]
    • disadvantages of [1]
    • procedure during export [1] , [2]
  • partition-level Export
    • example session [1]
  • partition-level Import
    • specifying [1]
  • pattern matching
    • table names during import [1]
  • performance
    • improving when using integrity constraints [1]
    • optimizing for direct path loads [1]
    • optimizing reading of SQL*Loader data files [1]
    • tuning original Import [1]
  • PIECED parameter
    • SQL*Loader [1]
  • POSITION parameter
    • using with data containing tabs [1]
    • with multiple SQL*Loader INTO TABLE clauses [1] , [2] , [3]
  • predetermined size fields
    • SQL*Loader [1]
  • predetermined size LOBs [1]
  • preprocessing data for external tables
    • effects of parallel processing [1]
  • prerequisites
    • SQL*Loader [1]
  • PRESERVE parameter [1]
  • preserving
    • whitespace [1]
  • PRIMARY KEY constraints
    • effect on direct path load [1]
  • primary key OIDs
  • primary key REF columns [1]
  • privileges
    • EXEMPT ACCESS POLICY
      • effect on direct path export [1]
    • required for Export and Import [1] , [2]
    • required for SQL*Loader [1]
  • problem
    • fault diagnosability infrastructure [1]
  • problem key
    • fault diagnosability infrastructure [1]
  • PURGE command, ADRCI utility [1]

Q

  • QUERY parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility
      • restrictions [1]
  • QUIT command, ADRCI utility [1]
  • quotation marks
    • escape characters and [1]
    • file names and [1]
    • SQL strings and [1]
    • table names and [1] , [2] , [3]
    • usage in Data Pump Export [1]
    • usage in Data Pump Import [1]
    • use with database object names [1]

R

  • read-consistent export [1]
  • read-only tablespaces
  • READSIZE parameter
    • SQL*Loader command line
      • effect on LOBs [1]
      • maximum size [1]
  • RECNUM parameter
    • use with SQL*Loader SKIP parameter [1]
  • RECORDLENGTH parameter
    • Export utility [1]
    • Import utility [1]
  • records
    • consolidating into a single logical record
      • SQL*Loader [1]
    • discarded by SQL*Loader [1] , [2]
    • distinguishing different formats for SQL*Loader [1]
    • extracting multiple logical records using SQL*Loader [1]
    • fixed format [1]
    • missing data columns during load [1]
    • rejected by SQL*Loader [1] , [2] , [3] , [4]
    • setting column to record number with SQL*Loader [1]
    • specifying how to load [1] , [2]
    • specifying length for export [1]
    • specifying length for import [1]
    • stream record format [1]
  • recovery
    • direct path load
      • SQL*Loader [1]
    • replacing rows [1]
  • redo log file
    • LogMiner utility
      • versions supported [1]
  • redo log files
    • analyzing [1]
    • requirements for LogMiner utility [1]
    • specifying for the LogMiner utility [1]
  • redo logs
    • direct path load [1]
    • instance and media recovery
      • SQL*Loader [1]
    • minimizing use during direct path loads [1]
    • saving space
      • direct path load [1]
  • REF columns
    • loading [1]
    • primary key [1]
    • system-generated [1]
  • REF data
    • importing [1]
  • referential integrity constraints
    • disabling for import [1]
    • SQL*Loader [1]
  • refresh error
    • snapshots
  • rejected records
  • reject files
    • specifying for SQL*Loader [1]
  • relative field positioning
    • where a field starts and SQL*Loader [1]
    • with multiple SQL*Loader INTO TABLE clauses [1]
  • REMAP_DATAFILE parameter
    • Data Pump Import utility [1]
  • REMAP_DATA parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • REMAP_SCHEMA parameter
    • Data Pump Import utility [1]
  • REMAP_TABLE parameter
    • Data Pump Import utility [1]
  • REMAP_TABLESPACE parameter
    • Data Pump Import utility [1]
  • remote operation
  • REPLACE table
    • replacing a table using SQL*Loader [1]
  • reserved words
    • external tables [1] , [2]
    • ORACLE_DATAPUMP access driver [1] , [2]
    • ORACLE_LOADER access driver [1] , [2]
    • SQL*Loader [1]
  • resource consumption
    • controlling in Data Pump Export utility [1]
    • controlling in Data Pump Import utility [1]
  • resource errors
  • RESOURCE role [1]
  • restrictions
    • importing into another user’s schema [1]
    • table names in Export parameter file [1]
    • table names in Import parameter file [1] , [2] , [3]
  • RESUMABLE_NAME parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1]
  • RESUMABLE_TIMEOUT parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1]
  • RESUMABLE parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1]
  • resumable space allocation
    • enabling and disabling [1] , [2]
  • retrieving object metadata
    • using Metadata API [1]
  • REUSE_DATAFILES parameter
    • Data Pump Import utility [1]
  • REUSE_DUMPFILES parameter
    • Data Pump Export utility [1]
  • roles
    • DATAPUMP_EXP_FULL_DATABASE [1]
    • DATAPUMP_IMP_FULL_DATABASE [1]
    • EXP_FULL_DATABASE [1]
    • IMP_FULL_DATABASE [1]
    • RESOURCE [1]
  • rollback segments
    • effects of CONSISTENT Export parameter [1]
  • row errors
  • ROWID columns
    • loading with SQL*Loader [1]
  • rows
    • choosing which to load using SQL*Loader [1]
    • exporting [1]
    • specifying number to insert before save
      • SQL*Loader [1]
    • updates to existing rows with SQL*Loader [1]
  • ROWS parameter
    • Export utility [1]
    • performance issues
      • SQL*Loader [1]
    • SQL*Loader command line [1]
    • using to specify when data saves occur [1]
  • RUN command, ADRCI utility [1]

S

  • SAMPLE parameter
    • Data Pump Export utility [1]
  • schema mode export
    • Data Pump Export utility [1]
  • schemas
    • specifying for Export [1]
  • SCHEMAS parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • scientific notation for FLOAT EXTERNAL [1]
  • script files
    • running before Export and Import [1]
  • SDFs
    • See: secondary datafiles
  • secondary datafiles [1] , [2]
  • SecureFiles
    • encryption during Data Pump export [1]
  • SecureFiles LOB
    • export considerations [1]
  • security considerations
    • direct path export [1]
  • segments
    • temporary
      • FILE parameter in SQL*Loader [1]
  • SELECT command, ADRCI utility
    • functions [1]
  • sequence numb [1]
  • sequence numbers
    • cached [1]
    • exporting [1]
    • for multiple tables and SQL*Loader [1]
    • generated, not read and SQL*Loader [1]
    • generated by SQL*Loader SEQUENCE clause [1]
  • SERVICE_NAME parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • SET BASE command, ADRCI utility [1]
  • SET BROWSER command, ADRCI utility [1]
  • SET CONTROL command, ADRCI utility [1]
  • SET ECHO command, ADRCI utility [1]
  • SET EDITOR command, ADRCI utility [1]
  • SET HOMEPATH command, ADRCI utility [1]
  • SET TERMOUT command, ADRCI utility [1]
  • short records with missing data
    • SQL*Loader [1]
  • SHOW ALERT command, ADRCI utility [1]
  • SHOW BASE command, ADRCI utility [1]
  • SHOW CONTROL command, ADRCI utility [1]
  • SHOW HM_RUN command, ADRCI utility [1]
  • SHOW HOMEPATH command, ADRCI utility [1]
  • SHOW HOMES command, ADRCI utility [1]
  • SHOW INCDIR command, ADRCI utility [1]
  • SHOW INCIDENT command, ADRCI utility [1]
  • SHOW LOG command, ADRCI utility [1]
  • SHOW parameter
    • Import utility [1]
  • SHOW PROBLEM command, ADRCI utility [1]
  • SHOW REPORT command, ADRCI utility [1]
  • SHOW TRACEFILE command, ADRCI utility [1]
  • SILENT parameter
    • SQL*Loader command line [1]
    • SQL*Loader express mode [1]
  • single-byte character sets
  • SINGLEROW parameter [1]
  • single-table loads
    • continuing [1]
  • SKIP_INDEX_MAINTENANCE parameter
    • SQL*Loader command line [1]
  • SKIP_UNUSABLE_INDEXES parameter
    • Import utility [1]
    • SQL*Loader command line [1]
  • SKIP_USABLE_INDEXES parameter
    • Data Pump Import utility [1]
  • SKIP parameter
    • effect on SQL*Loader RECNUM specification [1]
    • SQL*Loader command line [1]
  • skipping unusable indexes [1]
  • snapshot log
  • snapshots
    • importing [1]
    • master table
    • restoring dropped
  • SORTED INDEXES clause
    • direct path loads [1]
    • SQL*Loader [1]
  • sorting
    • multiple-column indexes
      • SQL*Loader [1]
    • optimum sort order
      • SQL*Loader [1]
    • presorting in direct path load [1]
    • SORTED INDEXES clause
      • SQL*Loader [1]
  • SOURCE_EDITION parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • SPOOL command, ADRCI utility [1]
  • SQL*Loader
    • appending rows to tables [1]
    • auditing direct path loads [1]
    • BAD command-line parameter [1]
    • bad file [1]
    • BADFILE parameter [1]
    • bad files [1]
    • bind arrays and performance [1]
    • BINDSIZE command-line parameter [1] , [2]
    • choosing which rows to load [1]
    • COLUMNARRAYROWS command-line parameter [1]
    • command-line parameters [1]
    • continuing single-table loads [1]
    • CONTROL command-line parameter [1]
    • control file [1]
    • conventional path loads [1] , [2]
    • DATA command-line parameter [1] , [2]
    • data conversion [1]
    • data definition language
      • syntax diagrams [1]
    • data type specifications [1]
    • DATE_CACHE command-line parameter [1]
    • DEGREE_OF_PARALLELISM command-line parameter [1]
    • determining default schema [1]
    • DIRECT command-line parameter [1]
    • direct path method
      • auditing [1]
      • using date cache feature to improve performance [1]
    • DISCARD command-line parameter [1]
    • discarded records [1]
    • DISCARDFILE parameter [1]
    • DISCARDMAX parameter [1]
    • DISCARDS parameter [1]
    • DNFS_ENABLE command-line parameter [1]
    • DNFS_READBUFFERS command-line parameter [1]
    • errors caused by tabs [1]
    • ERRORS command-line parameter [1]
    • exclusive access [1]
    • express mode [1]
    • EXTERNAL_TABLE command-line parameter [1]
    • external table loads [1]
    • FILE command-line parameter [1]
    • file names [1]
    • globalization technology [1]
    • index options [1]
    • inserting rows into tables [1]
    • INTO TABLE statement [1]
    • LOAD command-line parameter [1] , [2]
    • loading column objects [1]
    • loading data across different platforms [1]
    • loading data contained in the control file [1]
    • loading object tables [1]
    • load methods [1]
    • LOG command-line parameter [1]
    • log files [1]
    • methods of loading data [1]
    • multiple INTO TABLE statements [1]
    • MULTITHREADING command-line parameter [1]
    • NO_INDEX_ERRORS command-line parameter [1]
    • object names [1]
    • PARALLEL command-line parameter [1]
    • parallel data loading [1] , [2] , [3]
    • portable data types [1]
    • READSIZE command-line parameter
      • maximum size [1]
    • rejected records [1]
    • replacing rows in tables [1]
    • required privileges [1]
    • RESUMABLE_NAME command-line parameter [1]
    • RESUMABLE_TIMEOUT command-line parameter [1]
    • RESUMABLE command-line parameter [1]
    • ROWS command-line parameter [1]
    • SILENT command-line parameter [1]
    • SINGLEROW parameter [1]
    • SKIP_UNUSABLE_INDEXES command-line parameter [1]
    • SKIP command-line parameter [1]
    • SORTED INDEXES during direct path loads [1]
    • specifying columns [1]
    • specifying data files [1]
    • specifying field conditions [1]
    • specifying fields [1]
    • specifying load method [1]
    • specifying more than one data file [1]
    • STREAMSIZE command-line parameter [1]
    • suppressing messages [1]
    • TRIM command-line parameter [1]
    • USERID command-line parameter [1] , [2]
  • SQL*Loader control files
    • guidelines when creating [1]
  • SQL*Loader data types
    • nonportable [1]
  • SQL*Loader express mode
    • BAD parameter [1]
    • byte-order handling [1]
    • CHARACTERSET parameter [1]
    • CSV parameter [1]
    • DATA parameter [1]
    • DATE_FORMAT parameter [1]
    • default values [1]
    • DEGREE_OF_PARALLELISM parameter [1]
    • DIRECT parameter [1]
    • DNFS_ENABLE parameter [1]
    • DNFS_READBUFFERS parameter [1]
    • ENCLOSED_BY parameter [1]
    • EXTERNAL_TABLE parameter [1]
    • FIELD_NAMES parameter [1]
    • LOAD parameter [1]
    • NULLIF parameter [1]
    • OPTIONALLY_ENCLOSED_BY parameter [1]
    • PARFILE parameter [1]
    • SILENT parameter [1]
    • syntax diagrams [1]
    • TABLE parameter [1]
    • TERMINATED_BY parameter [1]
    • TIMESTAMP_FORMAT parameter [1]
    • TRIM parameter [1]
    • USERID parameter [1]
  • SQL*Loader utility
    • PARTITION_MEMORY parameter [1]
  • SQLFILE parameter
    • Data Pump Import utility [1]
  • SQL operators
    • applying to fields [1]
  • SQL strings
    • applying SQL operators to fields [1]
    • quotation marks and [1]
  • START_JOB parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility
      • interactive-command mode [1]
  • starting
    • LogMiner utility [1]
  • statistics
    • analyzer [1]
    • optimizer [1]
    • specifying for Import [1]
  • STATISTICS parameter
    • Import utility [1]
  • STATUS parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility
      • interactive-command mode [1]
  • STOP_JOB parameter
    • Data Pump Export utility
      • interactive-command mode [1]
    • Data Pump Import utility
      • interactive-command mode [1]
  • storage parameters
    • estimating export requirements [1]
    • OPTIMAL parameter [1]
    • overriding
    • preallocating
      • direct path load [1]
    • temporary for a direct path load [1]
    • using with Export/Import [1]
  • stored functions
    • importing
      • effect of COMPILE parameter [1]
  • stored package [1]
  • stored packages
    • importing [1]
  • stored procedures
    • direct path load [1]
    • importing
      • effect of COMPILE parameter [1]
  • stream buffer
    • specifying size for direct path [1]
  • stream record format
    • loading column objects in [1]
  • STREAMS_CONFIGURATION parameter
    • Data Pump Import utility [1]
    • Import utility [1]
  • STREAMS_INSTANTIATION parameter
    • Import utility [1]
  • Streams environment in Data Pump
    • setting buffer cache size [1]
  • STREAMSIZE parameter
    • SQL*Loader command line [1]
  • string comparisons
    • SQL*Loader [1]
  • subpartitioned tables
  • subtypes
    • loading multiple [1]
  • supplemental logging
    • LogMiner utility
      • database-level identification keys [1]
      • log groups [1]
      • table-level [1]
      • table-level identification keys [1]
      • table-level log groups [1]
  • synonyms
    • exporting [1]
  • syntax diagrams
    • Data Pump Export [1]
    • Data Pump Import [1]
    • SQL*Loader [1]
    • SQL*Loader express mode [1]
  • SYSDATE parameter
    • SQL*Loader [1]
  • system-generated OID REF columns [1]
  • system objects
    • importing [1]
  • system triggers
    • effect on import [1]
    • testing [1]

T

  • TABLE_EXISTS_ACTION parameter
    • Data Pump Import utility [1]
  • table compression
    • specifying type in Data Pump jobs [1]
  • table-level Export [1]
  • table-level Import [1]
  • table-mode Export
    • Data Pump Export utility [1]
    • specifying [1]
  • table-mode Import
  • table names
    • preserving case sensitivity [1]
  • TABLE parameter
    • SQL*Loader express mode [1]
  • tables
    • Advanced Queuing
    • appending rows with SQL*Loader [1]
    • defining before Import [1]
    • definitions
      • creating before Import [1]
    • exclusive access during direct path loads
      • SQL*Loader [1]
    • external [1]
    • importing [1]
    • inserting rows using SQL*Loader [1]
    • insert triggers
      • direct path load in SQL*Loader [1]
    • loading data into more than one table using SQL*Loader [1]
    • loading object tables [1]
    • maintaining consistency during Export [1]
    • manually ordering for Import [1]
    • master table
    • name restrictions
    • nested
    • objects
      • order of import [1]
    • partitioned [1]
    • replacing rows using SQL*Loader [1]
    • specifying for export [1]
    • specifying table-mode Export [1]
    • SQL*Loader method for individual tables [1]
    • truncating
      • SQL*Loader [1]
    • updating existing rows using SQL*Loader [1]
  • tablespace mode Export
    • Data Pump Export utility [1]
  • tablespaces
    • dropping during import [1]
    • exporting a set of [1]
    • metadata
      • transporting [1]
    • read-only
    • reorganizing
  • TABLESPACES parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility [1]
    • Import utility [1]
  • TABLES parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
    • Export utility [1]
    • Import utility [1]
  • tabs
    • loading datafiles containing tabs [1]
    • trimming [1]
    • whitespace [1]
  • TARGET_EDITION parameter
    • Data Pump Import utility [1]
  • temporary segments
    • FILE parameter
      • SQL*Loader [1]
  • temporary storage in a direct path load [1]
  • TERMINATED_BY parameter
    • SQL*Loader express mode [1]
  • TERMINATED BY clause
    • with OPTIONALLY ENCLOSED BY [1]
  • terminated fields
    • specified with a delimiter [1]
  • TIMESTAMP_FORMAT parameter
    • SQL*Loader express mode [1]
  • timestamps
    • on Data Pump Export operations [1]
    • on Data Pump Import operations [1]
  • TOID_NOVALIDATE parameter
    • Import utility [1]
  • TOUSER parameter
    • Import utility [1]
  • trace files
    • viewing with ADRCI [1]
  • trailing blanks
    • loading with delimiters [1]
  • TRAILING NULLCOLS parameter
    • SQL*Loader utility [1] , [2]
  • trailing whitespace
  • TRANSFORM parameter
    • Data Pump Import utility [1]
  • transparent data encryption
    • as handled by Data Pump Export [1]
    • as handled by Data Pump Import [1]
    • LogMiner support [1]
  • TRANSPORT_DATAFILES parameter
    • Data Pump Import utility [1]
  • TRANSPORT_FULL_CHECK parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • TRANSPORT_TABLESPACE parameter
    • Export utility [1]
    • Import utility [1]
  • TRANSPORT_TABLESPACES parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • transportable option
    • used during full-mode export [1]
    • used during full-mode import [1]
    • used during table-mode export [1]
  • TRANSPORTABLE parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • transportable-tablespace mode Export
    • Data Pump Export utility [1]
  • transportable tablespaces [1]
  • triggers
    • database insert [1]
    • logon
      • effect in SQL*Loader [1]
    • permanently disabled [1]
    • replacing with integrity constraints [1]
    • system
    • update
      • SQL*Loader [1]
  • TRIGGERS parameter
    • Export utility [1]
  • trimming
    • summary [1]
    • trailing whitespace
      • SQL*Loader [1]
  • TRIM parameter
    • SQL*Loader command line [1]
    • SQL*Loader express mode [1]
  • TTS_FULL_CHECK parameter
    • Export utility [1]
  • TTS_OWNERS parameter
    • Import utility [1]

U

  • unified auditing
    • during SQL*Loader operations [1]
  • UNIQUE KEY constraints
    • effect on direct path load [1]
  • unique values
    • generating with SQL*Loader [1]
  • unloading entire database
    • Data Pump Export utility [1]
  • UNRECOVERABLE clause
    • SQL*Loader [1]
  • unsorted data
    • direct path load
      • SQL*Loader [1]
  • USER_SEGMENTS view
    • Export and [1]
  • user-defined constructors
    • loading column objects with [1]
  • USERID parameter
    • Export utility [1]
    • Import utility [1]
    • SQL*Loader command line [1] , [2]
    • SQL*Loader express mode [1]
  • user mode export
    • specifying [1]

V

  • V$DATABASE view [1]
  • V$LOGMNR_CONTENTS view
    • formatting information returned to [1]
    • impact of querying [1]
    • information within [1]
    • limiting information returned to [1]
    • LogMiner utility [1]
    • requirements for querying [1] , [2]
  • V$LOGMNR_LOGS view
  • V$SESSION_LONGOPS view
    • monitoring Data Pump jobs with [1]
  • VARCHAR2 data type
    • SQL*Loader [1]
  • variable-length records
    • external tables [1]
  • variable records
  • VARRAY columns
    • memory issues when loading [1]
  • VERSION parameter
    • Data Pump Export utility [1]
    • Data Pump Import utility [1]
  • viewing
    • trace files with ADRCI [1]
  • views
    • exporting as tables [1]
  • VIEWS_AS_TABLES
    • Data Pump Export parameter [1]
  • VIEWS_AS_TABLES (Network Import)
    • Data Pump Import parameter [1]
  • VIEWS_AS_TABLES (Non-Network Import)
    • Data Pump Import parameter [1]
  • VIEWS_AS_TABLES parameter
    • Data Pump Export utility [1]
  • VIEWS_AS_TABLES parameter (Network Import)
    • Data Pump Import utility [1]
  • VIEWS_AS_TABLES parameter (Non_Network Import)
    • Data Pump Import utility [1]
  • VOLSIZE parameter
    • Export utility [1]
    • Import utility [1]

W

  • warning messages
  • WHEN clause
    • SQL*Loader [1] , [2]
    • SQL*Loader discards resulting from [1]
  • whitespace
    • included in a field [1]
    • leading [1]
    • preserving [1]
    • terminating a field [1]
    • trimming [1]

X

  • XML columns
    • loading with SQL*Loader [1]
    • treatment by SQL*Loader [1]
  • XMLTYPE clause
    • in SQL*Loader control file [1]
  • XML type tables
    • identifying in SQL*Loader [1]