Index
A
- ABORT_STEP parameter
- ACCESS_METHOD parameter
- ACCESS PARAMETERS clause
- special characters 1
- access privileges
- Export and Import 1
- ADD_FILE parameter
- Data Pump Export utility
- interactive-command mode 1
- Data Pump Export utility
- ADR
- See: automatic diagnostic repository
- ADR base
- in ADRCI utility 1
- ADRCI
- troubleshooting 1
- ADRCI utility 1
- ADR home
- in ADRCI utility 1
- Advanced Queuing
- aliases
- 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
- archiving
- disabling
- effect on direct path loads 1
- disabling
- array overflows 1
- arrays
- committing after insert 1
- atomic null 1
- attaching to an existing job
- Data Pump Export utility 1
- ATTACH parameter
- attributes
- null 1
- attribute-value constructors
- overriding 1
- auditing Data Pump jobs
- unified auditing
- Data Pump 1
- unified auditing
- auditing direct path loads
- when using SQL*Loader 1
- automatic diagnostic repository 1
B
- backslash escape character 1
- backups
- restoring dropped snapshots
- Import 1
- restoring dropped snapshots
- BADFILE parameter
- SQL*Loader utility 1
- bad files
- specifying for SQL*Loader 1
- BAD parameter
- BEGINDATA parameter
- SQL*Loader control file 1
- BFILEs
- big-endian data
- external tables 1
- binary overflows 1
- bind arrays
- BINDSIZE parameter
- blanks
- BLANKS parameter
- SQL*Loader utility 1
- BLOBs
- loading with SQL*Loader 1
- buffer cache size
- and Data Pump operations involving Streams 1
- BUFFER parameter
- buffers
- byte order 1
- BYTEORDERMARK parameter
- SQL*Loader utility 1
- byte order marks 1
- BYTEORDER parameter
- SQL*Loader utility 1
C
- cached sequence numbers
- Export 1
- catalog.sql script
- catexp.sql script
- CDBs
- changing a database ID 1
- changing a database name 1
- character fields
- character-length semantics 1
- character overflows 1
- CHARACTERSET parameter
- character sets
- character strings
- CHAR data type
- delimited form and SQL*Loader 1
- check constraints
- overriding disabling of 1
- CLOBs
- loading with SQL*Loader 1
- CLUSTER parameter
- 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 mapping 1
- column objects
- columns
- exporting LONG data types 1
- loading REF columns 1
- naming
- SQL*Loader 1
- objects
- 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
- com.oracle.bigdata.colmap 1
- com.oracle.bigdata.datamode 1
- com.oracle.bigdata.erroropt 1
- com.oracle.bigdata.fields 1
- com.oracle.bigdata.fileformat 1
- com.oracle.bigdata.log.qc 1
- com.oracle.bigdata.overflow 1
- com.oracle.bigdata.rowformat 1
- com.oracle.bigdata.tablename 1
- comments
- COMMIT parameter
- Import utility 1
- COMPILE parameter
- Import utility 1
- completion messages
- compression
- 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
- consolidating
- extents 1
- CONSTANT parameter
- SQL*Loader 1
- constraints
- CONSTRAINTS parameter
- constructors
- CONTENT parameter
- CONTINUE_CLIENT parameter
- CONTINUEIF parameter
- SQL*Loader utility 1
- control files
- CONTROL parameter
- SQL*Loader command line 1
- conventional path Export
- compared to direct path 1
- conventional path loads
- conversion of character sets
- conversion of data
- during direct path loads 1
- conversion of input characters 1
- CREATE REPORT command, ADRCI utility 1
- CREATE SESSION privilege
- creating
- 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
- conversion
- DATA_CACHE parameter
- SQL*Loader utility 1
- DATA_OPTIONS parameter
- database ID (DBID)
- changing 1
- database identifier
- changing 1
- database migration
- database name (DBNAME)
- changing 1
- database objects
- exporting LONG columns 1
- databases
- data cache feature
- data fields
- specifying the SQL*Loader data type 1
- datafiles
- data files
- DATAFILES parameter
- Import utility 1
- data mode 1
- DATA parameter
- 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
- FLASHBACK_SCN parameter 1
- FLASHBACK_TIME parameter 1
- FULL parameter 1
- HELP parameter
- interactive-command mode 1
- INCLUDE parameter 1
- interactive-command mode 1
- interfaces 1
- invoking
- JOB_NAME parameter 1
- job names
- specifying 1
- KEEP_MASTER parameter 1
- LOGFILE parameter 1
- LOGTIME parameter 1
- METRICS parameter 1
- NETWORK_LINK parameter 1
- NOLOGFILE parameter 1
- PARALLEL parameter
- 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
- FLASHBACK_SCN parameter 1
- FLASHBACK_TIME parameter 1
- full import mode 1
- FULL parameter 1
- HELP parameter
- INCLUDE parameter 1
- interactive-command mode 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_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 source name 1
- data types
- BFILEs
- 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
- data types (HDFS) 1
- DATE_FORMAT parameter
- SQL*Loader express mode 1
- DATE data type
- 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
- DBMS_LOGMNR.START_LOGMNR procedure
- DBMS_LOGMNR PL/SQL procedure
- LogMiner utility and 1
- DBMS_METADATA PL/SQL package 1
- DBNAME
- changing 1
- DBNEWID utility 1
- DBVERIFY utility
- DEFAULTIF parameter
- SQL*Loader 1
- default schema
- as determined by SQL*Loader 1
- DEGREE_OF_PARALLELISM parameter
- DELETE ANY TABLE privilege
- SQL*Loader 1
- DELETE CASCADE
- DELETE privilege
- SQL*Loader 1
- delimited data
- maximum length for SQL*Loader 1
- delimited fields
- field length 1
- delimited LOBs 1
- delimited text files 1
- delimiters
- DESTROY parameter
- Import utility 1
- dictionary
- requirements for LogMiner utility 1
- dictionary version mismatch 1
- Direct NFS Client
- directory aliases
- directory objects
- using with Data Pump
- effect of Oracle ASM 1
- using with Data Pump
- DIRECTORY parameter
- DIRECT parameter
- direct path Export 1, 2
- 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
- discard files
- DISCARD parameter
- SQL*Loader command-line 1
- discontinued loads 1
- DNFS_ENABLE parameter
- DNFS_READBUFFERS parameter
- dropped snapshots
- Import 1
- DUMPFILE parameter
- dump files
- maximum size 1
E
- EBCDIC character set
- ECHO command, ADRCI utility 1
- eight-bit character set support 1, 2
- ENCLOSED_BY parameter
- SQL*Loader express mode 1
- enclosed fields
- whitespace 1
- enclosure delimiters 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
- ENCRYPTION_PWD_PROMPT parameter
- ENCRYPTION parameter
- Data Pump Export utility 1
- encryption password
- error handling 1
- errors
- ERRORS parameter
- SQL*Loader command line 1
- escape character
- ESTIMATE_ONLY parameter
- Data Pump Export utility 1
- ESTIMATE parameter
- estimating size of job
- Data Pump Export utility 1
- EVALUATE CHECK_CONSTRAINTS clause 1
- EXCLUDE parameter
- EXIT_CLIENT parameter
- exit codes
- EXIT command, ADRCI utility 1
- EXP_FULL_DATABASE role
- 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
- DIRECT parameter 1
- direct path 1
- displaying online help 1
- example sessions 1
- 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
- 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
- VOLSIZE parameter 1
- export dump file
- importing the entire file 1
- export file
- exporting
- archived LOBs 1
- EXPRESSION parameter
- extents
- consolidating 1
- EXTERNAL_TABLE parameter
- EXTERNAL parameter
- SQL*Loader 1
- EXTERNAL SQL*Loader data types
- numeric
- determining len 1
- numeric
- external tables 1
- 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
- FIELD_NAMES parameter
- SQL*Loader express mode 1
- field conditions
- specifying for SQL*Loader 1
- field extraction 1
- field length
- SQL*Loader specifications 1
- field location
- SQL*Loader 1
- field names 1
- fields
- FIELDS clause
- SQL*Loader 1
- file allocation in Data Pump
- file names
- FILE parameter
- FILESIZE parameter
- FILLER field
- using as argument to init_spec 1
- filtering data
- 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
- FLASHBACK_TIME parameter
- foreign function libraries
- formats
- SQL*Loader input records and 1
- formatting errors
- SQL*Loader 1
- FROMUSER parameter
- Import utility 1
- full database mode
- full export mode
- Data Pump Export utility 1
- FULL parameter
- full transportable export 1
- full transportable import 1
H
I
- IGNORE parameter
- Import utility 1
- IMP_FULL_DATABASE role
- 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
- 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
- exit codes 1, 2
- export file
- 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
- 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
- incident package
- fault diagnosability infrastructure 1
- INCLUDE parameter
- 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
- Index Unusable state
- INFILE parameter
- SQL*Loader utility 1
- insert errors
- INSERT into table
- SQL*Loader 1
- instance affinity
- Export and Import 1
- instance recovery 1
- integrity constraints
- interactive method
- Data Pump Export utility 1
- internal LOBs
- loading 1
- interrupted loads 1
- INTO TABLE statement
- invalid data
- Import 1
- invoking
- IPS command, ADRCI utility 1
L
- leading whitespace
- legacy mode in Data Pump 1
- length indicator
- determining size 1
- length-value pair specified LOBs 1
- libraries
- little-endian data
- external tables 1
- loading
- LOAD parameter
- LOB data
- LOB data types 1
- LOBFILEs 1, 2, 3
- LOGFILE parameter
- log files 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
- 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
- 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
- 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
- supplemental log groups 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
- LOGTIME parameter
- LONG data
M
- MASTER_ONLY parameter
- Data Pump Import utility 1
- master tables
- materialized views 1
- media recovery
- direct path load 1
- Metadata API
- METRICS parameter
- missing data columns
- SQL*Loader 1
- multibyte character sets
- multiple-column indexes
- SQL*Loader 1
- multiple-CPU systems
- optimizing direct path loads 1
- multiple-table load
- multitenant architecture 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
- conflicting length specifications
- NCLOBs
- loading with SQL*Loader 1
- nested column objects
- loading 1
- nested tables
- NETWORK_LINK parameter
- networks
- NFS errors when using Data Pump 1
- NLS_LANG environment variable 1, 2
- NO_INDEX_ERRORS parameter
- SQL*Loader command line 1
- NOLOGFILE parameter
- nonrecoverable error messages
- nonscalar data types 1
- NOT NULL constraint
- load method 1
- null data
- NULLIF...BLANKS clause
- SQL*Loader 1
- NULLIF clause
- NULLIF parameter
- SQL*Loader express mode 1
- nulls
- NULL values
- objects 1
- NUMBER data type
- numeric EXTERNAL data types
O
- OBJECT_CONSISTENT parameter
- Export utility 1
- object identifiers 1
- importing 1
- object names
- SQL*Loader 1
- objects 1
- object tables
- 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
- OPTIONALLY_ENCLOSED_BY parameter
- SQL*Loader express mode 1
- OPTIONALLY ENCLOSED BY clause
- SQL*Loader 1
- OPTIONS parameter
- 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
- ORACLE_HIVE
- access parameters 1
- ORACLE_LOADER access driver
- Oracle Advanced Queuing
- See: Advanced Queuing
- Oracle Automatic Storage Management (ASM)
- Data Pump and 1
- Oracle Data Pump
- Oracle Data Pump API 1
- ORC files 1
- overflow handling 1
- OWNER parameter
- Export utility 1
P
- packages
- creating 1
- padding of literal strings
- SQL*Loader 1
- parallel loads 1
- PARALLEL parameter
- parameter files
- PARFILE parameter
- Parquet files 1
- parsing HDFS files 1
- PARTITION_MEMORY parameter
- SQL*Loader utility 1
- PARTITION_OPTIONS parameter
- Data Pump Import utility 1
- partitioned loads
- partitioned object support in SQL*Loader 1
- partitioned tables
- partitioning a database migration 1, 2
- partition-level Export 1
- example session 1
- partition-level Import 1
- specifying 1
- pattern matching
- table names during import 1
- performance
- PIECED parameter
- SQL*Loader 1
- POSITION parameter
- 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
- problem
- fault diagnosability infrastructure 1
- problem key
- fault diagnosability infrastructure 1
- PURGE command, ADRCI utility 1
R
- RC files 1
- read-consistent export 1
- read-only tablespaces
- Import 1
- READSIZE parameter
- RECNUM parameter
- use with SQL*Loader SKIP parameter 1
- RECORDLENGTH parameter
- 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
- consolidating into a single logical record
- recovery
- redo log file
- LogMiner utility
- versions supported 1
- LogMiner utility
- redo log files
- redo logs
- REF columns 1
- REF data
- importing 1
- referential integrity constraints
- refresh error
- snapshots
- Import 1
- snapshots
- rejected records
- reject files
- specifying for SQL*Loader 1
- relative field positioning
- REMAP_DATAFILE parameter
- Data Pump Import utility 1
- REMAP_DATA parameter
- REMAP_SCHEMA parameter
- Data Pump Import utility 1
- REMAP_TABLE parameter
- Data Pump Import utility 1
- REMAP_TABLESPACE parameter
- Data Pump Import utility 1
- remote operation
- REPLACE table
- replacing a table using SQL*Loader 1
- reserved words
- resource consumption
- resource errors
- Import 1
- RESOURCE role 1
- restrictions
- RESUMABLE_NAME parameter
- RESUMABLE_TIMEOUT parameter
- RESUMABLE parameter
- resumable space allocation
- retrieving object metadata
- using Metadata API 1
- REUSE_DATAFILES parameter
- Data Pump Import utility 1
- REUSE_DUMPFILES parameter
- Data Pump Export utility 1
- roles
- rollback segments
- effects of CONSISTENT Export parameter 1
- row errors
- Import 1
- row format description 1
- row formats 1
- ROWID columns
- loading with SQL*Loader 1
- rows
- ROWS parameter
- 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
- scientific notation for FLOAT EXTERNAL 1
- script files
- 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
- temporary
- SELECT command, ADRCI utility 1
- functions 1
- sequence files 1
- sequence numb 1
- sequence numbers
- SerDe parsing 1
- SERVICE_NAME parameter
- 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
- single-byte character sets
- SINGLEROW parameter 1
- single-table loads
- continuing 1
- SKIP_INDEX_MAINTENANCE parameter
- SQL*Loader command line 1
- SKIP_UNUSABLE_INDEXES parameter
- SKIP_USABLE_INDEXES parameter
- Data Pump Import utility 1
- SKIP parameter
- skipping unusable indexes 1
- SmartScan mode 1
- snapshot log
- Import 1
- snapshots 1
- SORTED INDEXES clause
- sorting
- SOURCE_EDITION parameter
- source name 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
- 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
- START_JOB parameter
- starting
- LogMiner utility 1
- statistics
- STATISTICS parameter
- Import utility 1
- STATUS parameter
- STOP_JOB parameter
- storage parameters
- stored functions
- stored package 1
- stored packages
- importing 1
- stored procedures
- stream buffer
- specifying size for direct path 1
- stream record format 1
- loading column objects in 1
- STREAMS_CONFIGURATION parameter
- 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
- struct overflows 1
- subpartitioned tables
- loading 1
- subtypes
- loading multiple 1
- supplemental logging 1
- See also: LogMiner utility
- synonyms
- exporting 1
- syntax diagrams
- SYSDATE parameter
- SQL*Loader 1
- system-generated OID REF columns 1
- system objects
- importing 1
- system triggers
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
- table-mode Import
- examples 1
- table names
- preserving case sensitivity 1
- TABLE parameter
- SQL*Loader express mode 1
- tables
- Advanced Queuing
- appending rows with SQL*Loader 1
- defining before Import 1
- definitions
- creating before Import 1
- exclusive access during direct path loads
- SQL*Loader 1
- external 1
- importing 1
- inserting rows using SQL*Loader 1
- insert triggers
- direct path load in SQL*Loader 1
- loading data into more than one table using SQL*Loader 1
- loading object tables 1
- maintaining consistency during Export 1
- manually ordering for Import 1
- master table
- Import 1
- name restrictions
- nested
- objects
- order of import 1
- partitioned 1
- replacing rows using SQL*Loader 1
- specifying for export 1
- specifying table-mode Export 1
- SQL*Loader method for individual tables 1
- truncating
- SQL*Loader 1
- updating existing rows using SQL*Loader 1
- tablespace mode Export
- Data Pump Export utility 1
- tablespaces
- TABLESPACES parameter
- TABLES parameter
- tabs
- TARGET_EDITION parameter
- Data Pump Import utility 1
- temporary segments 1
- FILE parameter
- SQL*Loader 1
- FILE parameter
- 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
- text files 1
- text overflows 1
- TIMESTAMP_FORMAT parameter
- SQL*Loader express mode 1
- timestamps
- 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
- trailing whitespace
- trimming 1
- TRANSFORM parameter
- Data Pump Import utility 1
- transparent data encryption
- TRANSPORT_DATAFILES parameter
- Data Pump Import utility 1
- TRANSPORT_FULL_CHECK parameter
- TRANSPORT_TABLESPACE parameter
- TRANSPORT_TABLESPACES parameter
- transportable option
- TRANSPORTABLE parameter
- transportable-tablespace mode Export
- Data Pump Export utility 1
- transportable tablespaces 1, 2
- triggers
- TRIGGERS parameter
- Export utility 1
- trimming
- TRIM parameter
- TTS_FULL_CHECK parameter
- Export utility 1
- TTS_OWNERS parameter
- Import utility 1
U
- unified auditing
- during SQL*Loader operations 1
- union overflows 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
- direct path load
- USER_SEGMENTS view
- Export and 1
- user-defined constructors 1
- loading column objects with 1
- USERID parameter
- user mode export
- specifying 1
V
- V$DATABASE view 1
- V$LOGMNR_CONTENTS view 1
- 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
- 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