Index

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

A

access privileges

Export and Import, 21.2.3

ADD_FILE parameter

Data Pump Export utility

interactive-command mode, 2.5.1

ADR

See automatic diagnostic repository

ADR base

in ADRCI utility, 16.2

ADR home

in ADRCI utility, 16.2

ADRCI

troubleshooting, 16.10

ADRCI utility, 16

ADR base, 16.2

ADR home, 16.2

batch mode, 16.3.3

commands, 16.9

getting help, 16.3

homepath, 16.2

interactive mode, 16.3.1

starting, 16.3

Advanced Queuing

exporting advanced queue tables, 21.14.10

importing advanced queue tables, 22.16.10

aliases

B

backslash escape character, 9.3.3.2

backups

restoring dropped snapshots

Import, 22.18.2.1

bad files

specifying for SQL*Loader, 9.8

BAD parameter

SQL*Loader command line, 8.2.1

BADFILE parameter

SQL*Loader utility, 9.8

BEGINDATA parameter

SQL*Loader control file, 9.6

BFILEs

in original Export, 21.14.6

in original Import, 22.16.5

loading with SQL*Loader, 11.4, 11.5

big-endian data

external tables, 14.2.8

bind arrays

determining size of for SQL*Loader, 9.16.4

minimizing SQL*Loader memory requirements, 9.16.5

minimum requirements, 9.16.1

size with multiple SQL*Loader INTO TABLE statements, 9.16.6

specifying maximum size, 8.2.2

specifying number of rows, 8.2.23

SQL*Loader performance implications, 9.16.2

BINDSIZE parameter

SQL*Loader command line, 8.2.2, 9.16.3

blanks

loading fields consisting of blanks, 10.9

SQL*Loader BLANKS parameter for field comparison, 10.5.1

trailing, 10.4.5.4

trimming, 10.10

external tables, 14.3.2

whitespace, 10.10

BLANKS parameter

SQL*Loader utility, 10.5.1

BLOBs

loading with SQL*Loader, 11.4

bound fillers, 10.3.1

buffer cache size

and Data Pump operations involving Streams, 5.3.1

BUFFER parameter

Export utility, 21.5.1

Import utility, 22.7.1

buffers

calculating for export, 21.5.1

specifying with SQL*Loader BINDSIZE parameter, 9.16.4

byte order, 10.8

big-endian, 10.8

little-endian, 10.8

specifying in SQL*Loader control file, 10.8.1

byte order marks, 10.8.2

precedence

for first primary datafile, 10.8.2

for LOBFILEs and SDFs, 10.8.2

suppressing checks for, 10.8.2.1

BYTEORDER parameter

SQL*Loader utility, 10.8.1

BYTEORDERMARK parameter

SQL*Loader utility, 10.8.2.1

C

cached sequence numbers

Export, 21.14.1

catalog.sql script

preparing database for Export and Import, 21.2.1, 22.2.1

catexp.sql script

preparing database for Export and Import, 21.2.1, 22.2.1

catldr.sql script

preparing for direct path loads, 12.4.1

changing a database ID, 18.3.1

changing a database name, 18.3.3

CHAR datatype

delimited form and SQL*Loader, 10.4.5

character fields

delimiters and SQL*Loader, 10.4.2, 10.4.5

determining length for SQL*Loader, 10.4.7

SQL*Loader datatypes, 10.4.2

character sets

conversion

during Export and Import, 21.12.1, 22.14.1

eight-bit to seven-bit conversions

Export/Import, 21.12.3, 22.14.3

identifying for external tables, 14.2.4

multibyte

Export/Import, 21.12.4

SQL*Loader, 9.10.1

single-byte

Export/Import, 21.12.3, 22.14.3

SQL*Loader control file, 9.10.5.3

SQL*Loader conversion between, 9.10

Unicode, 9.10.2

character strings

external tables

specifying bytes or characters, 14.2.10

SQL*Loader, 10.5.2

character-length semantics, 9.10.5.4

CHARACTERSET parameter

SQL*Loader utility, 9.10.5.2

check constraints

overriding disabling of, 12.8.1.2

CLOBs

loading with SQL*Loader, 11.4

CLUSTER parameter

Data Pump Export utility, 2.4.4

Data Pump Import utility, 3.4.4

collection types supported by SQL*Loader, 7.10.2

collections, 7.10

loading, 11.6

column array rows

specifying number of, 12.5.5

column objects

loading, 11.1

with user-defined constructors, 11.1.6

COLUMNARRAYROWS parameter

SQL*Loader command line, 8.2.3

columns

exporting LONG datatypes, 21.14.2

loading REF columns, 11.3

naming

SQL*Loader, 10.3

objects

loading nested column objects, 11.1.3

stream record format, 11.1.1

variable record format, 11.1.2, 11.1.2

reordering before Import, 22.3.1

setting to a constant value with SQL*Loader, 10.13.2

setting to a unique sequence number with SQL*Loader, 10.13.6

setting to an expression value with SQL*Loader, 10.13.3

setting to null with SQL*Loader, 10.13.2.1

setting to the current date with SQL*Loader, 10.13.5

setting to the datafile record number with SQL*Loader, 10.13.4

specifying

SQL*Loader, 10.3

specifying as PIECED

SQL*Loader, 12.4.7.1

using SQL*Loader, 10.13.3

comments

in Export and Import parameter files, 21.3.3, 22.5.2

with external tables, 14.1, 15.1.1

COMMIT parameter

Import utility, 22.7.2

COMPILE parameter

Import utility, 22.7.3

completion messages

Export, 21.7.4

Import, 21.7.4

COMPRESS parameter

Export utility, 21.5.2

COMPRESSION parameter

Data Pump Export utility, 2.4.5

CONCATENATE parameter

SQL*Loader utility, 9.12

concurrent conventional path loads, 12.8.4

configuration

of LogMiner utility, 19.2.1

CONSISTENT parameter

Export utility, 21.5.3

nested tables and, 21.5.3

partitioned table and, 21.5.3

consolidating

extents, 21.5.2

CONSTANT parameter

SQL*Loader, 10.13.2

constraints

automatic integrity and SQL*Loader, 12.8.2.2

direct path load, 12.8

disabling referential constraints, 22.3.2

enabling

after a parallel direct path load, 12.9.7

enforced on a direct load, 12.8.1.1

failed

Import, 22.10.1.1

load method, 12.3.8

CONSTRAINTS parameter

Export utility, 21.5.4

Import utility, 22.7.4

constructors

attribute-value, 11.1.6

overriding, 11.1.6

user-defined, 11.1.6

loading column objects with, 11.1.6

CONTENT parameter

Data Pump Export utility, 2.4.6

Data Pump Import utility, 3.4.3

CONTINUE_CLIENT parameter

Data Pump Export utility

interactive-command mode, 2.5.2

Data Pump Import utility

interactive-command mode, 3.5.1

CONTINUEIF parameter

SQL*Loader utility, 9.12

control files

character sets, 9.10.5.3

data definition language syntax, 9.1

specifying data, 9.6

specifying SQL*Loader discard file, 9.9

CONTROL parameter

SQL*Loader command line, 8.2.4

conventional path Export

compared to direct path, 21.9

conventional path loads

behavior when discontinued, 9.11.1

compared to direct path loads, 12.3.7

concurrent, 12.9.1

of a single partition, 12.2

SQL*Loader bind array, 9.16.2

when to use, 12.2.2

conversion of character sets

during Export/Import, 21.12.1, 22.14.1

effect of character set sorting on, 21.12.1.1, 22.14.1.1

conversion of data

during direct path loads, 12.3.1

conversion of input characters, 9.10.5

CREATE REPORT command, ADRCI utility, 16.9.1

CREATE SESSION privilege

Export, 21.2.3, 22.2.2

Import, 21.2.3, 22.2.2

creating

incident package, 16.8.2

tables

manually, before import, 22.3.1

D

data

conversion

direct path load, 12.3.1

delimiter marks in data and SQL*Loader, 10.4.5.2

distinguishing different input formats for SQL*Loader, 9.15

distinguishing different input row object subtypes, 9.15, 9.15.3

exporting, 21.5.24

generating unique values with SQL*Loader, 10.13.6

including in control files, 9.6

loading data contained in the SQL*Loader control file, 10.13.1

loading in sections

SQL*Loader, 12.4.7.1

loading into more than one table

SQL*Loader, 9.15

maximum length of delimited data for SQL*Loader, 10.4.5.3

moving between operating systems using SQL*Loader, 10.7

recovery

SQL*Loader direct path load, 12.4.6

saving in a direct path load, 12.4.5

saving rows

SQL*Loader, 12.5.3

unsorted

SQL*Loader, 12.5.2.2

values optimized for SQL*Loader performance, 10.13.1

data fields

specifying the SQL*Loader datatype, 10.3.2

data files

specifying buffering for SQL*Loader, 9.7

specifying for SQL*Loader, 9.5

DATA parameter

SQL*Loader command line, 8.2.5

