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 1
    • ADR base 1
    • ADR home 1
    • batch mode 1
    • commands 1
    • getting help 1
    • homepath 1
    • interactive mode 1
    • starting 1
  • ADR home
    • in ADRCI utility 1
  • Advanced Queuing
    • exporting advanced queue tables 1
    • importing advanced queue tables 1
  • aliases
    • directory
      • exporting 1
      • importing 1
  • 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
    • null 1
  • 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
      • Import 1
  • 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 1
      • external tables 1, 2, 3
    • 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 1
    • big-endian 1
    • little-endian 1
    • specifying in SQL*Loader control file 1
  • BYTEORDERMARK parameter
    • SQL*Loader utility 1
  • byte order marks 1
    • 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
    • Export 1
  • catalog.sql script
    • preparing database for Export and Import 1, 2
  • catexp.sql script
    • preparing database for Export and Import 1, 2
  • 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, 2
    • eight-bit to seven-bit conversions
      • Export/Import 1, 2
    • identifying for external tables 1
    • multibyte
      • Export/Import 1
      • SQL*Loader 1
    • single-byte
      • Export/Import 1, 2
    • 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 1
    • loading 1
  • collection types supported by SQL*Loader 1
  • column array rows
    • specifying number of 1
  • COLUMNARRAYROWS parameter
    • SQL*Loader command line 1
  • column objects
    • loading 1
      • 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, 2
    • with external tables 1, 2
  • COMMIT parameter
    • Import utility 1
  • COMPILE parameter
    • Import utility 1
  • completion messages
    • Export 1
    • Import 1
  • 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 1
      • nested tables and 1
      • partitioned table and 1
  • consolidating
    • extents 1
  • 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
      • Import 1
    • load method 1
  • CONSTRAINTS parameter
    • Export utility 1
    • Import utility 1
  • constructors
    • attribute-value 1
      • overriding 1
    • user-defined 1
      • 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, 2
    • effect of character set sorting on 1, 2
  • conversion of data
    • during direct path loads 1
  • conversion of input characters 1
  • CREATE REPORT command, ADRCI utility 1
  • CREATE SESSION privilege
    • Export 1, 2
    • Import 1, 2
  • 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_CACHE parameter
    • SQL*Loader utility 1
  • DATA_OPTIONS parameter
    • Data Pump Export utility 1
    • Data Pump Import utility 1
  • database ID (DBID)
    • changing 1
  • database identifier
    • changing 1
  • database migration
    • partitioning of 1, 2
  • database name (DBNAME)
    • changing 1
  • 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
      • Import 1
  • data cache feature
    • DATA_CACHE parameter 1
    • external tables 1
    • SQL*Loader 1
  • 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 1
      • 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
      • as SYSDBA 1, 2
    • 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 1
      • 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_FORMAT parameter
    • SQL*Loader express mode 1
  • DATE data type
    • delimited form and SQL*Loader 1
    • determining length 1
    • mask
      • SQL*Loader 1
  • DBID (database identifier)
    • changing 1
  • 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 1
    • null values and 1
  • DBMS_LOGMNR.START_LOGMNR PL/SQL procedure 1
    • 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
    • changing 1
  • DBNEWID utility 1
    • 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
    • exporting 1
    • importing 1
  • 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 1, 2
    • 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 1
    • causes 1
    • discard file 1
    • limiting 1
  • discard files
    • SQL*Loader 1
      • specifying a maximum 1
  • DISCARD parameter
    • SQL*Loader command-line 1
  • discontinued loads 1
    • 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
    • Import 1
  • DUMPFILE parameter
    • Data Pump Export utility 1
    • Data Pump Import utility 1
  • dump files
    • maximum size 1

E

  • EBCDIC character set
    • Import 1, 2
  • 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 1
    • 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 1
      • 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
    • Export and Import 1, 2
    • SQL*Loader 1, 2
  • 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, 2
    • COMPRESS parameter 1
    • CONSISTENT parameter 1
    • CONSTRAINTS parameter 1
    • conventional path 1
    • creating
      • necessary privileges 1, 2
      • necessary views 1, 2
    • DIRECT parameter 1
    • direct path 1
    • displaying online help 1
    • example sessions 1
      • full database mode 1
      • partition-level 1
      • table mode 1
      • user mode 1, 2
    • exit codes 1, 2
    • exporting an entire database 1
    • exporting indexes 1
    • exporting sequence numbers 1
    • exporting synonyms 1
    • exporting to another operating system 1, 2
    • FEEDBACK parameter 1
    • FILE parameter 1
    • FILESIZE parameter 1
    • FLASHBACK_SCN parameter 1
    • FLASHBACK_TIME parameter 1
    • full database mode
      • example 1
    • 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 1
      • maximum size 1, 2
    • parameter syntax 1
    • PARFILE parameter 1
    • partitioning a database migration 1, 2
    • 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
      • example session 1, 2
      • specifying 1
    • 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
    • SQL*Loader 1, 2
  • 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 cache feature 1
    • data types 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
      • data 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
      • length 1
      • SQL*Loader 1
    • 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
    • exporting 1
    • importing 1, 2
  • 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
    • exporting 1
    • importing 1
  • 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, 4
    • COMMIT parameter 1
    • committing after array insert 1
    • COMPILE parameter 1
    • CONSTRAINTS parameter 1
    • creating
      • necessary privileges 1, 2
      • necessary views 1, 2
    • 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 1
      • 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, 2
    • 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 1
      • maximum size 1, 2
    • 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 1
      • 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
      • Import 1
    • 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
    • Import 1
    • specifying 1
  • 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
    • loading 1
  • interrupted loads 1
  • INTO TABLE statement
    • effect on bind array size 1
    • multiple statements with SQL*Loader 1
    • SQL*Loader 1
      • column names 1
      • discards 1
  • invalid data
    • Import 1
  • invoking
    • Export 1, 2
      • at the command line 1, 2
      • direct path 1
      • interactively 1, 2
      • with a parameter file 1, 2
    • Import 1, 2
      • as SYSDBA 1, 2
      • at the command line 1, 2
      • interactively 1, 2
      • with a parameter file 1, 2
  • 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
      • exporting 1
      • importing 1, 2
  • little-endian data
    • external tables 1
  • loading
    • collections 1
    • column objects 1
      • 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 1
      • 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 1
      • 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 1
      • 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 1
      • 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 1
      • 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
      • querying 1
    • 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
    • exporting 1
    • importing 1

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
    • loading 1
  • nested tables
    • exporting 1
      • consistency and 1
    • importing 1
  • NETWORK_LINK parameter
    • Data Pump Export utility 1
    • Data Pump Import utility 1
  • networks
    • Export and Import 1, 2
  • NFS errors when using Data Pump 1
  • NLS_LANG environment variable 1, 2
    • 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
    • Export 1
    • Import 1
  • 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
    • SQL*Loader 1, 2
  • NULLIF parameter
    • SQL*Loader express mode 1
  • nulls
    • atomic 1
    • attribute 1
  • NULL values
    • objects 1
  • NUMBER data type
    • SQL*Loader 1, 2
  • numeric EXTERNAL data types
    • delimited form and SQL*Loader 1
    • determining length 1

