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 Z
A
- access privileges
-
- Export and Import, 19.2.3
- ADD_FILE parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.1
- Advanced Queuing
-
- exporting advanced queue tables, 19.27.4.10
- importing advanced queue tables, 19.28.5.10
- aliases
-
- directory
-
- exporting, 19.27.4.5
- importing, 19.28.5.5
- analyzer statistics, 19.28.3
- analyzing redo log files, 17
- ANYDATA type
-
- effect on table-mode Import, 19.8
- using SQL strings to load, 9.12.6
- APPEND parameter
-
- SQL*Loader utility, 8.14.2
- append to table
-
- SQL*Loader, 8.13.2.2.1
- archiving
-
- disabling
-
- effect on direct path loads, 11.5.4.1
- arrays
-
- committing after insert, 19.10.2
- ASMCMD
-
- about, 20.1
- command reference, 20.4
- running, 20.3
- ASMCMD utility, 20
- atomic null, 10.1.5.2
- ATTACH parameter
-
- Data Pump Export utility, 2.4.1
- Data Pump Import utility, 3.4.1
- attaching to an existing job
-
- Data Pump Export utility, 2.4.1
- attributes
-
- null, 10.1.5.1
- attribute-value constructors
-
- overriding, 10.1.6
- Automatic Storage Management
-
- command-line utility, 20
- Automatic Storage Management (ASM)
-
- Data Pump and, 1.7.2.1
B
- backslash escape character, 8.3.3.2
- backups
-
- restoring dropped snapshots
-
- Import, 19.18.2.1
- Backus-Naur Form syntax
-
- See syntax diagrams
- bad files
-
- specifying for SQL*Loader, 8.8
- BAD parameter
-
- SQL*Loader command line, 7.2.1
- BADFILE parameter
-
- SQL*Loader utility, 8.8
- BEGINDATA parameter
-
- SQL*Loader control file, 8.6
- BFILE columns
-
- exporting, 19.27.4.6
- importing, 19.28.5.5
- BFILE datatype, 10.5
- big-endian data
-
- external tables, 13.2.7
- bind arrays
-
- determining size of for SQL*Loader, 8.16.4
- minimizing SQL*Loader memory requirements, 8.16.5
- minimum requirements, 8.16.1
- size with multiple SQL*Loader INTO TABLE statements, 8.16.6
- specifying maximum size, 7.2.2
- specifying number of rows, 7.2.22
- SQL*Loader performance implications, 8.16.2
- BINDSIZE parameter
-
- SQL*Loader command line, 7.2.2, 8.16.3
- blanks
-
- loading fields consisting of blanks, 9.9
- SQL*Loader BLANKS parameter for field comparison, 9.5.1
- trailing, 9.4.5.6
- trimming, 9.10
-
- external tables, 13.3.2
- whitespace, 9.10
- BLANKS parameter
-
- SQL*Loader utility, 9.5.1
- BNF
-
- See syntax diagrams
- bound fillers, 9.3.1
- buffer cache size
-
- and Data Pump operations involving Streams, 4.3.1
- BUFFER parameter
-
- Export utility, 19.9.1
- Import utility, 19.10.1
- buffers
-
- calculating for export, 19.9.1
- space required by
-
- VARCHAR data in SQL*Loader, 9.4.1.9
- specifying with SQL*Loader BINDSIZE parameter, 8.16.4
- byte order, 9.8
-
- big-endian, 9.8
- little-endian, 9.8
- specifying in SQL*Loader control file, 9.8.1
- byte order marks, 9.8.2
-
- precedence
-
- for first primary datafile, 9.8.2
- for LOBFILEs and SDFs, 9.8.2
- suppressing checks for, 9.8.2.1
- BYTEINT datatype, 9.4.1.5
- BYTEORDER parameter
-
- SQL*Loader utility, 9.8.1
- BYTEORDERMARK parameter
-
- SQL*Loader utility, 9.8.2.1
C
- cached sequence numbers
-
- Export, 19.27.4.1
- catalog.sql script
-
- preparing database for Export and Import, 19.2.1
- catexp.sql script
-
- preparing database for Export and Import, 19.2.1
- catldr.sql script
-
- preparing for direct path loads, 11.4.1
- changing a database ID, 16.3.1
- changing a database name, 16.3.3
- CHAR datatype
-
- delimited form and SQL*Loader, 9.4.5
- reference
-
- SQL*Loader, 9.4.2.1
- character fields
-
- delimiters and SQL*Loader, 9.4.2, 9.4.5
- determining length for SQL*Loader, 9.4.6
- SQL*Loader datatypes, 9.4.2
- character set conversion
-
- Data Pump Import utility, 1.9
- character sets
-
- conversion
-
- during Export and Import, 19.17.1
- eight-bit to seven-bit conversions
-
- Export/Import, 19.17.3
- identifying for external tables, 13.2.4
- multibyte
-
- Export/Import, 19.17.4
- SQL*Loader, 8.10.1
- single-byte
-
- Export/Import, 19.17.3
- SQL*Loader control file, 8.10.5.3
- SQL*Loader conversion between, 8.10
- Unicode, 8.10.2
- character strings
-
- external tables
-
- specifying bytes or characters, 13.2.9
- SQL*Loader, 9.5.2
- character-length semantics, 8.10.5.4
- CHARACTERSET parameter
-
- SQL*Loader utility, 8.10.5.2
- check constraints
-
- overriding disabling of, 11.8.1.2
- collections, 6.10
-
- loading, 10.6
- column array rows
-
- specifying number of, 11.5.5
- column objects
-
- loading, 10.1
-
- with user-defined constructors, 10.1.6
- COLUMNARRAYROWS parameter
-
- SQL*Loader command line, 7.2.3
- columns
-
- exporting LONG datatypes, 19.27.4.2
- loading REF columns, 10.3
- naming
-
- SQL*Loader, 9.3
- objects
-
- loading nested column objects, 10.1.3
- stream record format, 10.1.1
- variable record format, 10.1.2, 10.1.2
- reordering before Import, 19.6.1
- setting to a constant value with SQL*Loader, 9.13.2
- setting to a unique sequence number with SQL*Loader, 9.13.6
- setting to an expression value with SQL*Loader, 9.13.3
- setting to null with SQL*Loader, 9.13.2.1
- setting to the current date with SQL*Loader, 9.13.5
- setting to the datafile record number with SQL*Loader, 9.13.4
- specifying
-
- SQL*Loader, 9.3
- specifying as PIECED
-
- SQL*Loader, 11.4.7.1
- using SQL*Loader, 9.13.3
- comments
-
- in Export and Import parameter files, 19.3.3
- with external tables, 13.1, 14.1.1
- COMMIT parameter
-
- Import utility, 19.10.2
- COMPILE parameter
-
- Import utility, 19.10.3
- completion messages
-
- Export, 19.14.4
- Import, 19.14.4
- COMPRESS parameter
-
- Export utility, 19.9.2
- compressed data
-
- behavior of Data Pump Import utility, 1.9
- COMPRESSION parameter
-
- Data Pump Export utility, 2.4.2
- CONCATENATE parameter
-
- SQL*Loader utility, 8.12
- concurrent conventional path loads, 11.8.4
- configuration
-
- of LogMiner utility, 17.2.1
- CONSISTENT parameter
-
- Export utility, 19.9.3
-
- nested tables and, 19.9.3
- partitioned table and, 19.9.3
- consolidating
-
- extents, 19.9.2
- CONSTANT parameter
-
- SQL*Loader, 9.13.2
- constraints
-
- automatic integrity and SQL*Loader, 11.8.2.2
- direct path load, 11.8
- disabling referential constraints, 19.6.2
- enabling
-
- after a parallel direct path load, 11.9.7
- enforced on a direct load, 11.8.1.1
- failed
-
- Import, 19.28.1.1.1
- load method, 11.3.8
- CONSTRAINTS parameter
-
- Export utility, 19.9.4
- Import utility, 19.10.4
- constructors
-
- attribute-value, 10.1.6
-
- overriding, 10.1.6
- user-defined, 10.1.6
-
- loading column objects with, 10.1.6
- CONTENT parameter
-
- Data Pump Export utility, 2.4.3
- Data Pump Import utility, 3.4.1
- CONTINUE_CLIENT parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.2
- Data Pump Import utility
-
- interactive-command mode, 3.6.1
- CONTINUEIF parameter
-
- SQL*Loader utility, 8.12
- control files
-
- character sets, 8.10.5.3
- creating
-
- guidelines, 6.3
- data definition language syntax, 8.1
- specifying data, 8.6
- specifying SQL*Loader discard file, 8.9
- CONTROL parameter
-
- SQL*Loader command line, 7.2.4
- conventional path Export
-
- compared to direct path, 19.27.1
- conventional path loads
-
- behavior when discontinued, 8.11.1
- compared to direct path loads, 11.3.7
- concurrent, 11.9.1
- of a single partition, 11.2
- SQL*Loader bind array, 8.16.2
- when to use, 11.2.2
- conversion of character sets
-
- during Export/Import, 19.17.1
- effect of character set sorting on, 19.17.1.1
- conversion of data
-
- during direct path loads, 11.3.1
- conversion of input characters, 8.10.5
- CREATE SESSION privilege
-
- Export, 19.2.3
- Import, 19.2.3
- creating
-
- tables
-
- manually, before import, 19.6.1
D
- data
-
- conversion
-
- direct path load, 11.3.1
- delimiter marks in data and SQL*Loader, 9.4.5.4
- distinguishing different input formats for SQL*Loader, 8.15
- distinguishing different input row object subtypes, 8.15, 8.15.3
- exporting, 19.9.24
- generating unique values with SQL*Loader, 9.13.6
- including in control files, 8.6
- loading data contained in the SQL*Loader control file, 9.13.1
- loading in sections
-
- SQL*Loader, 11.4.7.1
- loading into more than one table
-
- SQL*Loader, 8.15
- maximum length of delimited data for SQL*Loader, 9.4.5.5
- moving between operating systems using SQL*Loader, 9.7
- recovery
-
- SQL*Loader direct path load, 11.4.6
- saving in a direct path load, 11.4.5
- saving rows
-
- SQL*Loader, 11.5.3
- unsorted
-
- SQL*Loader, 11.5.2.2
- values optimized for SQL*Loader performance, 9.13.1
- data fields
-
- specifying the SQL*Loader datatype, 9.3.2
- DATA parameter
-
- SQL*Loader command line, 7.2.5
- Data Pump Export utility
-
- and transparent data encryption, 2.4.6
- ATTACH parameter, 2.4.1
- command-line mode, 2.4, 3.4
- compared to original Export utility, 2.5
- COMPRESSION parameter, 2.4.2
- CONTENT parameter, 2.4.3, 2.4.3
- controlling resource consumption, 4.2.1
- dump file set, 2.1
- DUMPFILE parameter, 2.4.5
- ENCRYPTION_PASSWORD parameter, 2.4.6
- ESTIMATE parameter, 2.4.7
- ESTIMATE_ONLY parameter, 2.4.8
- EXCLUDE parameter, 2.4.9
- excluding objects, 2.4.9
- export modes, 2.2.2
- FILESIZE command
-
- interactive-command mode, 2.6.4
- FILESIZE parameter, 2.4.10
- filtering data that is exported
-
- using EXCLUDE parameter, 2.4.9
- using INCLUDE parameter, 2.4.15
- FLASHBACK_SCN parameter, 2.4.11
- FLASHBACK_TIME parameter, 2.4.12
- FULL parameter, 2.4.13
- HELP parameter
-
- interactive-command mode, 2.6.5
- INCLUDE parameter, 2.4.15
- interactive-command mode, 2.6
-
- ADD_FILE parameter, 2.6.1
- CONTINUE_CLIENT parameter, 2.6.2
- EXIT_CLIENT parameter, 2.6.3
- FILESIZE, 2.6.4
- HELP parameter, 2.6.5
- KILL_JOB parameter, 2.6.6
- PARALLEL parameter, 2.6.7
- START_JOB parameter, 2.6.8
- STATUS parameter, 2.6.9
- STOP_JOB parameter, 2.6.10, 3.6.8
- interfaces, 2.2.1
- invoking
-
- as SYSDBA, 2.2, 3.2
- job names
-
- specifying, 2.4.16
- JOB_NAME parameter, 2.4.16
- LOGFILE parameter, 2.4.17
- NETWORK_LINK parameter, 2.4.18
- NOLOGFILE parameter, 2.4.19
- PARALLEL parameter
-
- command-line mode, 2.4.20
- interactive-command mode, 2.6.7
- PARFILE parameter, 2.4.21
- QUERY parameter, 2.4.22
- SAMPLE parameter, 2.4.23
- SCHEMAS parameter, 2.4.24
- specifying a job name, 2.4.16
- syntax diagrams, 2.8
- TABLES parameter, 2.4.26
- TABLESPACES parameter, 2.4.27
- TRANSPORT_FULL_CHECK parameter, 2.4.28
- TRANSPORT_TABLESPACES parameter, 2.4.29
- VERSION parameter, 2.4.30
- versioning, 1.8
- Data Pump Import utility
-
- and transparent data encryption, 3.4.5
- ATTACH parameter, 3.4.1
- attaching to an existing job, 3.4.1
- changing name of source datafile, 3.4.20
- character set conversion, 1.9
- command-line mode
-
- NOLOGFILE parameter, 3.4.16
- STATUS parameter, 3.4.27
- compared to original Import utility, 3.5
- CONTENT parameter, 3.4.2
- controlling resource consumption, 4.2.1
- data compression, 1.9
- data filters, 3.3.1
- DIRECTORY parameter, 3.4.3
- DUMPFILE parameter, 3.4.4
- ENCRYPTION_PASSWORD parameter, 3.4.5
- ESTIMATE parameter, 3.4.6
- estimating size of job, 3.4.6
- EXCLUDE parameter, 3.4.7
- filtering data that is imported
-
- using EXCLUDE parameter, 3.4.7
- using INCLUDE parameter, 3.4.12
- FLASHBACK_SCN parameter, 3.4.8
- FLASHBACK_TIME parameter, 3.4.9
- full import mode, 3.2.2.1
- FULL parameter, 3.4.10
- HELP parameter
-
- command-line mode, 3.4.11
- interactive-command mode, 3.6.3
- importing entire source, 3.4.10
- INCLUDE parameter, 3.4.12
- interactive-command mode, 3.6
-
- CONTINUE_CLIENT parameter, 3.6.1
- EXIT_CLIENT parameter, 3.6.2
- HELP parameter, 3.6.3
- KILL_JOB parameter, 3.6.4
- START_JOB parameter, 3.6.6
- STATUS parameter, 3.4.27, 3.6.7
- STOP_JOB parameter, 3.6.8
- interfaces, 3.2.1
- JOB_NAME parameter, 3.4.13
- LOGFILE parameter, 3.4.14
- network mode
-
- enabling, 3.4.15
- NETWORK_LINK parameter, 3.4.15
- PARALLEL parameter
-
- command-line mode, 3.4.17
- interactive-command mode, 3.6.5
- PARFILE parameter, 3.4.18
- QUERY parameter, 3.4.19
- REMAP_DATAFILE parameter, 3.4.20
- REMAP_SCHEMA parameter, 3.4.21
- REMAP_TABLESPACE parameter, 3.4.22
- REUSE_DATAFILES parameter, 3.4.23
- schema mode, 3.2.2.2
- SCHEMAS parameter, 3.4.24
- SKIP_UNUSABLE_INDEXES parameter, 3.4.25
- specifying a job name, 3.4.13
- specifying dump file set to import, 3.4.4
- SQLFILE parameter, 3.4.26
- STREAMS_CONFIGURATION parameter, 3.4.28
- syntax diagrams, 3.8
- table mode, 3.2.2.3
- TABLE_EXISTS_ACTION parameter, 3.4.29
- TABLES parameter, 3.4.30
- tablespace mode, 3.2.2.4
- TABLESPACES parameter, 3.4.31
- TRANSFORM parameter, 3.4.32
- TRANSPORT_DATAFILES parameter, 3.4.33
- TRANSPORT_FULL_CHECK parameter, 3.4.34
- TRANSPORT_TABLESPACES parameter, 2.4.29, 3.4.35
- transportable tablespace mode, 3.2.2.5
- VERSION parameter, 3.4.36
- versioning, 1.8
- database ID (DBID)
-
- changing, 16.3.1
- database identifier
-
- changing, 16.3.1
- database migration
-
- partitioning of, 19.29
- database name (DBNAME)
-
- changing, 16.3.3
- database objects
-
- exporting LONG columns, 19.27.4.2
- databases
-
- changing the database ID, 16.3.1
- changing the name, 16.3.3
- exporting entire, 19.9.11
- full import, 19.10.11
- moving between platforms, 19.13
- privileges for exporting and importing, 19.2.3
- reducing fragmentation, 19.25
- reusing existing datafiles
-
- Import, 19.10.6
- datafiles
-
- preventing overwrite during import, 19.10.6
- reusing during import, 19.10.6
- specifying, 7.2.5
- specifying buffering for SQL*Loader, 8.7
- specifying for SQL*Loader, 8.5
- specifying format for SQL*Loader, 8.7
- DATAFILES parameter
-
- Import utility, 19.10.5
- datatypes
-
- BFILE
-
- Export, 19.27.4.6
- Import, 19.28.5.5
- BYTEINT, 9.4.1.5
- CHAR, 9.4.2.1
- converting SQL*Loader, 9.4.3
- DATE, 9.4.2.2.1
- datetime, 9.4.2.2
- DECIMAL, 9.4.1.7
- default in SQL*Loader, 9.3.2
- describing for external table fields, 13.3.6
- determining character field lengths for SQL*Loader, 9.4.6
- determining DATE length, 9.4.6.3
- DOUBLE, 9.4.1.4
- FLOAT, 9.4.1.3
- GRAPHIC, 9.4.2.3
- GRAPHIC EXTERNAL, 9.4.2.4
- identifying for external tables, 13.3.4
- INTEGER (n), 9.4.1.1
- interval, 9.4.2.2
- length-value, 9.4, 9.4
- LONG
-
- Export, 19.27.4.2
- Import, 19.28.5.11, 19.28.5.11
- LONG VARRAW, 9.4.1.11
- native
-
- conflicting length specifications in SQL*Loader, 9.4.2.9
- nonportable, 9.4.1
- nonscalar, 10.1.5
- NUMBER
-
- SQL*Loader, 9.4.3, 9.4.4
- numeric EXTERNAL, 9.4.2.5
- portable, 9.4.2
- RAW, 9.4.2.6
- SMALLINT, 9.4.1.2
- specifying the SQL*Loader datatype of a data field, 9.3.2
- supported by the LogMiner utility, 17.13.1
- unsupported by LogMiner utility, 17.13.2
- value, 9.4, 9.4
- VARCHAR, 9.4.1.9
- VARCHAR2
-
- SQL*Loader, 9.4.3
- VARCHARC, 9.4.2.7
- VARGRAPHIC, 9.4.1.8
- VARRAW, 9.4.1.10
- VARRAWC, 9.4.2.8
- ZONED, 9.4.1.6
- date cache feature
-
- DATE_CACHE parameter, 7.2.6
- external tables, 12.5.1
- SQL*Loader, 11.5.6
- DATE datatype
-
- delimited form and SQL*Loader, 9.4.5
- determining length, 9.4.6.3
- mask
-
- SQL*Loader, 9.4.6.3
- SQL*Loader, 9.4.2.2.1
- DATE_CACHE parameter
-
- SQL*Loader utility, 7.2.6
- datetime datatypes, 9.4.2.2
- DBID (database identifier)
-
- changing, 16.3.1
- DBMS_DATAPUMP PL/SQL package, 5
- DBMS_LOGMNR PL/SQL procedure
-
- LogMiner utility and, 17.2.2
- DBMS_LOGMNR_D PL/SQL procedure
-
- LogMiner utility and, 17.2.2
- DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure
-
- LogMiner utility and, 17.2.2
- DBMS_LOGMNR_D.BUILD PL/SQL procedure
-
- LogMiner utility and, 17.2.2
- DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure
-
- LogMiner utility and, 17.2.2
- DBMS_LOGMNR.ADD_LOGFILE PL/SQL procedure
-
- ADDFILE option, 17.3.2
- NEW option, 17.3.2
- DBMS_LOGMNR.COLUMN_PRESENT function, 17.5.2
- DBMS_LOGMNR.MINE_VALUE function, 17.5.2
-
- null values and, 17.5.2.1
- DBMS_LOGMNR.START_LOGMNR PL/SQL procedure, 17.4
-
- calling multiple times, 17.8
- COMMITTED_DATA_ONLY option, 17.6.1
- CONTINUOUS_MINE option, 17.3.2
- ENDTIME parameter, 17.6.3, 17.6.4
- LogMiner utility and, 17.2.2
- options for, 17.4
- PRINT_PRETTY_SQL option, 17.6.6
- SKIP_CORRUPTION option, 17.6.2
- STARTTIME parameter, 17.6.3, 17.6.4
- DBMS_METADATA PL/SQL package, 18.3.1
- DBNAME
-
- changing, 16.3.3
- DBNEWID utility, 16
-
- changing a database ID, 16.3.1
- changing a database name, 16.3.3
- effect on global database names, 16.2.1
- restrictions, 16.4.2
- syntax, 16.4
- troubleshooting a database ID change, 16.3.4
- DBVERIFY utility
-
- output, 15.1.4
- restrictions, 15
- syntax, 15.1.1
- validating a segment, 15.2
- validating disk blocks, 15.1
- DECIMAL datatype, 9.4.1.7
-
- EXTERNAL format
-
- SQL*Loader, 9.4.2.5
- default schema
-
- as determined by SQL*Loader, 8.13.1.1
- DEFAULTIF parameter
-
- SQL*Loader, 9.5
- DELETE ANY TABLE privilege
-
- SQL*Loader, 8.13.2.2.4
- DELETE CASCADE
-
- effect on loading nonempty tables, 8.13.2.2.2
- SQL*Loader, 8.13.2.2.4
- DELETE privilege
-
- SQL*Loader, 8.13.2.2.2
- delimited data
-
- maximum length for SQL*Loader, 9.4.5.5
- delimited fields
-
- field length, 9.4.6.2
- delimited LOBs, 10.4.2.2.3
- delimiters
-
- in external tables, 13.2.3
- loading trailing blanks, 9.4.5.6
- marks in data and SQL*Loader, 9.4.5.4
- specifying for external tables, 13.3.1
- specifying for SQL*Loader, 8.13.5, 9.4.5
- SQL*Loader enclosure, 9.10.2.2
- SQL*Loader field specifications, 9.10.2.2
- termination, 9.10.2.2
- DESTROY parameter
-
- Import utility, 19.10.6
- dictionary
-
- requirements for LogMiner utility, 17.2.1.2
- dictionary version mismatch, 17.9.4
- DIRECT parameter
-
- Export utility, 19.9.5
- direct path Export, 19.27.1, 19.27.2
-
- compared to conventional path, 19.27.1
- effect of EXEMPT ACCESS POLICY privilege, 19.27.2.1
- performance issues, 19.27.2.2
- restrictions, 19.27.2.3
- security considerations, 19.27.2.1
- direct path load
-
- advantages, 11.3.4
- behavior when discontinued, 8.11.2
- choosing sort order
-
- SQL*Loader, 11.5.2.4
- compared to conventional path load, 11.3.7
- concurrent, 11.9.3, 11.9.3
- conditions for use, 11.3.5
- data saves, 11.4.5, 11.5.3
- DIRECT command-line parameter
-
- SQL*Loader, 11.4.2
- dropping indexes, 11.7
- effect of disabling archiving, 11.5.4
- effect of PRIMARY KEY constraints, 11.9.8
- effect of UNIQUE KEY constraints, 11.9.8
- field defaults, 11.3.9
- improper sorting
-
- SQL*Loader, 11.5.2.2
- indexes, 11.4.3
- instance recovery, 11.4.6
- intersegment concurrency, 11.9.3
- intrasegment concurrency, 11.9.3
- loading into synonyms, 11.3.10
- location of data conversion, 11.3.1
- media recovery, 11.4.6.1, 11.4.6.1
- optimizing on multiple-CPU systems, 11.6
- partitioned load
-
- SQL*Loader, 11.8.4
- performance, 11.4.3, 11.5
- preallocating storage, 11.5.1
- presorting data, 11.5.2
- recovery, 11.4.6
- ROWS command-line parameter, 11.4.5.1
- setting up, 11.4.1
- specifying, 11.4.2
- specifying number of rows to be read, 7.2.22
- SQL*Loader data loading method, 6.9.2
- table insert triggers, 11.8.2
- temporary segment storage requirements, 11.4.3.2
- triggers, 11.8
- using, 11.3.7, 11.4
- version requirements, 11.3.5
- directory aliases
-
- exporting, 19.27.4.5
- importing, 19.28.5.5
- directory objects
-
- Data Pump
-
- effect of automatic storage management, 1.7.2.1
- using with Data Pump, 1.7.2.1
- DIRECTORY parameter
-
- Data Pump Export utility, 2.4.4
- Data Pump Import utility, 3.4.3
- discard files
-
- SQL*Loader, 8.9
-
- specifying a maximum, 8.9.2
- DISCARD parameter
-
- SQL*Loader command-line, 7.2.8
- discarded SQL*Loader records, 6.7
-
- causes, 8.9.4
- discard file, 8.9
- limiting, 8.9.6
- DISCARDMAX parameter
-
- SQL*Loader command-line, 7.2.9
- discontinued loads, 8.11
-
- continuing, 8.11.5
- conventional path behavior, 8.11.1
- direct path behavior, 8.11.2
- DOUBLE datatype, 9.4.1.4
- dropped snapshots
-
- Import, 19.18.2.1
- dump files
-
- maximum size, 19.9.8
- DUMPFILE parameter
-
- Data Pump Export utility, 2.4.5
- Data Pump Import utility, 3.4.4
E
- EBCDIC character set
-
- Import, 19.17.3
- eight-bit character set support, 19.17.3
- enclosed fields
-
- specified with enclosure delimiters and SQL*Loader, 9.4.5.2
- whitespace, 9.10.6
- enclosure delimiters, 9.4.5
-
- SQL*Loader, 9.4.5.2, 9.10.2.2
- encrypted columns
-
- in external tables, 14.1.4
- ENCRYPTION_PASSWORD parameter
-
- Data Pump Export utility, 2.4.6
- Data Pump Import utility, 3.4.5
- errors
-
- caused by tab characters in SQL*Loader data, 9.2.1
- LONG data, 19.28.1.1.2
- object creation, 19.28.1.2.1
-
- Import parameter IGNORE, 19.10.14
- resource errors on import, 19.28.1.2.3
- row errors during import, 19.28.1.1
- writing to export log file, 19.9.15
- ERRORS parameter
-
- SQL*Loader command line, 7.2.10
- escape character
-
- quoted strings and, 8.3.3.2
- usage in Data Pump Export, 2.4
- usage in Data Pump Import, 3.4
- usage in Export, 19.9.26.1
- usage in Import, 19.10.29
- ESTIMATE parameter
-
- Data Pump Export utility, 2.4.7
- Data Pump Import utility, 3.4.6
- ESTIMATE_ONLY parameter
-
- Data Pump Export utility, 2.4.8
- estimating size of job
-
- Data Pump Export utility, 2.4.7
- EVALUATE CHECK_CONSTRAINTS clause, 11.8.1.2
- EXCLUDE parameter
-
- Data Pump Export utility, 2.4.9
- Data Pump Import utility, 3.4.7
- exit codes
-
- Export and Import, 19.15
- SQL*Loader, 7.3
- EXIT_CLIENT parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.3
- Data Pump Import utility
-
- interactive-command mode, 3.6.2
- EXP_FULL_DATABASE role
-
- assigning in Export, 19.2.1
- expdat.dmp
-
- Export output file, 19.9.7
- Export
-
- BUFFER parameter, 19.9.1
- character set conversion, 19.17.1
- COMPRESS parameter, 19.9.2
- CONSISTENT parameter, 19.9.3
- CONSTRAINTS parameter, 19.9.4
- conventional path, 19.27.1
- creating
-
- necessary privileges, 19.2.1
- necessary views, 19.2.1
- database optimizer statistics, 19.9.25
- DIRECT parameter, 19.9.5
- direct path, 19.27.1
- displaying online help, 19.9.13
- example sessions, 19.11
-
- full database mode, 19.11.1
- partition-level, 19.11.4
- table mode, 19.11.3
- user mode, 19.9.17, 19.11.2
- exit codes, 19.15
- exporting an entire database, 19.9.11
- exporting indexes, 19.9.14
- exporting sequence numbers, 19.27.4.1
- exporting synonyms, 19.27.4.11
- exporting to another operating system, 19.9.20, 19.10.19
- FEEDBACK parameter, 19.9.6
- FILE parameter, 19.9.7
- FILESIZE parameter, 19.9.8
- FLASHBACK_SCN parameter, 19.9.9
- FLASHBACK_TIME parameter, 19.9.10
- full database mode
-
- example, 19.11.1
- FULL parameter, 19.9.11
- GRANTS parameter, 19.9.12
- HELP parameter, 19.9.13
- INDEXES parameter, 19.9.14
- invoking, 19.3
- log files
-
- specifying, 19.9.15
- LOG parameter, 19.9.15
- logging error messages, 19.9.15
- LONG columns, 19.27.4.2
- OBJECT_CONSISTENT parameter, 19.9.16
- online help, 19.3.5
- OWNER parameter, 19.9.17
- parameter file, 19.9.18
-
- maximum size, 19.3.3
- parameter syntax, 19.9
- PARFILE parameter, 19.9.18
- partitioning a database migration, 19.29
- QUERY parameter, 19.9.19
- RECORDLENGTH parameter, 19.9.20
- redirecting output to a log file, 19.14.1
- remote operation, 19.16.2
- restrictions based on privileges, 19.2.3
- RESUMABLE parameter, 19.9.21
- RESUMABLE_NAME parameter, 19.9.22
- RESUMABLE_TIMEOUT parameter, 19.9.23
- ROWS parameter, 19.9.24
- sequence numbers, 19.27.4.1
- STATISTICS parameter, 19.9.25
- storage requirements, 19.2.2
- table mode
-
- example session, 19.11.3
- table name restrictions, 19.9.26.1
- TABLES parameter, 19.9.26
- TABLESPACES parameter, 19.9.27
- TRANSPORT_TABLESPACE parameter, 19.9.28
- TRIGGERS parameter, 19.9.29
- TTS_FULL_CHECK parameter, 19.9.30
- user access privileges, 19.2.3
- user mode
-
- example session, 19.9.17, 19.11.2
- specifying, 19.9.17
- USERID parameter, 19.9.31
- VOLSIZE parameter, 19.9.32
- export dump file
-
- importing the entire file, 19.10.11
- export file
-
- listing contents before importing, 19.10.24
- specifying, 19.9.7
- EXPRESSION parameter
-
- SQL*Loader, 9.13.3, 9.13.3.1
- extents
-
- consolidating, 19.9.2
- importing consolidated, 19.26.4
- external files
-
- exporting, 19.27.4.6
- EXTERNAL parameter
-
- SQL*Loader, 9.4.2.5
- EXTERNAL SQL*Loader datatypes, 9.4.2.5
-
- DECIMAL, 9.4.2.5
- FLOAT, 9.4.2.5
- GRAPHIC, 9.4.2.4
- numeric, 9.4.2.5
-
- determining len, 9.4.6
- ZONED, 9.4.2.5
- external tables
-
- and encrypted columns, 14.1.4
- big-endian data, 13.2.7
- column_transforms clause, 13.1
- datatypes, 13.3.6
- date cache feature, 12.5.1
- delimiters, 13.2.3
- describing datatype of a field, 13.3.6
- differences in load behavior from SQL*Loader, 12.7
- field_definitions clause, 13.1, 13.3
- fixed-length records, 13.2.1
- identifying character sets, 13.2.4
- identifying datatypes, 13.3.4
- improving performance when using, 12.5
-
- date cache feature, 12.5.1
- little-endian data, 13.2.7
- record_format_info clause, 13.1, 13.2
- reserved words, 12.6
- restrictions, 12.6
- setting a field to a default value, 13.3.7
- setting a field to null, 13.3.7
- skipping records when loading data, 13.2.14
- specifying delimiters, 13.3.1
- specifying load conditions, 13.2.10
- trimming blanks, 13.3.2
- using comments, 13.1, 14.1.1
- using constructor functions with, 12.2.3
- using to load data, 12.2
- variable-length records, 13.2.2
- EXTERNAL_TABLE parameter
-
- SQL*Loader, 7.2.11
F
- fatal errors
-
- See nonrecoverable error messages
- FEEDBACK parameter
-
- Export utility, 19.9.6
- Import utility, 19.10.7
- field conditions
-
- specifying for SQL*Loader, 9.5
- field length
-
- SQL*Loader specifications, 9.10.2
- field location
-
- SQL*Loader, 9.2
- fields
-
- character data length and SQL*Loader, 9.4.6
- comparing to literals with SQL*Loader, 9.5.2
- delimited
-
- determining length, 9.4.6.2
- SQL*Loader, 9.4.5
- enclosed and SQL*Loader, 9.4.5.2
- loading all blanks, 9.9
- predetermined size
-
- length, 9.4.6.1
- SQL*Loader, 9.10.2.1
- relative positioning and SQL*Loader, 9.10.3
- specified with a termination delimiter and SQL*Loader, 9.4.5.1
- specified with enclosure delimiters and SQL*Loader, 9.4.5.2
- specifying default delimiters for SQL*Loader, 8.13.5
- specifying for SQL*Loader, 9.3
- SQL*Loader delimited
-
- specifications, 9.10.2.2
- terminated and SQL*Loader, 9.4.5.1
- FIELDS clause
-
- SQL*Loader, 8.13.5
- terminated by whitespace, 9.10.4.1
- FILE parameter
-
- Export utility, 19.9.7
- Import utility, 19.10.8
- SQL*Loader utility, 11.9.6.1
- filenames
-
- quotation marks and, 8.3.3.1
- specifying multiple SQL*Loader, 8.5.2
- SQL*Loader, 8.3
- SQL*Loader bad file, 8.8
- FILESIZE parameter
-
- Data Pump Export utility, 2.4.10
- Export utility, 19.9.8
- Import utility, 19.10.9
- FILLER field
-
- using as argument to init_spec, 9.3.1
- filtering data
-
- using Data Pump Export utility, 2.1
- using Data Pump Import utility, 3.1
- filtering metadata that is imported
-
- Data Pump Import utility, 3.4.7
- fine-grained access support
-
- Export and Import, 19.23
- fixed-format records, 6.4.1
- fixed-length records
-
- external tables, 13.2.1
- FLASHBACK_SCN parameter
-
- Data Pump Export utility, 2.4.11
- Data Pump Import utility, 3.4.8
- Export utility, 19.9.9
- FLASHBACK_TIME parameter
-
- Data Pump Export utility, 2.4.12
- Data Pump Import utility, 3.4.9
- Export utility, 19.9.10
- FLOAT datatype, 9.4.1.3
-
- EXTERNAL format
-
- SQL*Loader, 9.4.2.5
- FLOAT EXTERNAL data values
-
- SQL*Loader, 9.4.2.5
- foreign function libraries
-
- exporting, 19.27.4.3
- importing, 19.28.5.6, 19.28.5.9
- formats
-
- SQL*Loader input records and, 8.15.2
- formatting errors
-
- SQL*Loader, 8.8
- fragmentation
-
- reducing, 19.25
- FROMUSER parameter
-
- Import utility, 19.10.10
- full database mode
-
- Import, 19.10.11
- specifying with FULL, 19.9.11
- full export mode
-
- Data Pump Export utility, 2.2.2.1
- FULL parameter
-
- Data Pump Export utility, 2.4.13
- Data Pump Import utility, 3.4.10
- Export utility, 19.9.11
- Import utility, 19.10.11
G
- globalization
-
- SQL*Loader, 8.10
- grants
-
- exporting, 19.9.12
- importing, 19.4.1, 19.10.12
- GRANTS parameter
-
- Export utility, 19.9.12
- Import utility, 19.10.12
- GRAPHIC datatype
-
- EXTERNAL format in SQL*Loader, 9.4.2.4
H
- HELP parameter
-
- Data Pump Export utility
-
- command-line mode, 2.4.14
- interactive-command mode, 2.6.5
- Data Pump Import utility
-
- command-line mode, 3.4.11
- interactive-command mode, 3.6.3
- Export utility, 19.9.13
- Import utility, 19.10.13
- hexadecimal strings
-
- SQL*Loader, 9.5.2
I
- IGNORE parameter
-
- Import utility, 19.10.14
- IMP_FULL_DATABASE role
-
- assigning in Import, 19.2.1
- Import
-
- BUFFER parameter, 19.10.1
- character set conversion, 19.17.1, 19.17.3
- COMMIT parameter, 19.10.2
- committing after array insert, 19.10.2
- COMPILE parameter, 19.10.3
- consolidated extents, 19.26.4
- CONSTRAINTS parameter, 19.10.4
- creating
-
- necessary privileges, 19.2.1
- necessary views, 19.2.1
- creating an index-creation SQL script, 19.10.16
- database optimizer statistics, 19.10.26
- DATAFILES parameter, 19.10.5
- DESTROY parameter, 19.10.6
- disabling referential constraints, 19.6.2, 19.6.2
- displaying online help, 19.10.13
- dropping a tablespace, 19.21
- errors importing database objects, 19.28.1.2
- example sessions, 19.12
-
- all tables from one user to another, 19.12.3
- selected tables for specific user, 19.12.1
- tables exported by another user, 19.12.2
- using partition-level Import, 19.12.4
- exit codes, 19.15
- export file
-
- importing the entire file, 19.10.11
- listing contents before import, 19.10.24
- failed integrity constraints, 19.28.1.1.1
- FEEDBACK parameter, 19.10.7
- FILE parameter, 19.10.8
- FILESIZE parameter, 19.10.9
- FROMUSER parameter, 19.10.10
- FULL parameter, 19.10.11
- grants
-
- specifying for import, 19.10.12
- GRANTS parameter, 19.10.12
- HELP parameter, 19.10.13
- IGNORE parameter, 19.10.14
- importing grants, 19.10.12
- importing objects into other schemas, 19.4.2
- importing rows, 19.10.23
- importing tables, 19.10.29
- INDEXES parameter, 19.10.15
- INDEXFILE parameter, 19.10.16
- INSERT errors, 19.28.1.1.2
- invalid data, 19.28.1.1.2
- invoking, 19.3
- LOG parameter, 19.10.17
- LONG columns, 19.28.5.11, 19.28.5.11
- manually creating tables before import, 19.6.1
- manually ordering tables, 19.6.3
- NLS_LANG environment variable, 19.17.3
- object creation errors, 19.10.14
- online help, 19.3.5
- parameter file, 19.10.18
-
- maximum size, 19.3.3
- parameter syntax, 19.10
- PARFILE parameter, 19.10.18
- partition-level, 19.8.2
- pattern matching of table names, 19.10.29
- preserving size of initial extent, 19.26.4
- read-only tablespaces, 19.20
- RECORDLENGTH parameter, 19.10.19
- records
-
- specifying length, 19.10.19
- redirecting output to a log file, 19.14.1
- reducing database fragmentation, 19.25
- refresh error, 19.18.1
- remote operation, 19.16.2
- reorganizing tablespace during, 19.22
- resource errors, 19.28.1.2.3
- restrictions
-
- importing into own schema, 19.4
- RESUMABLE parameter, 19.10.20
- RESUMABLE_NAME parameter, 19.10.21
- RESUMABLE_TIMEOUT parameter, 19.10.22
- reusing existing datafiles, 19.10.6
- rows
-
- specifying for import, 19.10.23
- ROWS parameter, 19.10.23
- schema objects, 19.4.2
- sequences, 19.28.1.2.2
- SHOW parameter, 19.10.24
- single-byte character sets, 19.17.3
- SKIP_UNUSABLE_INDEXES parameter, 19.10.25
- snapshot master table, 19.18.1
- snapshots, 19.18
-
- restoring dropped, 19.18.2.1
- specifying by user, 19.10.10
- specifying index creation commands, 19.10.16
- specifying the export file, 19.10.8
- STATISTICS parameter, 19.10.26
- storage parameters
-
- overriding, 19.26.3
- stored functions, 19.28.5.7
- stored procedures, 19.28.5.7
- STREAMS_CONFIGURATION parameter, 19.10.27
- STREAMS_INSTANTIATION parameter, 19.10.28
- system objects, 19.4.3
- table name restrictions, 19.10.29.1
- table objects
-
- import order, 19.5
- table-level, 19.8.2
- TABLES parameter, 19.10.29
- TABLESPACES parameter, 19.10.30
- TOID_NOVALIDATE parameter, 19.10.31
- TOUSER parameter, 19.10.32
- TRANSPORT_TABLESPACE parameter, 19.10.33
- TTS_OWNER parameter, 19.10.34
- tuning considerations, 19.28.4
- types of errors during, 19.28.1
- user access privileges, 19.2.3
- USERID parameter, 19.10.35
- VOLSIZE parameter, 19.10.36
- INCLUDE parameter
-
- Data Pump Export utility, 2.4.15
- Data Pump Import utility, 3.4.12
- index options
-
- SORTED INDEXES with SQL*Loader, 8.14.1
- SQL*Loader SINGLEROW parameter, 8.14.2
- Index Unusable state
-
- indexes left in Index Unusable state, 8.11.3, 11.4.4
- indexes
-
- creating manually, 19.10.16
- direct path load
-
- left in direct load state, 11.4.4
- dropping
-
- SQL*Loader, 11.7
- estimating storage requirements, 11.4.3.1
- exporting, 19.9.14
- importing, 19.10.15
- index-creation commands
-
- Import, 19.10.16
- left in unusable state, 8.11.3, 11.5.2.2
- multiple-column
-
- SQL*Loader, 11.5.2.3
- presorting data
-
- SQL*Loader, 11.5.2
- skipping maintenance, 7.2.25, 11.7
- skipping unusable, 7.2.26, 11.7
- SQL*Loader, 8.14
- state after discontinued load, 8.11.3
- unique, 19.10.15
- INDEXES parameter
-
- Export utility, 19.9.14
- Import utility, 19.10.15
- INDEXFILE parameter
-
- Import utility, 19.10.16
- INFILE parameter
-
- SQL*Loader utility, 8.5
- insert errors
-
- Import, 19.28.1.1.2
- specifying, 7.2.10
- INSERT into table
-
- SQL*Loader, 8.13.2.1.1
- instance affinity
-
- Export and Import, 19.24
- instance recovery, 11.4.6.2
- INTEGER datatype, 9.4.1.1
-
- EXTERNAL format, 9.4.2.5
- integrity constraints
-
- disabled during direct path load, 11.8.1.2
- enabled during direct path load, 11.8.1.1
- failed on Import, 19.28.1.1.1
- load method, 11.3.8
- interactive method
-
- Data Pump Export utility, 2.2.1
- original Export and Import, 19.3.4
- internal LOBs
-
- loading, 10.4.1
- interrupted loads, 8.11
- interval datatypes, 9.4.2.2
- INTO TABLE statement
-
- effect on bind array size, 8.16.6
- multiple statements with SQL*Loader, 8.15
- SQL*Loader, 8.13
-
- column names, 9.3
- discards, 8.9.4
- invalid data
-
- Import, 19.28.1.1.2
- invoking
-
- Export, 19.3
-
- at the command line, 19.3.2
- direct path, 19.27.2
- interactively, 19.3.4
- with a parameter file, 19.3.3
- Import, 19.3
-
- as SYSDBA, 19.3.1
- at the command line, 19.3.2
- interactively, 19.3.4
- with a parameter file, 19.3.3
J
- JOB_NAME parameter
-
- Data Pump Export utility, 2.4.16
- Data Pump Import utility, 3.4.13
K
- key values
-
- generating with SQL*Loader, 9.13.6
- KILL_JOB parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.6
- Data Pump Import utility, 3.6.4
L
- leading whitespace
-
- definition, 9.10.1
- trimming and SQL*Loader, 9.10.4
- length indicator
-
- determining size, 8.16.4.1
- length subfield
-
- VARCHAR DATA
-
- SQL*Loader, 9.4.1.9
- length-value datatypes, 9.4, 9.4
- length-value pair specified LOBs, 10.4.2.2.4
- libraries
-
- foreign function
-
- exporting, 19.27.4.3
- importing, 19.28.5.6, 19.28.5.9
- little-endian data
-
- external tables, 13.2.7
- LOAD parameter
-
- SQL*Loader command line, 7.2.13
- loading
-
- collections, 10.6
- column objects, 10.1
-
- in variable record format, 10.1.2
- with a derived subtype, 10.1.4
- with user-defined constructors, 10.1.6
- datafiles containing tabs
-
- SQL*Loader, 9.2.1
- external table data
-
- skipping records, 13.2.14
- specifying conditions, 13.2.7, 13.2.18
- into LONG RAW columns, 9.4.3
- LOBs, 10.4
- nested column objects, 10.1.3
- object tables, 10.2
- object tables with a subtype, 10.2.1
- REF columns, 10.3
- subpartitioned tables, 11.3.2
- tables, 11.3.2
- XML columns, 10.4
- LOB data, 6.5
-
- compression during export, 19.9.2
- Export, 19.27.4.2
- in delimited fields, 10.4.1.2
- in length-value pair fields, 10.4.1.3
- in predetermined size fields, 10.4.1.1
- LOB read buffer
-
- size of, 7.2.18
- LOBFILEs, 6.5, 10.4, 10.4.2
- LOBs
-
- loading, 10.4
- log files
-
- after a discontinued load, 8.11.4
- Export, 19.9.15, 19.14.1
- Import, 19.10.17, 19.14.1
- specifying for SQL*Loader, 7.2.14
- SQL*Loader, 6.8
- LOG parameter
-
- Export utility, 19.9.15
- Import utility, 19.10.17
- SQL*Loader command line, 7.2.14
- LOGFILE parameter
-
- Data Pump Export utility, 2.4.17
- Data Pump Import utility, 3.4.14
- logical records
-
- consolidating multiple physical records using SQL*Loader, 8.12
- LogMiner utility
-
- accessing redo data of interest, 17.5
- adjusting redo log file list, 17.8
- analyzing output, 17.5.1
- configuration, 17.2.1
- considerations for reapplying DDL statements, 17.7
- current log file list
-
- stored information about, 17.10.1
- DBMS_LOGMNR PL/SQL procedure and, 17.2.2
- DBMS_LOGMNR_D PL/SQL procedure and, 17.2.2
- DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and, 17.2.2
- DBMS_LOGMNR_D.BUILD PL/SQL procedure and, 17.2.2
- DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and, 17.2.2
- DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and, 17.2.2
- DDL tracking
-
- time or SCN ranges, 17.9.6
- determining redo log files being analyzed, 17.3.2
- dictionary
-
- purpose of, 17.2.1
- dictionary extracted to flat file
-
- stored information about, 17.10
- dictionary options, 17.3.1
-
- flat file and, 17.3.1
- online catalog and, 17.3.1
- redo log files and, 17.3.1
- ending a session, 17.11.6
- executing reconstructed SQL, 17.6.5
- extracting data values from redo logs, 17.5.2
- filtering data by SCN, 17.6.4
- filtering data by time, 17.6.3
- formatting returned data, 17.6.6
- graphical user interface, 17
- levels of supplemental logging, 17.9
- LogMiner dictionary defined, 17.2.1
- mining a subset of data in redo log files, 17.8
- mining database definition for, 17.2.1
- operations overview, 17.2.2
- parameters
-
- stored information about, 17.10
- redo log files
-
- on a remote database, 17.8
- stored information about, 17.10
- requirements for dictionary, 17.2.1.2
- requirements for redo log files, 17.2.1.2
- requirements for source and mining databases, 17.2.1.2
- sample configuration, 17.2.1.1
- showing committed transactions only, 17.6.1
- skipping corruptions, 17.6.2
- source database definition for, 17.2.1
- specifying redo log files to mine, 17.3.2
-
- automatically, 17.3.2
- manually, 17.3.2
- specifying redo logs for analysis, 17.11.3
- starting, 17.4, 17.11.4
- starting multiple times within a session, 17.8
- steps for extracting dictionary to a flat file, 17.3.1.3
- steps for extracting dictionary to redo log files, 17.3.1.2
- steps for using dictionary in online catalog, 17.3.1.1
- steps in a typical session, 17.11
- supplemental log groups, 17.9
-
- conditional, 17.9
- unconditional, 17.9
- supplemental logging, 17.9
-
- database level, 17.9.1
- database-level identification keys, 17.9.1.2
- disabling database-level, 17.9.2
- interactions with DDL tracking, 17.9.5
- log groups, 17.9
- minimal, 17.9.1.1
- stored information about, 17.10
- table-level identification keys, 17.9.3.1
- table-level log groups, 17.9.3.2
- user-defined log groups, 17.9.3.3
- supported database versions, 17.13.3
- supported datatypes, 17.13.1
- supported redo log file versions, 17.13.3
- suppressing delimiters in SQL_REDO and SQL_UNDO, 17.6.5
- table-level supplemental logging, 17.9.3
- tracking DDL statements, 17.9.4
-
- requirements, 17.9.4
- unsupported datatypes, 17.13.2
- using the online catalog, 17.3.1.1
- using to analyze redo log files, 17
- V$DATABASE view, 17.10
- V$LOGMNR_CONTENTS view, 17.2.2, 17.5.1, 17.6
- V$LOGMNR_DICTIONARY view, 17.10
- V$LOGMNR_LOGS view, 17.10
-
- querying, 17.10.1
- V$LOGMNR_PARAMETERS view, 17.9.6, 17.10
- views, 17.10
- LogMiner Viewer, 17
- LONG data
-
- C language datatype LONG FLOAT, 9.4.1.4
- exporting, 19.27.4.2
- importing, 19.28.5.11
- LONG VARRAW datatype, 9.4.1.11
M
- master tables
-
- Oracle Data Pump API, 1.5.2
- snapshots
-
- original Import, 19.18.1
- materialized views, 19.18
- media recovery
-
- direct path load, 11.4.6.1
- Metadata API, 18
-
- enhancing performance, 18.6
- retrieving collections, 18.5
- using to retrieve object metadata, 18.3
- missing data columns
-
- SQL*Loader, 8.13.6
- moving databases between platforms, 19.13
- multibyte character sets
-
- blanks with SQL*Loader, 9.5.1
- SQL*Loader, 8.10.1
- multiple-column indexes
-
- SQL*Loader, 11.5.2.3
- multiple-CPU systems
-
- optimizing direct path loads, 11.6
- multiple-table load
-
- generating unique sequence numbers using SQL*Loader, 9.13.7
- SQL*Loader control file specification, 8.15
- multithreading
-
- on multiple-CPU systems, 11.6
- MULTITHREADING parameter
-
- SQL*Loader command line, 7.2.15
N
- named pipes
-
- external table loads, 6.9.3
- native datatypes
-
- conflicting length specifications
-
- SQL*Loader, 9.4.2.9
- nested column objects
-
- loading, 10.1.3
- nested tables
-
- exporting, 19.27.4.9
-
- consistency and, 19.9.3
- importing, 19.28.5.3
- NETWORK_LINK parameter
-
- Data Pump Export utility, 2.4.18
- Data Pump Import utility, 3.4.15
- networks
-
- Export and Import, 19.16
- NLS_LANG environment variable, 19.17.2
-
- with Export and Import, 19.17.3
- NOLOGFILE parameter
-
- Data Pump Export utility, 2.4.19
- Data Pump Import utility, 3.4.16
- nonrecoverable error messages
-
- Export, 19.14.3
- Import, 19.14.3
- nonscalar datatypes, 10.1.5
- NOT NULL constraint
-
- load method, 11.3.8
- null data
-
- missing columns at end of record during load, 8.13.6
- unspecified columns and SQL*Loader, 9.3
- NULL values
-
- objects, 10.1.5
- NULLIF clause
-
- SQL*Loader, 9.5, 9.9
- NULLIF...BLANKS clause
-
- SQL*Loader, 9.5.1
- nulls
-
- atomic, 10.1.5.2
- attribute, 10.1.5.1
- NUMBER datatype
-
- SQL*Loader, 9.4.3, 9.4.4
- numeric EXTERNAL datatypes
-
- delimited form and SQL*Loader, 9.4.5
- determining length, 9.4.6
- SQL*Loader, 9.4.2.5
O
- object identifiers, 10.2
-
- importing, 19.28.5.1
- object names
-
- SQL*Loader, 8.3
- object support, 6.11
- object tables
-
- loading, 10.2, 10.2
- with a subtype
-
- loading, 10.2.1
- object type definitions
-
- exporting, 19.27.4.8
- OBJECT_CONSISTENT parameter
-
- Export utility, 19.9.16
- objects, 6.10
-
- considerations for importing, 19.28.5
- creation errors, 19.28.1.2.1
- ignoring existing objects during import, 19.10.14
- import creation errors, 19.10.14
- loading nested column objects, 10.1.3
- NULL values, 10.1.5
- stream record format, 10.1.1
- variable record format, 10.1.2
- offline locally managed tablespaces
-
- exporting, 19.27.4.4
- OID
-
- See object identifiers
- online help
-
- Export and Import, 19.3.5
- operating systems
-
- moving data to different systems using SQL*Loader, 9.7
- OPTIMAL storage parameter
-
- used with Export/Import, 19.26.1
- optimizer statistics, 19.28.3
- optimizing
-
- direct path loads, 11.5
- SQL*Loader input file processing, 8.7
- OPTIONALLY ENCLOSED BY clause
-
- SQL*Loader, 9.10.2.2
- OPTIONS parameter
-
- for parallel loads, 8.13.3
- SQL*Loader utility, 8.2.1
- Oracle Advanced Queuing
-
- See Advanced Queuing
- Oracle Data Pump
-
- direct path loads
-
- restrictions, 1.3.1
- direct path unload, 1.3.1
- external tables access driver, 1.3.2
- features requiring privileges, 1.2
- master table, 1.5.2
- tuning performance, 4.2
- Oracle Data Pump API, 5
-
- client interface, 5.1
- job states, 5.1.1
- monitoring job progress, 1.6.1
- ORACLE_DATAPUMP access driver
-
- effect of SQL ENCRYPT clause on, 14.1.4
- reserved words, 14, 14.5
- ORACLE_LOADER access driver
-
- reserved words, 13, 13.5
- OWNER parameter
-
- Export utility, 19.9.17
P
- padding of literal strings
-
- SQL*Loader, 9.5.2
- parallel loads, 11.9
-
- restrictions on direct path, 11.9.4
- PARALLEL parameter
-
- Data Pump Export utility
-
- command-line interface, 2.4.20
- interactive-command mode, 2.6.7
- Data Pump Import utility
-
- command-line mode, 3.4.17
- interactive-command mode, 3.6.5
- SQL*Loader command line, 7.2.16
- parameter files
-
- Export, 19.9.18
- Export and Import
-
- comments in, 19.3.3
- maximum size, 19.3.3
- Import, 19.10.18
- SQL*Loader, 7.2.17
- PARFILE parameter
-
- Data Pump Export utility, 2.4.21
- Data Pump Import utility, 3.4.18
- Export command line, 19.9.18
- Import command line, 19.10.18
- SQL*Loader command line, 7.2.17
- partitioned loads
-
- concurrent conventional path loads, 11.8.4
- SQL*Loader, 11.8.4
- partitioned tables
-
- export consistency and, 19.9.3
- exporting, 19.8.1
- importing, 19.8.2.1, 19.12.1
- loading, 11.3.2
- partitioning a database migration, 19.29
-
- advantages of, 19.29
- disadvantages of, 19.29
- procedure during export, 19.29.3
- partition-level Export, 19.8.1
-
- example session, 19.11.4
- partition-level Import, 19.8.2
-
- specifying, 19.9.26
- pattern matching
-
- table names during import, 19.10.29
- performance
-
- improving when using integrity constraints, 11.8.4
- issues when using external tables, 12.5
- optimizing for direct path loads, 11.5
- optimizing reading of SQL*Loader data files, 8.7
- tuning original Import, 19.28.4
- performance tuning
-
- Oracle Data Pump, 4.2
- PIECED parameter
-
- SQL*Loader, 11.4.7.1
- POSITION parameter
-
- using with data containing tabs, 9.2.1
- with multiple SQL*Loader INTO TABLE clauses, 8.15.2.1, 9.2, 9.2.2
- predetermined size fields
-
- SQL*Loader, 9.10.2.1
- predetermined size LOBs, 10.4.2.2.2
- prerequisites
-
- SQL*Loader, 11.1
- PRESERVE parameter, 8.12.2
- preserving
-
- whitespace, 9.11
- PRIMARY KEY constraints
-
- effect on direct path load, 11.9.8
- primary key OIDs
-
- example, 10.2
- primary key REF columns, 10.3.2, 10.3.2
- privileges
-
- EXEMPT ACCESS POLICY
-
- effect on direct path export, 19.27.2.1
- required for Export and Import, 19.2.1
- required for SQL*Loader, 11.1
Q
- QUERY parameter
-
- Data Pump Export utility, 2.4.22
- Data Pump Import utility, 3.4.19
- Export utility, 19.9.19
-
- restrictions, 19.9.19.1
- quotation marks
-
- escape characters and, 8.3.3.2
- filenames and, 8.3.3.1
- SQL strings and, 8.3.2
- table names and, 19.9.26.1, 19.10.29.1
- usage in Data Pump Export, 2.4
- usage in Data Pump Import, 3.4
- use with database object names, 8.3.1
R
- RAW datatype
-
- SQL*Loader, 9.4.2.6
- read-consistent export, 19.9.3
- read-only tablespaces
-
- Import, 19.20
- READSIZE parameter
-
- SQL*Loader command line, 7.2.18
-
- effect on LOBs, 7.2.18
- maximum size, 7.2.18
- RECNUM parameter
-
- use with SQL*Loader SKIP parameter, 9.13.4
- RECORDLENGTH parameter
-
- Export utility, 19.9.20
- Import utility, 19.10.19
- records
-
- consolidating into a single logical record
-
- SQL*Loader, 8.12
- discarded by SQL*Loader, 6.7, 8.9
- DISCARDMAX command-line parameter, 7.2.9
- distinguishing different formats for SQL*Loader, 8.15.2
- extracting multiple logical records using SQL*Loader, 8.15
- fixed format, 6.4.1
- missing data columns during load, 8.13.6
- rejected by SQL*Loader, 6.7, 6.7.1.1, 6.7.1.2, 8.8
- setting column to record number with SQL*Loader, 9.13.4
- specifying how to load, 7.2.13
- specifying length for export, 19.9.20
- specifying length for import, 19.10.19
- stream record format, 6.4.3
- recovery
-
- direct path load
-
- SQL*Loader, 11.4.6
- replacing rows, 8.13.2.2
- redo log file
-
- LogMiner utility
-
- versions supported, 17.13.3
- redo log files
-
- analyzing, 17
- requirements for LogMiner utility, 17.2.1.2
- specifying for the LogMiner utility, 17.3.2
- redo logs
-
- direct path load, 11.4.6.1
- instance and media recovery
-
- SQL*Loader, 11.4.6.1
- minimizing use during direct path loads, 11.5.4
- saving space
-
- direct path load, 11.5.4.2
- REF columns, 10.3
-
- loading, 10.3
- primary key, 10.3.2
- system-generated, 10.3.1
- REF data
-
- importing, 19.28.5.4
- referential integrity constraints
-
- disabling for import, 19.6.2
- SQL*Loader, 11.8
- refresh error
-
- snapshots
-
- Import, 19.18.1
- reject files
-
- specifying for SQL*Loader, 8.8
- rejected records
-
- SQL*Loader, 6.7, 8.8
- relative field positioning
-
- where a field starts and SQL*Loader, 9.10.3
- with multiple SQL*Loader INTO TABLE clauses, 8.15.1.1
- REMAP_DATAFILE parameter
-
- Data Pump Import utility, 3.4.20
- REMAP_SCHEMA parameter
-
- Data Pump Import utility, 3.4.21
- REMAP_TABLESPACE parameter
-
- Data Pump Import utility, 3.4.22
- remote operation
-
- Export/Import, 19.16.2
- REPLACE table
-
- replacing a table using SQL*Loader, 8.13.2.2.2
- reserved words
-
- external tables, 12.6
- ORACLE_DATAPUMP access driver, 14, 14.5
- ORACLE_LOADER access driver, 13, 13.5
- SQL*Loader, 6.3
- resource consumption
-
- controlling in Data Pump Export utility, 4.2.1
- controlling in Data Pump Import utility, 4.2.1
- resource errors
-
- Import, 19.28.1.2.3
- RESOURCE role, 19.4
- restrictions
-
- importing into another user's schema, 19.4.2
- table names in Export parameter file, 19.9.26.1
- table names in Import parameter file, 19.10.29.1
- RESUMABLE parameter
-
- Export utility, 19.9.21
- Import utility, 19.10.20
- SQL*Loader utility, 7.2.19
- resumable space allocation
-
- enabling and disabling, 7.2.19, 19.9.21, 19.10.20
- RESUMABLE_NAME parameter
-
- Export utility, 19.9.22
- Import utility, 19.10.21
- SQL*Loader utility, 7.2.20
- RESUMABLE_TIMEOUT parameter
-
- Export utility, 19.9.23
- Import utility, 19.10.22
- SQL*Loader utility, 7.2.21
- retrieving object metadata
-
- using Metadata API, 18.3
- REUSE_DATAFILES parameter
-
- Data Pump Import utility, 3.4.23
- roles
-
- EXP_FULL_DATABASE, 19.2.3
- RESOURCE, 19.4
- rollback segments
-
- effects of CONSISTENT Export parameter, 19.9.3
- row errors
-
- Import, 19.28.1.1.1
- ROWID columns
-
- loading with SQL*Loader, 11.1.1
- rows
-
- choosing which to load using SQL*Loader, 8.13.4
- exporting, 19.9.24
- specifying for import, 19.10.23
- specifying number to insert before save
-
- SQL*Loader, 11.4.5.1
- updates to existing rows with SQL*Loader, 8.13.2.2.3
- ROWS parameter
-
- Export utility, 19.9.24
- Import utility, 19.10.23
- performance issues
-
- SQL*Loader, 11.5.3
- SQL*Loader command line, 7.2.22
- using to specify when data saves occur, 11.4.5.1
- running
-
- ASMCMD, 20.3
S
- SAMPLE parameter
-
- Data Pump Export utility, 2.4.23
- schema mode export
-
- Data Pump Export utility, 2.2.2.2
- schemas
-
- specifying for Export, 19.9.26
- SCHEMAS parameter
-
- Data Pump Export utility, 2.4.24
- Data Pump Import utility, 3.4.24
- scientific notation for FLOAT EXTERNAL, 9.4.2.5
- script files
-
- running before Export and Import, 19.2.1
- SDFs
-
- See secondary datafiles
- secondary datafiles, 6.5, 10.6.2
- security considerations
-
- direct path export, 19.27.2.1
- segments
-
- temporary
-
- FILE parameter in SQL*Loader, 11.9.6.1
- sequence numb, 9.13.6
- sequence numbers
-
- cached, 19.27.4.1
- exporting, 19.27.4.1
- for multiple tables and SQL*Loader, 9.13.7
- generated by SQL*Loader SEQUENCE clause, 9.13.6
- generated, not read and SQL*Loader, 9.3
- short records with missing data
-
- SQL*Loader, 8.13.6
- SHORTINT datatype
-
- C language, 9.4.1.2
- SHOW parameter
-
- Import utility, 19.10.24
- SILENT parameter
-
- SQL*Loader command line, 7.2.23
- single-byte character sets
-
- Export and Import, 19.17.3
- SINGLEROW parameter, 8.14.2, 11.7
- single-table loads
-
- continuing, 8.11.5
- SKIP parameter
-
- effect on SQL*Loader RECNUM specification, 9.13.4
- SQL*Loader command line, 7.2.24, 7.2.24
- SKIP_INDEX_MAINTENANCE parameter
-
- SQL*Loader command line, 7.2.25, 11.7
- SKIP_UNUSABLE_INDEXES parameter
-
- Import utility, 19.10.25
- SQL*Loader command line, 7.2.26, 11.7
- SKIP_USABLE_INDEXES parameter
-
- Data Pump Import utility, 3.4.25
- skipping index maintenance, 7.2.25, 11.7
- skipping unusable indexes, 7.2.26, 11.7
- SMALLINT datatype, 9.4.1.2
- snapshot log
-
- Import, 19.18.1
- snapshots, 19.18.2
-
- importing, 19.18
- master table
-
- Import, 19.18.1
- restoring dropped
-
- Import, 19.18.2.1
- SORTED INDEXES clause
-
- direct path loads, 8.14.1
- SQL*Loader, 11.5.2.1
- sorting
-
- multiple-column indexes
-
- SQL*Loader, 11.5.2.3
- optimum sort order
-
- SQL*Loader, 11.5.2.4
- presorting in direct path load, 11.5.2
- SORTED INDEXES clause
-
- SQL*Loader, 11.5.2.1
- SQL operators
-
- applying to fields, 9.12
- SQL strings
-
- applying SQL operators to fields, 9.12
- quotation marks and, 8.3.2
- SQL*Loader
-
- appending rows to tables, 8.13.2.2.1
- BAD command-line parameter, 7.2.1
- bad file, 7.2.1
- BADFILE parameter, 8.8
- bind arrays and performance, 8.16.2
- BINDSIZE command-line parameter, 7.2.2, 8.16.3
- choosing which rows to load, 8.13.4
- COLUMNARRAYROWS command-line parameter, 7.2.3
- command-line parameters, 7.1
- continuing single-table loads, 8.11.5
- CONTROL command-line parameter, 7.2.4
- conventional path loads, 6.9.1, 11.2
- DATA command-line parameter, 7.2.5
- data conversion, 6.6
- data definition language
-
- syntax diagrams, A
- datatype specifications, 6.6
- DATE_CACHE command-line parameter, 7.2.6
- determining default schema, 8.13.1.1
- DIRECT command-line parameter, 11.4.2
- direct path method, 6.9.2
-
- using date cache feature to improve performance, 11.5.6
- DISCARD command-line parameter, 7.2.8
- discarded records, 6.7
- DISCARDFILE parameter, 8.9.1
- DISCARDMAX command-line parameter, 7.2.9
- DISCARDMAX parameter, 8.9.6
- DISCARDS parameter, 8.9.6
- errors caused by tabs, 9.2.1
- ERRORS command-line parameter, 7.2.10
- exclusive access, 11.8.3
- external table loads, 6.9.3
- EXTERNAL_TABLE parameter, 7.2.11
- FILE command-line parameter, 7.2.12
- filenames, 8.3
- globalization technology, 8.10
- index options, 8.14
- inserting rows into tables, 8.13.2.1.1
- INTO TABLE statement, 8.13
- LOAD command-line parameter, 7.2.13
- load methods, 11.1
- loading column objects, 10.1
- loading data across different platforms, 9.7
- loading data contained in the control file, 9.13.1
- loading object tables, 10.2
- LOG command-line parameter, 7.2.14
- log files, 6.8
- methods of loading data, 6.9
- multiple INTO TABLE statements, 8.15
- MULTITHREADING command-line parameter, 7.2.15
- object names, 8.3
- parallel data loading, 11.9, 11.9.3, 11.10
- PARFILE command-line parameter, 7.2.17
- READSIZE command-line parameter, 7.2.18
-
- maximum size, 7.2.18
- rejected records, 6.7
- replacing rows in tables, 8.13.2.2.2
- required privileges, 11.1
- RESUMABLE parameter, 7.2.19
- RESUMABLE_NAME parameter, 7.2.20
- RESUMABLE_TIMEOUT parameter, 7.2.21
- ROWS command-line parameter, 7.2.22
- SILENT command-line parameter, 7.2.23
- SINGLEROW parameter, 8.14.2
- SKIP_INDEX_MAINTENANCE command-line parameter, 7.2.25
- SKIP_UNUSABLE_INDEXES command-line parameter, 7.2.26
- SORTED INDEXES during direct path loads, 8.14.1
- specifying columns, 9.3
- specifying datafiles, 8.5
- specifying field conditions, 9.5
- specifying fields, 9.3
- specifying more than one datafile, 8.5.2
- STREAMSIZE command-line parameter, 7.2.27
- suppressing messages, 7.2.23
- updating rows, 8.13.2.2.3
- USERID command-line parameter, 7.2.28
- SQLFILE parameter
-
- Data Pump Import utility, 3.4.26
- START_JOB parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.8
- Data Pump Import utility
-
- interactive-command mode, 3.6.6
- starting
-
- LogMiner utility, 17.4
- statistics
-
- analyzer, 19.28.3
- database optimizer
-
- specifying for Export, 19.9.25
- optimizer, 19.28.3
- specifying for Import, 19.10.26
- STATISTICS parameter
-
- Export utility, 19.9.25
- Import utility, 19.10.26
- STATUS parameter
-
- Data Pump Export utility, 2.4.25
-
- interactive-command mode, 2.6.9
- Data Pump Import utility, 3.4.27
-
- interactive-command mode, 3.6.7
- STOP_JOB parameter
-
- Data Pump Export utility
-
- interactive-command mode, 2.6.10
- Data Pump Import utility
-
- interactive-command mode, 3.6.8
- STORAGE parameter, 11.9.6.1.2
- storage parameters
-
- estimating export requirements, 19.2.2
- OPTIMAL parameter, 19.26.1
- overriding
-
- Import, 19.26.3
- preallocating
-
- direct path load, 11.5.1
- temporary for a direct path load, 11.4.3.2
- using with Export/Import, 19.26
- stored functions
-
- importing, 19.28.5.7
-
- effect of COMPILE parameter, 19.28.5.7
- stored package, 19.28.5.7
- stored packages
-
- importing, 19.28.5.7
- stored procedures
-
- direct path load, 11.8.2.6
- importing, 19.28.5.7
-
- effect of COMPILE parameter, 19.28.5.7
- stream buffer
-
- specifying size for direct path, 11.5.5
- stream record format, 6.4.3
-
- loading column objects in, 10.1.1
- Streams environment in Data Pump
-
- setting buffer cache size, 4.3.1
- STREAMS_CONFIGURATION parameter
-
- Data Pump Import utility, 3.4.28
- Import utility, 19.10.27
- STREAMS_INSTANTIATION parameter
-
- Import utility, 19.10.28
- STREAMSIZE parameter
-
- SQL*Loader command line, 7.2.27
- string comparisons
-
- SQL*Loader, 9.5.2
- subpartitioned tables
-
- loading, 11.3.2
- subtypes
-
- loading multiple, 8.15.3
- supplemental logging
-
- LogMiner utility, 17.9
-
- database-level identification keys, 17.9.1.2
- log groups, 17.9
- table-level, 17.9.3
- table-level identification keys, 17.9.3.1
- table-level log groups, 17.9.3.2, 17.9.3.2
- See also LogMiner utility
- synonyms
-
- direct path load, 11.3.10
- exporting, 19.27.4.11
- syntax diagrams
-
- Data Pump Export, 2.8
- Data Pump Import, 3.8
- SQL*Loader, A
- symbols used in BNF variant, B
- SYSDATE parameter
-
- SQL*Loader, 9.13.5
- system objects
-
- importing, 19.4.3
- system triggers
-
- effect on import, 19.7
- testing, 19.7
- system-generated OID REF columns, 10.3.1
T
- table names
-
- preserving case sensitivity, 19.9.26.1
- TABLE_EXISTS_ACTION parameter
-
- Data Pump Import utility, 3.4.29
- table-level Export, 19.8.1
- table-level Import, 19.8.2
- table-mode Export
-
- Data Pump Export utility, 2.2.2.3
- specifying, 19.9.26
- table-mode Import
-
- examples, 19.12.1
- tables
-
- Advanced Queuing
-
- exporting, 19.27.4.10
- importing, 19.28.5.10
- appending rows with SQL*Loader, 8.13.2.2.1
- defining before Import, 19.6.1
- definitions
-
- creating before Import, 19.6.1
- exclusive access during direct path loads
-
- SQL*Loader, 11.8.3
- external, 12
- importing, 19.10.29
- insert triggers
-
- direct path load in SQL*Loader, 11.8.2
- inserting rows using SQL*Loader, 8.13.2.1.1
- loading data into more than one table using SQL*Loader, 8.15
- loading object tables, 10.2
- maintaining consistency during Export, 19.9.3
- manually ordering for Import, 19.6.3
- master table
-
- Import, 19.18.1
- name restrictions
-
- Export, 19.9.26.1
- Import, 19.10.29, 19.10.29.1
- nested
-
- exporting, 19.27.4.9
- importing, 19.28.5.3
- objects
-
- order of import, 19.5
- partitioned, 19.8.1
- replacing rows using SQL*Loader, 8.13.2.2.2
- specifying for export, 19.9.26
- specifying table-mode Export, 19.9.26
- SQL*Loader method for individual tables, 8.13.2
- truncating
-
- SQL*Loader, 8.13.2.2.4
- updating existing rows using SQL*Loader, 8.13.2.2.3
- See also external tables
- TABLES parameter
-
- Data Pump Export utility, 2.4.26
- Data Pump Import utility, 3.4.30
- Export utility, 19.9.26
- Import utility, 19.10.29
- tablespace mode Export
-
- Data Pump Export utility, 2.2.2.4
- tablespaces
-
- dropping during import, 19.21
- exporting a set of, 19.19
- metadata
-
- transporting, 19.10.33
- read-only
-
- Import, 19.20
- reorganizing
-
- Import, 19.22
- TABLESPACES parameter
-
- Data Pump Export utility, 2.4.27
- Data Pump Import utility, 3.4.31
- Export utility, 19.9.27
- Import utility, 19.10.30
- tabs
-
- loading datafiles containing tabs, 9.2.1
- trimming, 9.10
- whitespace, 9.10
- temporary segments, 11.9.6.1
-
- FILE parameter
-
- SQL*Loader, 11.9.6.1
- temporary storage in a direct path load, 11.4.3.2
- TERMINATED BY clause
-
- WHITESPACE
-
- SQL*Loader, 9.4.5.1
- with OPTIONALLY ENCLOSED BY, 9.10.2.2
- terminated fields
-
- specified with a delimiter, 9.10.2.2
- specified with delimiters and SQL*Loader, 9.4.5.1
- time
-
- SQL*Loader datatypes for, 9.4.2.2
- TOID_NOVALIDATE parameter
-
- Import utility, 19.10.31
- TOUSER parameter
-
- Import utility, 19.10.32
- trailing blanks
-
- loading with delimiters, 9.4.5.6
- TRAILING NULLCOLS parameter
-
- SQL*Loader utility, 8.1, 8.13.6.1
- trailing whitespace
-
- trimming, 9.10.5
- TRANSFORM parameter
-
- Data Pump Import utility, 3.4.32
- transparent data encryption
-
- as handled by Data Pump Export, 2.4.6
- as handled by Data Pump Import, 3.4.5
- TRANSPORT_DATAFILES parameter
-
- Data Pump Import utility, 3.4.33
- TRANSPORT_FULL_CHECK parameter
-
- Data Pump Export utility, 2.4.28
- Data Pump Import utility, 3.4.34
- TRANSPORT_TABLESPACE parameter
-
- Export utility, 19.9.28
- Import utility, 19.10.33
- TRANSPORT_TABLESPACES parameter
-
- Data Pump Export utility, 2.4.29
- Data Pump Import utility, 3.4.35
- transportable tablespaces, 19.19
- transportable-tablespace mode Export
-
- Data Pump Export utility, 2.2.2.5
- triggers
-
- database insert, 11.8.2
- logon
-
- effect in SQL*Loader, 8.13.1.1
- permanently disabled, 11.8.3
- replacing with integrity constraints, 11.8.2.1
- system
-
- testing, 19.7
- update
-
- SQL*Loader, 11.8.2.4
- TRIGGERS parameter
-
- Export utility, 19.9.29
- trimming
-
- summary, 9.10
- trailing whitespace
-
- SQL*Loader, 9.10.5
- TTS_FULL_CHECK parameter
-
- Export utility, 19.9.30
- TTS_OWNERS parameter
-
- Import utility, 19.10.34
U
- undo tablespace
-
- consumption by Data Pump, 1.9
- UNIQUE KEY constraints
-
- effect on direct path load, 11.9.8
- unique values
-
- generating with SQL*Loader, 9.13.6
- unloading entire database
-
- Data Pump Export utility, 2.2.2.1
- UNRECOVERABLE clause
-
- SQL*Loader, 11.5.4.2
- unsorted data
-
- direct path load
-
- SQL*Loader, 11.5.2.2
- updating
-
- rows in a table
-
- SQL*Loader, 8.13.2.2.3
- user mode export
-
- specifying, 19.9.17
- USER_SEGMENTS view
-
- Export and, 19.2.2
- user-defined constructors, 10.1.6
-
- loading column objects with, 10.1.6
- USERID parameter
-
- Export utility, 19.9.31
- Import utility, 19.10.35
- SQL*Loader command line, 7.2.28
V
- V$DATABASE view, 17.10
- V$LOGMNR_CONTENTS view, 17.5.1
-
- formatting information returned to, 17.6
- impact of querying, 17.5.1
- information within, 17.5
- limiting information returned to, 17.6
- LogMiner utility, 17.2.2
- requirements for querying, 17.4, 17.5.1
- V$LOGMNR_DICTIONARY view, 17.10
- V$LOGMNR_LOGS view, 17.3.2, 17.10
-
- querying, 17.10.1
- V$LOGMNR_PARAMETERS view, 17.9.6, 17.10
- V$SESSION_LONGOPS view
-
- monitoring Data Pump jobs with, 1.6.1
- value datatypes, 9.4, 9.4
- VARCHAR datatype
-
- SQL*Loader, 9.4.1.9
- VARCHAR2 datatype
-
- SQL*Loader, 9.4.3
- VARCHARC datatype
-
- SQL*Loader, 9.4.2.7
- VARGRAPHIC datatype
-
- SQL*Loader, 9.4.1.8
- variable records, 6.4.2
-
- format, 10.1.2
- variable-length records
-
- external tables, 13.2.2
- VARRAW datatype, 9.4.1.10
- VARRAWC datatype, 9.4.2.8
- VARRAY columns
-
- memory issues when loading, 10.8.1
- VERSION parameter
-
- Data Pump Export utility, 2.4.30
- Data Pump Import utility, 3.4.36
- VOLSIZE parameter
-
- Export utility, 19.9.32
- Import utility, 19.10.36
W
- warning messages
-
- Export, 19.14.2
- Import, 19.14.2
- WHEN clause
-
- SQL*Loader, 8.13.4, 9.5
- SQL*Loader discards resulting from, 8.9.4
- whitespace
-
- included in a field, 9.10.4
- leading, 9.10.1
- preserving, 9.11
- terminating a field, 9.4.5, 9.10.4.1
- trimming, 9.10
X
- XML columns
-
- loading, 10.4
- treatment by SQL*Loader, 10.4
- XML type tables
-
- identifying in SQL*Loader, 8.4
- XMLTYPE clause
-
- in SQL*Loader control file, 8.4
Z
- ZONED datatype, 9.4.1.6
-
- EXTERNAL format
-
- SQL*Loader, 9.4.2.5