Data Pump Export utility

ATTACH parameter, 2.4.3

CLUSTER parameter, 2.4.4

command-line mode, 2.4, 3.4

COMPRESSION parameter, 2.4.5

CONTENT parameter, 2.4.6, 2.4.6

controlling resource consumption, 5.2.1

DATA_OPTIONS parameter, 2.4.7

dump file set, 2.1

DUMPFILE parameter, 2.4.9

encryption of SecureFiles, 2.4.10

ENCRYPTION parameter, 2.4.10

ENCRYPTION_ALGORITHM parameter, 2.4.11

ENCRYPTION_MODE parameter, 2.4.12

ENCRYPTION_PASSWORD parameter, 2.4.13

ESTIMATE parameter, 2.4.14

ESTIMATE_ONLY parameter, 2.4.15

EXCLUDE parameter, 2.4.16

excluding objects, 2.4.16

export modes, 2.2.2

FILESIZE command

interactive-command mode, 2.5.4

FILESIZE parameter, 2.4.17

filtering data that is exported

using EXCLUDE parameter, 2.4.16

using INCLUDE parameter, 2.4.22

FLASHBACK_SCN parameter, 2.4.18

FLASHBACK_TIME parameter, 2.4.19

FULL parameter, 2.4.20

HELP parameter

interactive-command mode, 2.5.5

INCLUDE parameter, 2.4.22

interactive-command mode, 2.5

ADD_FILE parameter, 2.5.1

CONTINUE_CLIENT parameter, 2.5.2

EXIT_CLIENT parameter, 2.5.3

FILESIZE, 2.5.4

HELP parameter, 2.5.5

KILL_JOB parameter, 2.5.6

PARALLEL parameter, 2.5.7

START_JOB parameter, 2.5.8

STATUS parameter, 2.5.9, 3.5.7

STOP_JOB parameter, 2.5.10, 3.5.8

interfaces, 2.2.1

invoking

as SYSDBA, 2.2, 3.2

job names

specifying, 2.4.23

JOB_NAME parameter, 2.4.23

LOGFILE parameter, 2.4.25

NETWORK_LINK parameter, 2.4.27

NOLOGFILE parameter, 2.4.28

PARALLEL parameter

command-line mode, 2.4.29

interactive-command mode, 2.5.7

PARFILE parameter, 2.4.30

QUERY parameter, 2.4.31

REMAP_DATA parameter, 2.4.32

REUSE_DUMPFILES parameter, 2.4.33

SAMPLE parameter, 2.4.34

SCHEMAS parameter, 2.4.35

SecureFiles LOB considerations, 1.8

SERVICE_NAME parameter, 2.4.36

SOURCE_EDITION parameter, 2.4.37

specifying a job name, 2.4.23

syntax diagrams, 2.7

TABLES parameter, 2.4.39

TABLESPACES parameter, 2.4.40

transparent data encryption, 2.4.13

TRANSPORT_FULL_CHECK parameter, 2.4.41

TRANSPORT_TABLESPACES parameter, 2.4.42

TRANSPORTABLE parameter, 2.4.43

transportable tablespace mode

and time zone file versions, 2.2.2.5

VERSION parameter, 2.4.44

versioning, 1.7

Data Pump Import utility

ATTACH parameter, 3.4.3

attaching to an existing job, 3.4.3

changing name of source datafile, 3.4.29

CLUSTER parameter, 3.4.4

command-line mode

NOLOGFILE parameter, 3.4.23

STATUS parameter, 3.4.39

CONTENT parameter, 3.4.5

controlling resource consumption, 5.2.1

DATA_OPTIONS parameter, 3.4.6

DIRECTORY parameter, 3.4.7

DUMPFILE parameter, 3.4.8

ENCRYPTION_PASSWORD parameter, 3.4.9

ESTIMATE parameter, 3.4.10

estimating size of job, 3.4.10

EXCLUDE parameter, 3.4.11

filtering data that is imported

using EXCLUDE parameter, 3.4.11

using INCLUDE parameter, 3.4.16

FLASHBACK_SCN parameter, 3.4.12

FLASHBACK_TIME parameter, 3.4.13

full import mode, 3.2.2.1

FULL parameter, 3.4.14

HELP parameter

command-line mode, 3.4.15

interactive-command mode, 3.5.3

INCLUDE parameter, 3.4.16

interactive-command mode, 3.5

CONTINUE_CLIENT parameter, 3.5.1

EXIT_CLIENT parameter, 3.5.2

HELP parameter, 3.5.3

KILL_JOB parameter, 3.5.4

START_JOB parameter, 3.5.6

STOP_JOB parameter, 3.5.8

interfaces, 3.2.1

JOB_NAME parameter, 3.4.17

LOGFILE parameter, 3.4.19

PARALLEL parameter

command-line mode, 3.4.24

interactive-command mode, 3.5.5

PARFILE parameter, 3.4.25

PARTITION_OPTIONS parameter, 3.4.26

QUERY parameter, 3.4.27

REMAP_DATA parameter, 3.4.28

REMAP_DATAFILE parameter, 3.4.29

REMAP_SCHEMA parameter, 3.4.30

REMAP_TABLE parameter, 3.4.31

REMAP_TABLESPACE parameter, 3.4.32

REUSE_DATAFILES parameter, 3.4.33

schema mode, 3.2.2.2

SCHEMAS parameter, 3.4.34

SERVICE_NAME parameter, 3.4.35

SKIP_UNUSABLE_INDEXES parameter, 3.4.36

SOURCE_EDITION parameter, 3.4.37

specifying a job name, 3.4.17

specifying dump file set to import, 3.4.8

SQLFILE parameter, 3.4.38

STREAMS_CONFIGURATION parameter, 3.4.40

syntax diagrams, 3.7

table mode, 3.2.2.3

TABLE_EXISTS_ACTION parameter, 3.4.41

TABLES parameter, 3.4.42

tablespace mode, 3.2.2.4

TABLESPACES parameter, 3.4.43

TARGET_EDITION parameter, 3.4.44

TRANSFORM parameter, 3.4.45

transparent data encryption, 3.4.9

TRANSPORT_DATAFILES parameter, 3.4.46

TRANSPORT_FULL_CHECK parameter, 3.4.47

TRANSPORT_TABLESPACES parameter, 3.4.48

TRANSPORTABLE parameter, 3.4.49

transportable tablespace mode, 3.2.2.5

and time zone file versions, 3.2.2.5

VERSION parameter, 3.4.50

versioning, 1.7

Data Pump legacy mode, 4

DATA_OPTIONS parameter

Data Pump Export utility, 2.4.7

Data Pump Import utility, 3.4.6

database ID (DBID)

changing, 18.3.1

database identifier

changing, 18.3.1

database migration

partitioning of, 21.17, 22.25

database name (DBNAME)

changing, 18.3.3

database objects

exporting LONG columns, 21.14.2

databases

changing the database ID, 18.3.1

changing the name, 18.3.3

exporting entire, 21.5.11

full import, 22.7.12

privileges for exporting and importing, 21.2.3, 22.2.2

reusing existing datafiles

Import, 22.7.7

datafiles

preventing overwrite during import, 22.7.7

reusing during import, 22.7.7

specifying, 8.2.5

specifying format for SQL*Loader, 9.7

DATAFILES parameter

Import utility, 22.7.6

DATAPUMP_EXP_FULL_DATABASE role, 1.3

DATAPUMP_IMP_FULL_DATABASE role, 1.3

datatypes

BFILEs

in original Export, 21.14.6

in original Import, 22.16.5

loading with SQL*Loader, 11.4

BLOBs

loading with SQL*Loader, 11.4

CLOBs

loading with SQL*Loader, 11.4

converting SQL*Loader, 10.4.3

describing for external table fields, 14.3.6

determining character field lengths for SQL*Loader, 10.4.7

determining DATE length, 10.4.7.3

identifying for external tables, 14.3.4

native

conflicting length specifications in SQL*Loader, 10.4.2.9

NCLOBs

loading with SQL*Loader, 11.4

nonscalar, 11.1.5

specifying in SQL*Loader, 10.3.2

supported by the LogMiner utility, 19.13.1

types used by SQL*Loader, 10.4

unsupported by LogMiner utility, 19.13.2

date cache feature

DATE_CACHE parameter, 8.2.6

external tables, 14.7

SQL*Loader, 12.5.6

DATE datatype

delimited form and SQL*Loader, 10.4.5

determining length, 10.4.7.3

mask

SQL*Loader, 10.4.7.3

DATE_CACHE parameter

SQL*Loader utility, 8.2.6

DBID (database identifier)

changing, 18.3.1

DBMS_DATAPUMP PL/SQL package, 6

DBMS_LOGMNR PL/SQL procedure

LogMiner utility and, 19.2.2

DBMS_LOGMNR_D PL/SQL procedure

LogMiner utility and, 19.2.2

DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure

LogMiner utility and, 19.2.2