O

  • OBJECT_CONSISTENT parameter
    • Export utility 1
  • object identifiers 1
    • importing 1
  • object names
    • SQL*Loader 1
  • objects 1
    • 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
      • loading 1
  • 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
    • reserved words 1, 2
  • 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 1
    • client interface 1
    • job states 1
    • monitoring job progress 1
  • OWNER parameter
    • Export utility 1

P

  • packages
    • creating 1
  • padding of literal strings
    • SQL*Loader 1
  • parallel loads 1
    • 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, 2
      • maximum size 1, 2
    • 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
    • export consistency and 1
    • exporting 1
    • importing 1, 2
    • loading 1
  • partitioning a database migration 1, 2
    • advantages of 1, 2
    • disadvantages of 1, 2
    • procedure during export 1, 2
  • partition-level Export 1
    • example session 1
  • partition-level Import 1
    • 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 1
    • 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
    • example 1
  • 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 1
      • 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, 4
    • 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
    • Import 1
  • READSIZE parameter
    • SQL*Loader command line 1
      • 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 1
    • 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
      • Import 1
  • rejected records
    • SQL*Loader 1, 2
  • 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
    • Export/Import 1, 2
  • 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
    • Import 1
  • 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, 3
  • 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
    • Import 1
  • 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, 2
  • 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 1
    • 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
    • Export and Import 1, 2
  • 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
    • Import 1
  • snapshots 1
    • importing 1
    • master table
      • Import 1
    • restoring dropped
      • Import 1
  • 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_CACHE command-line parameter 1
    • DATA command-line parameter 1, 2
    • data conversion 1
    • data definition language
      • syntax diagrams 1
    • data type specifications 1
    • DEGREE_OF_PARALLELISM command-line parameter 1
    • determining default schema 1
    • DIRECT command-line parameter 1
    • direct path method 1
      • auditing 1
      • using the data 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 1
      • 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 1, 2
    • 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 1
      • interactive-command mode 1
    • Data Pump Import utility 1
      • 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
      • Import 1
    • preallocating
      • direct path load 1
    • temporary for a direct path load 1
    • using with Export/Import 1
  • stored functions
    • importing 1
      • effect of COMPILE parameter 1
  • stored package 1
  • stored packages
    • importing 1
  • stored procedures
    • direct path load 1
    • importing 1
      • effect of COMPILE parameter 1
  • stream buffer
    • specifying size for direct path 1
  • stream record format 1
    • 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
    • loading 1
  • subtypes
    • loading multiple 1
  • supplemental logging 1
    • See also: LogMiner utility
    • LogMiner utility 1
      • 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
    • examples 1
  • table names
    • preserving case sensitivity 1
  • TABLE parameter
    • SQL*Loader express mode 1
  • tables 1
    • See also: external tables
    • Advanced Queuing
      • exporting 1
      • importing 1
    • 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
      • Import 1
    • name restrictions
      • Export 1
      • Import 1, 2, 3, 4
    • nested
      • exporting 1
      • importing 1
    • 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, 2
    • metadata
      • transporting 1
    • read-only
      • Import 1
    • reorganizing
      • Import 1
  • 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 1
    • 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
    • trimming 1
  • 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, 2
  • triggers
    • database insert 1
    • logon
      • effect in SQL*Loader 1
    • permanently disabled 1
    • replacing with integrity constraints 1
    • system
      • testing 1
    • 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 1
    • 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 1
    • 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 1
    • querying 1
  • V$SESSION_LONGOPS view
    • monitoring Data Pump jobs with 1
  • VARCHAR2 data type
    • SQL*Loader 1
  • variable-length records
    • external tables 1
  • variable records 1
    • format 1
  • 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
    • Export 1
    • Import 1
  • 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