DBMS_LOGMNR_D.BUILD PL/SQL procedure

LogMiner utility and, 19.2.2

DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure

LogMiner utility and, 19.2.2

DBMS_LOGMNR.ADD_LOGFILE PL/SQL procedure

ADDFILE option, 19.3.2

NEW option, 19.3.2

DBMS_LOGMNR.COLUMN_PRESENT function, 19.5.2

DBMS_LOGMNR.MINE_VALUE function, 19.5.2

null values and, 19.5.2.1

DBMS_LOGMNR.START_LOGMNR PL/SQL procedure, 19.4

calling multiple times, 19.8

COMMITTED_DATA_ONLY option, 19.6.1

CONTINUOUS_MINE option, 19.3.2

ENDTIME parameter, 19.6.3, 19.6.4

LogMiner utility and, 19.2.2

options for, 19.4

PRINT_PRETTY_SQL option, 19.6.6

SKIP_CORRUPTION option, 19.6.2

STARTTIME parameter, 19.6.3, 19.6.4

DBMS_METADATA PL/SQL package, 20.3.1

DBNAME

changing, 18.3.3

DBNEWID utility, 18

changing a database ID, 18.3.1

changing a database name, 18.3.3

effect on global database names, 18.2.1

restrictions, 18.4.2

syntax, 18.4

troubleshooting a database ID change, 18.3.4

DBVERIFY utility

output, 17.1.3

restrictions, 17

syntax, 17.1.1

validating a segment, 17.2

validating disk blocks, 17.1

default schema

as determined by SQL*Loader, 9.13.1.1

DEFAULTIF parameter

SQL*Loader, 10.5

DELETE ANY TABLE privilege

SQL*Loader, 9.13.2.2.4

DELETE CASCADE

effect on loading nonempty tables, 9.13.2.2.2

SQL*Loader, 9.13.2.2.4

DELETE privilege

SQL*Loader, 9.13.2.2.2

delimited data

maximum length for SQL*Loader, 10.4.5.3

delimited fields

field length, 10.4.7.2

delimited LOBs, 11.4.2.2.3

delimiters

in external tables, 14.2.3

loading trailing blanks, 10.4.5.4

marks in data and SQL*Loader, 10.4.5.2

specifying for external tables, 14.3.1

specifying for SQL*Loader, 9.13.5, 10.4.5

SQL*Loader enclosure, 10.10.2.2

SQL*Loader field specifications, 10.10.2.2

termination, 10.10.2.2

DESTROY parameter

Import utility, 22.7.7

dictionary

requirements for LogMiner utility, 19.2.1.2

dictionary version mismatch, 19.9.4

DIRECT parameter

Export utility, 21.5.5

direct path Export, 21.9, 21.10

compared to conventional path, 21.9

effect of EXEMPT ACCESS POLICY privilege, 21.10.1

performance issues, 21.10.2

restrictions, 21.10.3

security considerations, 21.10.1

direct path load

advantages, 12.3.4

behavior when discontinued, 9.11.2

choosing sort order

SQL*Loader, 12.5.2.4

compared to conventional path load, 12.3.7

concurrent, 12.9.3, 12.9.3

conditions for use, 12.3.5

data saves, 12.4.5, 12.5.3

DIRECT command-line parameter

SQL*Loader, 12.4.2

dropping indexes, 12.7

effect of disabling archiving, 12.5.4

effect of PRIMARY KEY constraints, 12.9.8

effect of UNIQUE KEY constraints, 12.9.8

field defaults, 12.3.9

improper sorting

SQL*Loader, 12.5.2.2

indexes, 12.4.3

instance recovery, 12.4.6

intersegment concurrency, 12.9.3

intrasegment concurrency, 12.9.3

location of data conversion, 12.3.1

media recovery, 12.4.6.1, 12.4.6.1

optimizing on multiple-CPU systems, 12.6

partitioned load

SQL*Loader, 12.8.4

performance, 12.4.3, 12.5

preallocating storage, 12.5.1

presorting data, 12.5.2

recovery, 12.4.6

ROWS command-line parameter, 12.4.5.1

setting up, 12.4.1

specifying, 12.4.2

specifying number of rows to be read, 8.2.23

SQL*Loader data loading method, 7.9.2

table insert triggers, 12.8.2

temporary segment storage requirements, 12.4.3.2

triggers, 12.8

using, 12.3.7, 12.4

version requirements, 12.3.5

directory aliases

exporting, 21.14.5

importing, 22.16.5

directory objects

using with Data Pump

effect of Oracle ASM, 1.6.2.2

DIRECTORY parameter

Data Pump Export utility, 2.4.8

Data Pump Import utility, 3.4.7

disabled unique indexes

loading tables with, 1.2

discard files

SQL*Loader, 9.9

specifying a maximum, 9.9.2

DISCARD parameter

SQL*Loader command-line, 8.2.8

discarded SQL*Loader records, 7.7

causes, 9.9.4

discard file, 9.9

limiting, 9.9.6

DISCARDMAX parameter

SQL*Loader command-line, 8.2.9

discontinued loads, 9.11

continuing, 9.11.5

conventional path behavior, 9.11.1

direct path behavior, 9.11.2

dropped snapshots

Import, 22.18.2.1

dump files

maximum size, 21.5.8

DUMPFILE parameter

Data Pump Export utility, 2.4.9

Data Pump Import utility, 3.4.8

E

EBCDIC character set

Import, 21.12.3, 22.14.3

ECHO command, ADRCI utility, 16.9.2

eight-bit character set support, 21.12.3, 22.14.3

enclosed fields

whitespace, 10.10.6

enclosure delimiters, 10.4.5

SQL*Loader, 10.10.2.2

encrypted columns

in external tables, 15.1.6

ENCRYPTION parameter

Data Pump Export utility, 2.4.10

ENCRYPTION_ALGORITHM parameter

Data Pump Export utility, 2.4.11

ENCRYPTION_MODE parameter

Data Pump Export utility, 2.4.12

ENCRYPTION_PASSWORD parameter

Data Pump Export utility, 2.4.13

Data Pump Import utility, 3.4.9

errors

caused by tab characters in SQL*Loader data, 10.2.1

LONG data, 22.10.1.2

object creation, 22.10.2.1

Import parameter IGNORE, 22.7.15

resource errors on import, 22.10.2.3

writing to export log file, 21.5.15

ERRORS parameter

SQL*Loader command line, 8.2.10

escape character

quoted strings and, 9.3.3.2

usage in Data Pump Export, 2.4

usage in Data Pump Import, 3.4

usage in Export, 21.5.26.1

usage in Import, 22.7.30

ESTIMATE parameter

Data Pump Export utility, 2.4.14

Data Pump Import utility, 3.4.10

ESTIMATE_ONLY parameter

Data Pump Export utility, 2.4.15

estimating size of job

Data Pump Export utility, 2.4.14

EVALUATE CHECK_CONSTRAINTS clause, 12.8.1.2

EXCLUDE parameter

Data Pump Export utility, 2.4.16

Data Pump Import utility, 3.4.11

exit codes

Export and Import, 21.8, 22.9

SQL*Loader, 1.9, 8.3

EXIT command, ADRCI utility, 16.9.3

EXIT_CLIENT parameter

Data Pump Export utility

interactive-command mode, 2.5.3

Data Pump Import utility

interactive-command mode, 3.5.2

EXP_FULL_DATABASE role

assigning in Export, 21.2.1, 22.2.1

expdat.dmp

Export output file, 21.5.7

Export

BUFFER parameter, 21.5.1

character set conversion, 21.12.1, 22.14.1

COMPRESS parameter, 21.5.2

CONSISTENT parameter, 21.5.3

CONSTRAINTS parameter, 21.5.4

conventional path, 21.9

creating

necessary privileges, 21.2.1, 22.2.1

necessary views, 21.2.1, 22.2.1

database optimizer statistics, 21.5.25

DIRECT parameter, 21.5.5

direct path, 21.9

displaying online help, 21.5.13

example sessions, 21.6

full database mode, 21.6.1

partition-level, 21.6.4

table mode, 21.6.3

user mode, 21.5.17, 21.6.2

exit codes, 21.8, 22.9

exporting an entire database, 21.5.11

exporting indexes, 21.5.14

exporting sequence numbers, 21.14.1

exporting synonyms, 21.14.11

exporting to another operating system, 21.5.20, 22.7.20

FEEDBACK parameter, 21.5.6

FILE parameter, 21.5.7

FILESIZE parameter, 21.5.8

FLASHBACK_SCN parameter, 21.5.9

FLASHBACK_TIME parameter, 21.5.10

full database mode

example, 21.6.1

FULL parameter, 21.5.11

GRANTS parameter, 21.5.12

HELP parameter, 21.5.13

INDEXES parameter, 21.5.14

invoking, 21.3, 22.5

log files

specifying, 21.5.15

LOG parameter, 21.5.15

logging error messages, 21.5.15

LONG columns, 21.14.2

OBJECT_CONSISTENT parameter, 21.5.16

online help, 21.3.5

OWNER parameter, 21.5.17

parameter file, 21.5.18

maximum size, 21.3.3, 22.5.2

parameter syntax, 21.5

PARFILE parameter, 21.5.18

partitioning a database migration, 21.17, 22.25

QUERY parameter, 21.5.19

RECORDLENGTH parameter, 21.5.20

redirecting output to a log file, 21.7.1

remote operation, 21.11.2, 22.13

restrictions based on privileges, 21.2.3

RESUMABLE parameter, 21.5.21

RESUMABLE_NAME parameter, 21.5.22

RESUMABLE_TIMEOUT parameter, 21.5.23

ROWS parameter, 21.5.24

sequence numbers, 21.14.1

STATISTICS parameter, 21.5.25

storage requirements, 21.2.2

table mode

example session, 21.6.3

table name restrictions, 21.5.26.1

TABLES parameter, 21.5.26

TABLESPACES parameter, 21.5.27

TRANSPORT_TABLESPACE parameter, 21.5.28

TRIGGERS parameter, 21.5.29

TTS_FULL_CHECK parameter, 21.5.30

user access privileges, 21.2.3, 22.2.2

user mode

example session, 21.5.17, 21.6.2

specifying, 21.5.17

USERID parameter, 21.5.31

VOLSIZE parameter, 21.5.32

export dump file

importing the entire file, 22.7.12

export file

listing contents before importing, 22.7.25

specifying, 21.5.7

exporting

archived LOBs, 2.4.44

EXPRESSION parameter

SQL*Loader, 10.13.3, 10.13.3.1

extents

consolidating, 21.5.2

EXTERNAL parameter

SQL*Loader, 10.4.2.5

EXTERNAL SQL*Loader datatypes

numeric

determining len, 10.4.7

external tables

access parameters, 13.1.2, 14.1, 15.1

and encrypted columns, 15.1.6

big-endian data, 14.2.8

cacheing data during reads, 14.2.23

column_transforms clause, 14.1

datatypes, 14.3.6

date cache feature, 14.7

delimiters, 14.2.3

describing datatype of a field, 14.3.6

field_definitions clause, 14.1, 14.3

fixed-length records, 14.2.1

identifying character sets, 14.2.4

identifying datatypes, 14.3.4

improving performance when using

date cache feature, 14.7

IO_OPTIONS clause, 14.2.23

little-endian data, 14.2.8

opaque_format_spec, 13.1.2, 14.1, 15.1

preprocessing data, 14.2.5

record_format_info clause, 14.1, 14.2

reserved words, 13.3, 14.8, 15.6

restrictions, 13.3, 14.8

setting a field to a default value, 14.3.7

setting a field to null, 14.3.7

skipping records when loading data, 14.2.15

specifying delimiters, 14.3.1

specifying load conditions, 14.2.11

trimming blanks, 14.3.2

use of SQL strings, 13.3, 14.8

using comments, 14.1, 15.1.1

variable-length records, 14.2.2

EXTERNAL_TABLE parameter

SQL*Loader, 8.2.11

F

fatal errors

See nonrecoverable error messages

FEEDBACK parameter

Export utility, 21.5.6

Import utility, 22.7.8

field conditions

specifying for SQL*Loader, 10.5

field length

SQL*Loader specifications, 10.10.2

field location

SQL*Loader, 10.2

fields

character data length and SQL*Loader, 10.4.7

comparing to literals with SQL*Loader, 10.5.2

delimited

determining length, 10.4.7.2

SQL*Loader, 10.4.5

loading all blanks, 10.9

predetermined size

length, 10.4.7.1

SQL*Loader, 10.10.2.1

relative positioning and SQL*Loader, 10.10.3

specifying default delimiters for SQL*Loader, 9.13.5

specifying for SQL*Loader, 10.3

SQL*Loader delimited

specifications, 10.10.2.2

FIELDS clause

SQL*Loader, 9.13.5

terminated by whitespace, 10.10.4.1

file names

quotation marks and, 9.3.3.1

specifying multiple SQL*Loader, 9.5.2

SQL*Loader, 9.3

SQL*Loader bad file, 9.8

FILE parameter

Export utility, 21.5.7

Import utility, 22.7.9

SQL*Loader utility, 12.9.6.1

FILESIZE parameter

Data Pump Export utility, 2.4.17

Export utility, 21.5.8

Import utility, 22.7.10

FILLER field

using as argument to init_spec, 10.3.1

filtering data

using Data Pump Export utility, 2.1

using Data Pump Import utility, 3.1

filtering metadata that is imported

Data Pump Import utility, 3.4.11

finalizing

in ADRCI utility, 16.2

fine-grained access support

Export and Import, 22.17

fixed-format records, 7.4.1

fixed-length records

external tables, 14.2.1

FLASHBACK_SCN parameter

Data Pump Export utility, 2.4.18

Data Pump Import utility, 3.4.12

Export utility, 21.5.9

FLASHBACK_TIME parameter

Data Pump Export utility, 2.4.19

Data Pump Import utility, 3.4.13

Export utility, 21.5.10

FLOAT EXTERNAL data values

SQL*Loader, 10.4.2.5

foreign function libraries

exporting, 21.14.3

importing, 22.16.6, 22.16.9

formats

SQL*Loader input records and, 9.15.2

formatting errors

SQL*Loader, 9.8

FROMUSER parameter

Import utility, 22.7.11

full database mode

Import, 22.7.12

specifying with FULL, 21.5.11

full export mode

Data Pump Export utility, 2.2.2.1

FULL parameter

Data Pump Export utility, 2.4.20

Data Pump Import utility, 3.4.14

Export utility, 21.5.11

Import utility, 22.7.12

G

globalization

SQL*Loader, 9.10

grants

exporting, 21.5.12

importing, 22.7.13

GRANTS parameter

Export utility, 21.5.12

Import utility, 22.7.13

H

HELP parameter

Data Pump Export utility

command-line mode, 2.4.21

interactive-command mode, 2.5.5

Data Pump Import utility

command-line mode, 3.4.15

interactive-command mode, 3.5.3

Export utility, 21.5.13

Import utility, 22.7.14

hexadecimal strings

SQL*Loader, 10.5.2

homepath

in ADRCI utility, 16.2

HOST command, ADRCI utility, 16.9.4

I

IGNORE parameter

Import utility, 22.7.15

IMP_FULL_DATABASE role

assigning in Import, 21.2.1, 22.2.1

Import

BUFFER parameter, 22.7.1

character set conversion, 21.12.1, 21.12.3, 22.14.1, 22.14.3

COMMIT parameter, 22.7.2

committing after array insert, 22.7.2

COMPILE parameter, 22.7.3

CONSTRAINTS parameter, 22.7.4

creating

necessary privileges, 21.2.1, 22.2.1

necessary views, 21.2.1, 22.2.1

creating an index-creation SQL script, 22.7.17

database optimizer statistics, 22.7.27

DATAFILES parameter, 22.7.6

DESTROY parameter, 22.7.7

disabling referential constraints, 22.3.2, 22.3.2

displaying online help, 22.7.14

dropping a tablespace, 22.22

errors importing database objects, 22.10.2

example sessions, 22.8

all tables from one user to another, 22.8.3

selected tables for specific user, 22.8.1

tables exported by another user, 22.8.2

using partition-level Import, 22.8.4

exit codes, 21.8, 22.9

export file

importing the entire file, 22.7.12

listing contents before import, 22.7.25

FEEDBACK parameter, 22.7.8

FILE parameter, 22.7.9

FILESIZE parameter, 22.7.10

FROMUSER parameter, 22.7.11

FULL parameter, 22.7.12

grants

specifying for import, 22.7.13

GRANTS parameter, 22.7.13

HELP parameter, 22.7.14

IGNORE parameter, 22.7.15

importing grants, 22.7.13

importing objects into other schemas, 22.2.2.3

importing rows, 22.7.24

importing tables, 22.7.30

INDEXES parameter, 22.7.16

INDEXFILE parameter, 22.7.17

INSERT errors, 22.10.1.2

invalid data, 22.10.1.2

invoking, 21.3, 22.5

LOG parameter, 22.7.18

LONG columns, 22.16.11, 22.16.11

manually creating tables before import, 22.3.1

manually ordering tables, 22.3.3

NLS_LANG environment variable, 21.12.3, 22.14.3

object creation errors, 22.7.15

online help, 21.3.5

parameter file, 22.7.19

maximum size, 21.3.3, 22.5.2

parameter syntax, 22.7

PARFILE parameter, 22.7.19

partition-level, 22.11

pattern matching of table names, 22.7.30

read-only tablespaces, 22.21

RECORDLENGTH parameter, 22.7.20

records

specifying length, 22.7.20

redirecting output to a log file, 21.7.1

refresh error, 22.18.1

remote operation, 21.11.2, 22.13

reorganizing tablespace during, 22.23

resource errors, 22.10.2.3

restrictions

importing into own schema, 22.2.2.1

RESUMABLE parameter, 22.7.21

RESUMABLE_NAME parameter, 22.7.22

RESUMABLE_TIMEOUT parameter, 22.7.23

reusing existing datafiles, 22.7.7

rows

specifying for import, 22.7.24

ROWS parameter, 22.7.24

schema objects, 22.2.2.3

sequences, 22.10.2.2

SHOW parameter, 22.7.25

single-byte character sets, 21.12.3, 22.14.3

SKIP_UNUSABLE_INDEXES parameter, 22.7.26

snapshot master table, 22.18.1

snapshots, 22.18

restoring dropped, 22.18.2.1

specifying by user, 22.7.11

specifying index creation commands, 22.7.17

specifying the export file, 22.7.9

STATISTICS parameter, 22.7.27

storage parameters

overriding, 22.20.3

stored functions, 22.16.7

stored procedures, 22.16.7

STREAMS_CONFIGURATION parameter, 22.7.28

STREAMS_INSTANTIATION parameter, 22.7.29

system objects, 22.2.2.4

table name restrictions, 2.4.39, 3.4.42, 22.7.30.1

table objects

import order, 22.1.1

table-level, 22.11

TABLES parameter, 22.7.30

TABLESPACES parameter, 22.7.31

TOID_NOVALIDATE parameter, 22.7.32

TOUSER parameter, 22.7.33

TRANSPORT_TABLESPACE parameter, 22.7.34

TTS_OWNER parameter, 22.7.35

tuning considerations, 22.26

user access privileges, 21.2.3, 22.2.2

USERID parameter, 22.7.36

VOLSIZE parameter, 22.7.37

incident

fault diagnosability infrastructure, 16.2

packaging, 16.8

incident package

fault diagnosability infrastructure, 16.2

INCLUDE parameter

Data Pump Export utility, 2.4.22

Data Pump Import utility, 3.4.16

index options

SORTED INDEXES with SQL*Loader, 9.14.1

SQL*Loader SINGLEROW parameter, 9.14.2

Index Unusable state

indexes left in Index Unusable state, 9.11.3, 12.4.4

indexes

creating manually, 22.7.17

direct path load

left in direct load state, 12.4.4

dropping

SQL*Loader, 12.7

estimating storage requirements, 12.4.3.1

exporting, 21.5.14

importing, 22.7.16

index-creation commands

Import, 22.7.17

left in unusable state, 9.11.3, 12.5.2.2

multiple-column

SQL*Loader, 12.5.2.3

presorting data

SQL*Loader, 12.5.2

skipping maintenance, 8.2.26, 12.7

skipping unusable, 8.2.27, 12.7

SQL*Loader, 9.14

state after discontinued load, 9.11.3

unique, 22.7.16

INDEXES parameter

Export utility, 21.5.14

Import utility, 22.7.16

INDEXFILE parameter

Import utility, 22.7.17

INFILE parameter

SQL*Loader utility, 9.5

insert errors

Import, 22.10.1.2

specifying, 8.2.10

INSERT into table

SQL*Loader, 9.13.2.1.1

instance affinity

Export and Import, 21.13

instance recovery, 12.4.6.2

integrity constraints

disabled during direct path load, 12.8.1.2

enabled during direct path load, 12.8.1.1

failed on Import, 22.10.1.1

load method, 12.3.8

interactive method

Data Pump Export utility, 2.2.1

internal LOBs

loading, 11.4.1

interrupted loads, 9.11

INTO TABLE statement

effect on bind array size, 9.16.6

multiple statements with SQL*Loader, 9.15

SQL*Loader, 9.13

column names, 10.3

discards, 9.9.4

invalid data

Import, 22.10.1.2

invoking

Export, 21.3, 22.5

at the command line, 21.3.2, 22.5.1

direct path, 21.10

interactively, 21.3.4, 22.5.3

with a parameter file, 21.3.3, 22.5.2

Import, 21.3, 22.5

as SYSDBA, 21.3.1, 22.5.4

at the command line, 21.3.2, 22.5.1

interactively, 21.3.4, 22.5.3

with a parameter file, 21.3.3, 22.5.2

IPS command, ADRCI utility, 16.9.5

J

JOB_NAME parameter

Data Pump Export utility, 2.4.23

Data Pump Import utility, 3.4.17

K

key values

generating with SQL*Loader, 10.13.6

KILL_JOB parameter

Data Pump Export utility

interactive-command mode, 2.5.6

Data Pump Import utility, 3.5.4

L

leading whitespace

definition, 10.10.1

trimming and SQL*Loader, 10.10.4

legacy mode in Data Pump, 4

length indicator

determining size, 9.16.4.1

length-value pair specified LOBs, 11.4.2.2.4

libraries

foreign function

exporting, 21.14.3

importing, 22.16.6, 22.16.9

little-endian data

external tables, 14.2.8

LOAD parameter

SQL*Loader command line, 8.2.13

collections, 11.6

column objects, 11.1

in variable record format, 11.1.2

with a derived subtype, 11.1.4

with user-defined constructors, 11.1.6

datafiles containing tabs

SQL*Loader, 10.2.1

external table data

skipping records, 14.2.15

specifying conditions, 14.2.8, 14.2.20

LOBs, 11.4

nested column objects, 11.1.3

object tables, 11.2

object tables with a subtype, 11.2.1

REF columns, 11.3

subpartitioned tables, 12.3.2

tables, 12.3.2

LOB data

in delimited fields, 11.4.1.2

in length-value pair fields, 11.4.1.3

in predetermined size fields, 11.4.1.1

loading with SQL*Loader, 11.4

no compression during export, 21.5.2

size of read buffer, 8.2.19

types supported by SQL*Loader, 7.10.3, 11.4

LOB data types, 7.5

LOBFILEs, 7.5, 11.4, 11.4.2

log files

after a discontinued load, 9.11.4

Export, 21.5.15, 21.7.1

Import, 21.7.1, 22.7.18

specifying for SQL*Loader, 8.2.14

SQL*Loader, 7.8

LOG parameter

Export utility, 21.5.15

Import utility, 22.7.18

SQL*Loader command line, 8.2.14

LOGFILE parameter

Data Pump Export utility, 2.4.25

Data Pump Import utility, 3.4.19

logical records

consolidating multiple physical records using SQL*Loader, 9.12

LogMiner utility

accessing redo data of interest, 19.5

adjusting redo log file list, 19.8

analyzing output, 19.5.1

configuration, 19.2.1

considerations for reapplying DDL statements, 19.7

current log file list

stored information about, 19.10.1

DBMS_LOGMNR PL/SQL procedure and, 19.2.2

DBMS_LOGMNR_D PL/SQL procedure and, 19.2.2

DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and, 19.2.2

DBMS_LOGMNR_D.BUILD PL/SQL procedure and, 19.2.2

DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and, 19.2.2

DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and, 19.2.2

DDL tracking

time or SCN ranges, 19.9.6

determining redo log files being analyzed, 19.3.2

dictionary

purpose of, 19.2.1

dictionary extracted to flat file

stored information about, 19.10

dictionary options, 19.3.1

flat file and, 19.3.1

online catalog and, 19.3.1

redo log files and, 19.3.1

ending a session, 19.11.6

executing reconstructed SQL, 19.6.5

extracting data values from redo logs, 19.5.2

filtering data by SCN, 19.6.4

filtering data by time, 19.6.3

formatting returned data, 19.6.6

graphical user interface, 19

levels of supplemental logging, 19.9

LogMiner dictionary defined, 19.2.1

mining a subset of data in redo log files, 19.8

mining database definition for, 19.2.1

operations overview, 19.2.2

parameters

stored information about, 19.10

redo log files

on a remote database, 19.8

stored information about, 19.10

requirements for dictionary, 19.2.1.2

requirements for redo log files, 19.2.1.2

requirements for source and mining databases, 19.2.1.2

restrictions with XMLType data, 19.5.3.1

sample configuration, 19.2.1.1

showing committed transactions only, 19.6.1

skipping corruptions, 19.6.2

source database definition for, 19.2.1

specifying redo log files to mine, 19.3.2

automatically, 19.3.2

manually, 19.3.2

specifying redo logs for analysis, 19.11.3

starting, 19.4, 19.11.4

starting multiple times within a session, 19.8

steps for extracting dictionary to a flat file, 19.3.1.3

steps for extracting dictionary to redo log files, 19.3.1.2

steps for using dictionary in online catalog, 19.3.1.1

steps in a typical session, 19.11

supplemental log groups, 19.9

conditional, 19.9

unconditional, 19.9

supplemental logging, 19.9

database level, 19.9.1

database-level identification keys, 19.9.1.2

disabling database-level, 19.9.2

interactions with DDL tracking, 19.9.5

log groups, 19.9

minimal, 19.9.1.1

stored information about, 19.10

table-level identification keys, 19.9.3.1

table-level log groups, 19.9.3.2

user-defined log groups, 19.9.3.3

support for transparent data encryption, 19.5

supported database versions, 19.13.3

supported datatypes, 19.13.1

supported redo log file versions, 19.13.3

suppressing delimiters in SQL_REDO and SQL_UNDO, 19.6.5

table-level supplemental logging, 19.9.3

tracking DDL statements, 19.9.4

requirements, 19.9.4

unsupported datatypes, 19.13.2

using the online catalog, 19.3.1.1

using to analyze redo log files, 19

V$DATABASE view, 19.10

V$LOGMNR_CONTENTS view, 19.2.2, 19.5.1, 19.6

V$LOGMNR_DICTIONARY view, 19.10

V$LOGMNR_LOGS view, 19.10

querying, 19.10.1

V$LOGMNR_PARAMETERS view, 19.9.6, 19.10

views, 19.10

LogMiner Viewer, 19

LONG data

exporting, 21.14.2

importing, 22.16.11

M

master tables

Oracle Data Pump API, 1.4.2

snapshots

original Import, 22.18.1

materialized views, 22.18

media recovery

direct path load, 12.4.6.1

Metadata API

enhancing performance, 20.7

retrieving collections, 20.5

using to retrieve object metadata, 20.3

missing data columns

SQL*Loader, 9.13.6

multibyte character sets

blanks with SQL*Loader, 10.5.1

SQL*Loader, 9.10.1

multiple-column indexes

SQL*Loader, 12.5.2.3

multiple-CPU systems

optimizing direct path loads, 12.6

multiple-table load

generating unique sequence numbers using SQL*Loader, 10.13.7

SQL*Loader control file specification, 9.15

multithreading

on multiple-CPU systems, 12.6

MULTITHREADING parameter

SQL*Loader command line, 8.2.15

N

named pipes

external table loads, 7.9.3

native datatypes

conflicting length specifications

SQL*Loader, 10.4.2.9

NCLOBs

loading with SQL*Loader, 11.4

nested column objects

loading, 11.1.3

nested tables

exporting, 21.14.9

consistency and, 21.5.3

importing, 22.16.3

NETWORK_LINK parameter

Data Pump Export utility, 2.4.27

Data Pump Import utility, 3.4.22

networks

Export and Import, 21.11, 22.13

NLS_LANG environment variable, 21.12.2, 22.14.2

with Export and Import, 21.12.3, 22.14.3

NO_INDEX_ERRORS parameter

SQL*Loader command line, 8.2.16

NOLOGFILE parameter

Data Pump Export utility, 2.4.28

Data Pump Import utility, 3.4.23

nonrecoverable error messages

Export, 21.7.3

Import, 21.7.3

nonscalar datatypes, 11.1.5

NOT NULL constraint

load method, 12.3.8

null data

missing columns at end of record during load, 9.13.6

unspecified columns and SQL*Loader, 10.3

NULL values

objects, 11.1.5

NULLIF clause

SQL*Loader, 10.5, 10.9

NULLIF...BLANKS clause

SQL*Loader, 10.5.1

nulls

atomic, 11.1.5.2

attribute, 11.1.5.1

NUMBER datatype

SQL*Loader, 10.4.3, 10.4.4

numeric EXTERNAL datatypes

delimited form and SQL*Loader, 10.4.5

determining length, 10.4.7

O

object identifiers, 11.2

importing, 22.16.1

object names

SQL*Loader, 9.3

object tables

loading, 11.2, 11.2

with a subtype

loading, 11.2.1

object type definitions

exporting, 21.14.8

object types supported by SQL*Loader, 7.10.1

OBJECT_CONSISTENT parameter

Export utility, 21.5.16

objects, 7.10

creation errors, 22.10.2.1

ignoring existing objects during import, 22.7.15

import creation errors, 22.7.15

loading nested column objects, 11.1.3

NULL values, 11.1.5

stream record format, 11.1.1

variable record format, 11.1.2

offline locally managed tablespaces

exporting, 21.14.4

OID

See object identifiers

online help

Export and Import, 21.3.5

opaque_format_spec, 13.1.2, 14.1, 15.1

operating systems

moving data to different systems using SQL*Loader, 10.7

OPTIMAL storage parameter

used with Export/Import, 22.20.1

optimizer statistics, 22.24

optimizing

direct path loads, 12.5

SQL*Loader input file processing, 9.7

OPTIONALLY ENCLOSED BY clause

SQL*Loader, 10.10.2.2

OPTIONS parameter

for parallel loads, 9.13.3

SQL*Loader utility, 9.2.1

Oracle Advanced Queuing

See Advanced Queuing

Oracle Automatic Storage Management (ASM)

Data Pump and, 1.6.2.2

Oracle Data Pump

direct path loads

restrictions, 1.2.2

master table, 1.4.2

tuning performance, 5.2

Oracle Data Pump API, 6

client interface, 6.1

job states, 6.1.1

monitoring job progress, 1.5.1

ORACLE_DATAPUMP access driver

effect of SQL ENCRYPT clause on, 15.1.6

reserved words, 15, 15.7

ORACLE_LOADER access driver

reserved words, 14, 14.9

OWNER parameter

Export utility, 21.5.17

P

packages

creating, 16.8.2

padding of literal strings

SQL*Loader, 10.5.2

parallel loads, 12.9

restrictions on direct path, 12.9.4

when using PREPROCESSOR clause, 14.2.5.1

PARALLEL parameter

Data Pump Export utility

command-line interface, 2.4.29

interactive-command mode, 2.5.7

Data Pump Import utility

command-line mode, 3.4.24

interactive-command mode, 3.5.5

SQL*Loader command line, 8.2.17

parameter files

Export, 21.5.18

Export and Import

comments in, 21.3.3, 22.5.2

maximum size, 21.3.3, 22.5.2

Import, 22.7.19

SQL*Loader, 8.2.18

PARFILE parameter

Data Pump Export utility, 2.4.30

Data Pump Import utility, 3.4.25

Export command line, 21.5.18

Import command line, 22.7.19

SQL*Loader command line, 8.2.18

PARTITION_OPTIONS parameter

Data Pump Import utility, 3.4.26

partitioned loads

concurrent conventional path loads, 12.8.4

SQL*Loader, 12.8.4

partitioned object support in SQL*Loader, 7.11

partitioned tables

export consistency and, 21.5.3

exporting, 21.4.1

importing, 22.8.1, 22.11.1

loading, 12.3.2

partitioning a database migration, 21.17, 22.25

advantages of, 21.17, 22.25

disadvantages of, 21.17, 22.25

procedure during export, 21.17.3, 22.25.3

partition-level Export, 21.4.1

example session, 21.6.4

partition-level Import, 22.11

specifying, 21.5.26

pattern matching

table names during import, 22.7.30

performance

improving when using integrity constraints, 12.8.4

optimizing for direct path loads, 12.5

optimizing reading of SQL*Loader data files, 9.7

tuning original Import, 22.26

performance tuning

Oracle Data Pump, 5.2

PIECED parameter

SQL*Loader, 12.4.7.1

POSITION parameter

using with data containing tabs, 10.2.1

with multiple SQL*Loader INTO TABLE clauses, 9.15.2.1, 10.2, 10.2.2

predetermined size fields

SQL*Loader, 10.10.2.1

predetermined size LOBs, 11.4.2.2.2

preprocessing data for external tables, 14.2.5

effects of parallel processing, 14.2.5.1

prerequisites

SQL*Loader, 12.1

PRESERVE parameter, 9.12.2

preserving

whitespace, 10.11

PRIMARY KEY constraints

effect on direct path load, 12.9.8

primary key OIDs

example, 11.2

primary key REF columns, 11.3.3, 11.3.3

privileges

EXEMPT ACCESS POLICY

effect on direct path export, 21.10.1

required for Export and Import, 21.2.1, 22.2.1

required for SQL*Loader, 12.1

problem

fault diagnosability infrastructure, 16.2

problem key

fault diagnosability infrastructure, 16.2

PURGE command, ADRCI utility, 16.9.6

Q

QUERY parameter

Data Pump Export utility, 2.4.31

Data Pump Import utility, 3.4.27

Export utility, 21.5.19

restrictions, 21.5.19.1

QUIT command, ADRCI utility, 16.9.7

quotation marks

escape characters and, 9.3.3.2

file names and, 9.3.3.1

SQL strings and, 9.3.2

table names and, 2.4.39, 3.4.42, 21.5.26.1, 22.7.30.1

usage in Data Pump Export, 2.4

usage in Data Pump Import, 3.4

use with database object names, 9.3.1

R

read-consistent export, 21.5.3

read-only tablespaces

Import, 22.21

READSIZE parameter

SQL*Loader command line, 8.2.19

effect on LOBs, 8.2.19

maximum size, 8.2.19

RECNUM parameter

use with SQL*Loader SKIP parameter, 10.13.4

RECORDLENGTH parameter

Export utility, 21.5.20

Import utility, 22.7.20

records

consolidating into a single logical record

SQL*Loader, 9.12

discarded by SQL*Loader, 7.7, 9.9

DISCARDMAX command-line parameter, 8.2.9

distinguishing different formats for SQL*Loader, 9.15.2

extracting multiple logical records using SQL*Loader, 9.15

fixed format, 7.4.1

missing data columns during load, 9.13.6

rejected by SQL*Loader, 7.7, 7.7.1.1, 7.7.1.2, 9.8

setting column to record number with SQL*Loader, 10.13.4

specifying how to load, 8.2.13

specifying length for export, 21.5.20

specifying length for import, 22.7.20

stream record format, 7.4.3

recovery

direct path load

SQL*Loader, 12.4.6

replacing rows, 9.13.2.2

redo log file

LogMiner utility

versions supported, 19.13.3

redo log files

analyzing, 19

requirements for LogMiner utility, 19.2.1.2

specifying for the LogMiner utility, 19.3.2

redo logs

direct path load, 12.4.6.1

instance and media recovery

SQL*Loader, 12.4.6.1

minimizing use during direct path loads, 12.5.4

saving space

direct path load, 12.5.4.2

REF columns, 11.3

loading, 11.3

primary key, 11.3.3

system-generated, 11.3.2

REF data

importing, 22.16.4

referential integrity constraints

disabling for import, 22.3.2

SQL*Loader, 12.8

refresh error

snapshots

Import, 22.18.1

reject files

specifying for SQL*Loader, 9.8

rejected records

SQL*Loader, 7.7, 9.8

relative field positioning

where a field starts and SQL*Loader, 10.10.3

with multiple SQL*Loader INTO TABLE clauses, 9.15.1.1

REMAP_DATA parameter

Data Pump Export utility, 2.4.32

Data Pump Import utility, 3.4.28

REMAP_DATAFILE parameter

Data Pump Import utility, 3.4.29

REMAP_SCHEMA parameter

Data Pump Import utility, 3.4.30

REMAP_TABLE parameter

Data Pump Import utility, 3.4.31

REMAP_TABLESPACE parameter

Data Pump Import utility, 3.4.32

remote operation

Export/Import, 21.11.2, 22.13

REPLACE table

replacing a table using SQL*Loader, 9.13.2.2.2

reserved words

external tables, 13.3, 14.8, 15.6

ORACLE_DATAPUMP access driver, 15, 15.7

ORACLE_LOADER access driver, 14, 14.9

SQL*Loader, 7.3

resource consumption

controlling in Data Pump Export utility, 5.2.1

controlling in Data Pump Import utility, 5.2.1

resource errors

Import, 22.10.2.3

RESOURCE role, 22.2.2.1

restrictions

importing into another user's schema, 22.2.2.3

table names in Export parameter file, 21.5.26.1

table names in Import parameter file, 2.4.39, 3.4.42, 22.7.30.1

RESUMABLE parameter

Export utility, 21.5.21

Import utility, 22.7.21

SQL*Loader utility, 8.2.20

resumable space allocation

enabling and disabling, 8.2.20, 21.5.21, 22.7.21

RESUMABLE_NAME parameter

Export utility, 21.5.22

Import utility, 22.7.22

SQL*Loader utility, 8.2.21

RESUMABLE_TIMEOUT parameter

Export utility, 21.5.23

Import utility, 22.7.23

SQL*Loader utility, 8.2.22

retrieving object metadata

using Metadata API, 20.3

REUSE_DATAFILES parameter

Data Pump Import utility, 3.4.33

REUSE_DUMPFILES parameter

Data Pump Export utility, 2.4.33

roles

DATAPUMP_EXP_FULL_DATABASE, 1.3

DATAPUMP_IMP_FULL_DATABASE, 1.3

EXP_FULL_DATABASE, 21.2.1

IMP_FULL_DATABASE, 22.2.1

RESOURCE, 22.2.2.1

rollback segments

effects of CONSISTENT Export parameter, 21.5.3

row errors

Import, 22.10.1.1

ROWID columns

loading with SQL*Loader, 12.1.1

rows

choosing which to load using SQL*Loader, 9.13.4

exporting, 21.5.24

specifying for import, 22.7.24

specifying number to insert before save

SQL*Loader, 12.4.5.1

updates to existing rows with SQL*Loader, 9.13.2.2.3

ROWS parameter

Export utility, 21.5.24

Import utility, 22.7.24

performance issues

SQL*Loader, 12.5.3

SQL*Loader command line, 8.2.23

using to specify when data saves occur, 12.4.5.1

RUN command, ADRCI utility, 16.9.8

S

SAMPLE parameter

Data Pump Export utility, 2.4.34

schema mode export

Data Pump Export utility, 2.2.2.2

schemas

specifying for Export, 21.5.26

SCHEMAS parameter

Data Pump Export utility, 2.4.35

Data Pump Import utility, 3.4.34

scientific notation for FLOAT EXTERNAL, 10.4.2.5

script files

running before Export and Import, 21.2.1, 22.2.1

SDFs

See secondary datafiles

secondary datafiles, 7.5, 11.6.2

SecureFiles

encryption during Data Pump export, 2.4.10

SecureFiles LOBs

export considerations, 1.8

security considerations

direct path export, 21.10.1

segments

temporary

FILE parameter in SQL*Loader, 12.9.6.1

SELECT command, ADRCI utility, 16.9.9

functions, 16.9.9

sequence numb, 10.13.6

sequence numbers

cached, 21.14.1

exporting, 21.14.1

for multiple tables and SQL*Loader, 10.13.7

generated by SQL*Loader SEQUENCE clause, 10.13.6

generated, not read and SQL*Loader, 10.3

SERVICE_NAME parameter

Data Pump Export utility, 2.4.36

Data Pump Import utility, 3.4.35

SET BASE command, ADRCI utility, 16.9.10

SET BROWSER command, ADRCI utility, 16.9.11

SET CONTROL command, ADRCI utility, 16.9.12

SET ECHO command, ADRCI utility, 16.9.13

SET EDITOR command, ADRCI utility, 16.9.14

SET HOMEPATH command, ADRCI utility, 16.9.15

SET TERMOUT command, ADRCI utility, 16.9.16

short records with missing data

SQL*Loader, 9.13.6

SHOW ALERT command, ADRCI utility, 16.9.17

SHOW BASE command, ADRCI utility, 16.9.18

SHOW CONTROL command, ADRCI utility, 16.9.19

SHOW HM_RUN command, ADRCI utility, 16.9.20

SHOW HOMEPATH command, ADRCI utility, 16.9.21

SHOW HOMES command, ADRCI utility, 16.9.22

SHOW INCDIR command, ADRCI utility, 16.9.23

SHOW INCIDENT command, ADRCI utility, 16.9.24

SHOW parameter

Import utility, 22.7.25

SHOW PROBLEM command, ADRCI utility, 16.9.25

SHOW REPORT command, ADRCI utility, 16.9.26

SHOW TRACEFILE command, ADRCI utility, 16.9.27

SILENT parameter

SQL*Loader command line, 8.2.24

single-byte character sets

Export and Import, 21.12.3, 22.14.3

SINGLEROW parameter, 9.14.2, 12.7

single-table loads

continuing, 9.11.5

SKIP parameter

effect on SQL*Loader RECNUM specification, 10.13.4

SQL*Loader command line, 8.2.25, 8.2.25

SKIP_INDEX_MAINTENANCE parameter

SQL*Loader command line, 8.2.26, 12.7

SKIP_UNUSABLE_INDEXES parameter

Import utility, 22.7.26

SQL*Loader command line, 8.2.27, 12.7

SKIP_USABLE_INDEXES parameter

Data Pump Import utility, 3.4.36

skipping index maintenance, 8.2.26, 12.7

skipping unusable indexes, 8.2.27, 12.7

snapshot log

Import, 22.18.1

snapshots, 22.18.2

importing, 22.18

master table

Import, 22.18.1

restoring dropped

Import, 22.18.2.1

SORTED INDEXES clause

direct path loads, 9.14.1

SQL*Loader, 12.5.2.1

sorting

multiple-column indexes

SQL*Loader, 12.5.2.3

optimum sort order

SQL*Loader, 12.5.2.4

presorting in direct path load, 12.5.2

SORTED INDEXES clause

SQL*Loader, 12.5.2.1

SOURCE_EDITION parameter

Data Pump Export utility, 2.4.37

Data Pump Import utility, 3.4.37

SPOOL command, ADRCI utility, 16.9.28

SQL operators

applying to fields, 10.12

SQL strings

applying SQL operators to fields, 10.12

quotation marks and, 9.3.2

SQL*Loader

appending rows to tables, 9.13.2.2.1

BAD command-line parameter, 8.2.1

bad file, 8.2.1

BADFILE parameter, 9.8

bind arrays and performance, 9.16.2

BINDSIZE command-line parameter, 8.2.2, 9.16.3

choosing which rows to load, 9.13.4

COLUMNARRAYROWS command-line parameter, 8.2.3

command-line parameters, 8.1

continuing single-table loads, 9.11.5

CONTROL command-line parameter, 8.2.4

conventional path loads, 7.9.1, 12.2

DATA command-line parameter, 8.2.5

data conversion, 7.6

data definition language

syntax diagrams, A

datatype specifications, 7.6

DATE_CACHE command-line parameter, 8.2.6

determining default schema, 9.13.1.1

DIRECT command-line parameter, 12.4.2

direct path method, 7.9.2

using date cache feature to improve performance, 12.5.6

DISCARD command-line parameter, 8.2.8

discarded records, 7.7

DISCARDFILE parameter, 9.9.1

DISCARDMAX command-line parameter, 8.2.9

DISCARDMAX parameter, 9.9.6

DISCARDS parameter, 9.9.6

errors caused by tabs, 10.2.1

ERRORS command-line parameter, 8.2.10

exclusive access, 12.8.3

external table loads, 7.9.3

EXTERNAL_TABLE parameter, 8.2.11

FILE command-line parameter, 8.2.12

file names, 9.3

globalization technology, 9.10

index options, 9.14

inserting rows into tables, 9.13.2.1.1

INTO TABLE statement, 9.13

LOAD command-line parameter, 8.2.13

load methods, 12.1

loading column objects, 11.1

loading data across different platforms, 10.7

loading data contained in the control file, 10.13.1

loading object tables, 11.2

LOG command-line parameter, 8.2.14

log files, 7.8

methods of loading data, 7.9

multiple INTO TABLE statements, 9.15

MULTITHREADING command-line parameter, 8.2.15

object names, 9.3

parallel data loading, 12.9, 12.9.3, 12.10

PARFILE command-line parameter, 8.2.18

portable datatypes, 10.4.2

READSIZE command-line parameter, 8.2.19

maximum size, 8.2.19

rejected records, 7.7

replacing rows in tables, 9.13.2.2.2

required privileges, 12.1

RESUMABLE parameter, 8.2.20

RESUMABLE_NAME parameter, 8.2.21

RESUMABLE_TIMEOUT parameter, 8.2.22

ROWS command-line parameter, 8.2.23

SILENT command-line parameter, 8.2.24

SINGLEROW parameter, 9.14.2

SKIP_INDEX_MAINTENANCE command-line parameter, 8.2.26

SKIP_UNUSABLE_INDEXES command-line parameter, 8.2.27

SORTED INDEXES during direct path loads, 9.14.1

specifying columns, 10.3

specifying data files, 9.5

specifying field conditions, 10.5

specifying fields, 10.3

specifying more than one data file, 9.5.2

STREAMSIZE command-line parameter, 8.2.28

suppressing messages, 8.2.24

USERID command-line parameter, 8.2.29

SQL*Loader control files

guidelines when creating, 7.3

SQL*Loader datatypes

nonportable, 10.4.1

SQLFILE parameter

Data Pump Import utility, 3.4.38

START_JOB parameter

Data Pump Export utility

interactive-command mode, 2.5.8

Data Pump Import utility

interactive-command mode, 3.5.6

starting

LogMiner utility, 19.4

statistics

analyzer, 22.24

database optimizer

specifying for Export, 21.5.25

optimizer, 22.24

specifying for Import, 22.7.27

STATISTICS parameter

Export utility, 21.5.25

Import utility, 22.7.27

STATUS parameter

Data Pump Export utility, 2.4.38

interactive-command mode, 2.5.9

Data Pump Import utility, 3.4.39

interactive-command mode, 3.5.7

STOP_JOB parameter

Data Pump Export utility

interactive-command mode, 2.5.10

Data Pump Import utility

interactive-command mode, 3.5.8

STORAGE parameter, 12.9.6.1.2

storage parameters

estimating export requirements, 21.2.2

OPTIMAL parameter, 22.20.1

overriding

Import, 22.20.3

preallocating

direct path load, 12.5.1

temporary for a direct path load, 12.4.3.2

using with Export/Import, 22.20

stored functions

importing, 22.16.7

effect of COMPILE parameter, 22.16.7

stored package, 22.16.7

stored packages

importing, 22.16.7

stored procedures

direct path load, 12.8.2.6

importing, 22.16.7

effect of COMPILE parameter, 22.16.7

stream buffer

specifying size for direct path, 12.5.5

stream record format, 7.4.3

loading column objects in, 11.1.1

Streams environment in Data Pump

setting buffer cache size, 5.3.1

STREAMS_CONFIGURATION parameter

Data Pump Import utility, 3.4.40

Import utility, 22.7.28

STREAMS_INSTANTIATION parameter

Import utility, 22.7.29

STREAMSIZE parameter

SQL*Loader command line, 8.2.28

string comparisons

SQL*Loader, 10.5.2

subpartitioned tables

loading, 12.3.2

subtypes

loading multiple, 9.15.3

supplemental logging

LogMiner utility, 19.9

database-level identification keys, 19.9.1.2

log groups, 19.9

table-level, 19.9.3

table-level identification keys, 19.9.3.1

table-level log groups, 19.9.3.2, 19.9.3.2

T

table names

preserving case sensitivity, 21.5.26.1

TABLE_EXISTS_ACTION parameter

Data Pump Import utility, 3.4.41

table-level Export, 21.4.1

table-level Import, 22.11

table-mode Export

Data Pump Export utility, 2.2.2.3

specifying, 21.5.26

table-mode Import

examples, 22.8.1

tables

Advanced Queuing

exporting, 21.14.10

importing, 22.16.10

appending rows with SQL*Loader, 9.13.2.2.1

defining before Import, 22.3.1

definitions

creating before Import, 22.3.1

exclusive access during direct path loads

SQL*Loader, 12.8.3

external, 13

importing, 22.7.30

insert triggers

direct path load in SQL*Loader, 12.8.2

inserting rows using SQL*Loader, 9.13.2.1.1

loading data into more than one table using SQL*Loader, 9.15

loading object tables, 11.2

maintaining consistency during Export, 21.5.3

manually ordering for Import, 22.3.3

master table

Import, 22.18.1

name restrictions

Export, 21.5.26.1

Import, 2.4.39, 3.4.42, 22.7.30, 22.7.30.1

nested

exporting, 21.14.9

importing, 22.16.3

objects

order of import, 22.1.1

partitioned, 21.4.1

replacing rows using SQL*Loader, 9.13.2.2.2

specifying for export, 21.5.26

specifying table-mode Export, 21.5.26

SQL*Loader method for individual tables, 9.13.2

truncating

SQL*Loader, 9.13.2.2.4

updating existing rows using SQL*Loader, 9.13.2.2.3

U

UNIQUE KEY constraints

effect on direct path load, 12.9.8

unique values

generating with SQL*Loader, 10.13.6

unloading entire database

Data Pump Export utility, 2.2.2.1

UNRECOVERABLE clause

SQL*Loader, 12.5.4.2

unsorted data

direct path load

SQL*Loader, 12.5.2.2

user mode export

specifying, 21.5.17

USER_SEGMENTS view

Export and, 21.2.2

user-defined constructors, 11.1.6

loading column objects with, 11.1.6

USERID parameter

Export utility, 21.5.31

Import utility, 22.7.36

SQL*Loader command line, 8.2.29

V

V$DATABASE view, 19.10

V$LOGMNR_CONTENTS view, 19.5.1

formatting information returned to, 19.6

impact of querying, 19.5.1

information within, 19.5

limiting information returned to, 19.6

LogMiner utility, 19.2.2

requirements for querying, 19.4, 19.5.1

V$LOGMNR_DICTIONARY view, 19.10

V$LOGMNR_LOGS view, 19.3.2, 19.10

querying, 19.10.1

V$LOGMNR_PARAMETERS view, 19.9.6, 19.10

V$SESSION_LONGOPS view

monitoring Data Pump jobs with, 1.5.1

VARCHAR2 datatype

SQL*Loader, 10.4.3

VARCHARC datatype

SQL*Loader, 10.4.2.7

variable records, 7.4.2

format, 11.1.2

variable-length records

external tables, 14.2.2

VARRAWC datatype, 10.4.2.8

VARRAY columns

memory issues when loading, 11.8.1

VERSION parameter

Data Pump Export utility, 2.4.44

Data Pump Import utility, 3.4.50

viewing

trace files with ADRCI, 16.6

VOLSIZE parameter

Export utility, 21.5.32

Import utility, 22.7.37

W

warning messages

Export, 21.7.2

Import, 21.7.2

WHEN clause

SQL*Loader, 9.13.4, 10.5

SQL*Loader discards resulting from, 9.9.4

whitespace

included in a field, 10.10.4

leading, 10.10.1

preserving, 10.11

terminating a field, 10.10.4.1

trimming, 10.10

X

XML columns

loading with SQL*Loader, 11.4

treatment by SQL*Loader, 11.4

XML type tables

identifying in SQL*Loader, 9.4

XMLTYPE clause

in SQL*Loader control file, 9.4