Index

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

A

access privileges

Export and Import, 20.2.3

ADD_FILE parameter

Data Pump Export utility

interactive-command mode, 2.6.1

ADR

See automatic diagnostic repository

ADR base

in ADRCI utility, 15.2

ADR home

in ADRCI utility, 15.2

ADRCI

troubleshooting, 15.10

ADRCI utility

ADR base, 15.2

ADR home, 15.2

batch mode, 15.3.3

getting help, 15.3

homepath, 15.2

interactive mode, 15.3.1

starting, 15.3

Advanced Queuing

exporting advanced queue tables, 20.27.4.10

importing advanced queue tables, 20.28.5.10

aliases

B

backslash escape character, 8.3.3.2

backups

restoring dropped snapshots

Import, 20.18.2.1

bad files

specifying for SQL*Loader, 8.8

BAD parameter

SQL*Loader command line, 7.2.1

BADFILE parameter

SQL*Loader utility, 8.8

BEGINDATA parameter

SQL*Loader control file, 8.6

BFILE columns

exporting, 20.27.4.6

importing, 20.28.5.5

BFILE datatype, 10.5

big-endian data

external tables, 13.2.7

bind arrays

determining size of for SQL*Loader, 8.16.4

minimizing SQL*Loader memory requirements, 8.16.5

minimum requirements, 8.16.1

size with multiple SQL*Loader INTO TABLE statements, 8.16.6

specifying maximum size, 7.2.2

specifying number of rows, 7.2.22

SQL*Loader performance implications, 8.16.2

BINDSIZE parameter

SQL*Loader command line, 7.2.2, 8.16.3

blanks

loading fields consisting of blanks, 9.9

SQL*Loader BLANKS parameter for field comparison, 9.5.1

trailing, 9.4.5.6

trimming, 9.10

external tables, 13.3.2

whitespace, 9.10

BLANKS parameter

SQL*Loader utility, 9.5.1

bound fillers, 9.3.1

buffer cache size

and Data Pump operations involving Streams, 4.3.1

BUFFER parameter

Export utility, 20.9.1

Import utility, 20.10.1

buffers

calculating for export, 20.9.1

space required by

VARCHAR data in SQL*Loader, 9.4.1.9

specifying with SQL*Loader BINDSIZE parameter, 8.16.4

byte order, 9.8

big-endian, 9.8

little-endian, 9.8

specifying in SQL*Loader control file, 9.8.1

byte order marks, 9.8.2

precedence

for first primary datafile, 9.8.2

for LOBFILEs and SDFs, 9.8.2

suppressing checks for, 9.8.2.1

BYTEINT datatype, 9.4.1.5

BYTEORDER parameter

SQL*Loader utility, 9.8.1

BYTEORDERMARK parameter

SQL*Loader utility, 9.8.2.1

C

cached sequence numbers

Export, 20.27.4.1

catalog.sql script

preparing database for Export and Import, 20.2.1

catexp.sql script

preparing database for Export and Import, 20.2.1

catldr.sql script

preparing for direct path loads, 11.4.1

changing a database ID, 17.3.1

changing a database name, 17.3.3

CHAR datatype

delimited form and SQL*Loader, 9.4.5

reference

SQL*Loader, 9.4.2.1

character fields

delimiters and SQL*Loader, 9.4.2, 9.4.5

determining length for SQL*Loader, 9.4.6

SQL*Loader datatypes, 9.4.2

character sets

conversion

during Export and Import, 20.17.1

eight-bit to seven-bit conversions

Export/Import, 20.17.3

identifying for external tables, 13.2.4

multibyte

Export/Import, 20.17.4

SQL*Loader, 8.10.1

single-byte

Export/Import, 20.17.3

SQL*Loader control file, 8.10.5.3

SQL*Loader conversion between, 8.10

Unicode, 8.10.2

character strings

external tables

specifying bytes or characters, 13.2.9

SQL*Loader, 9.5.2

character-length semantics, 8.10.5.4

CHARACTERSET parameter

SQL*Loader utility, 8.10.5.2

check constraints

overriding disabling of, 11.8.1.2

collections, 6.10

loading, 10.6

column array rows

specifying number of, 11.5.5

column objects

loading, 10.1

with user-defined constructors, 10.1.6

COLUMNARRAYROWS parameter

SQL*Loader command line, 7.2.3

columns

exporting LONG datatypes, 20.27.4.2

loading REF columns, 10.3

naming

SQL*Loader, 9.3

objects

loading nested column objects, 10.1.3

stream record format, 10.1.1

variable record format, 10.1.2, 10.1.2

reordering before Import, 20.6.1

setting to a constant value with SQL*Loader, 9.13.2

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

setting to an expression value with SQL*Loader, 9.13.3

setting to null with SQL*Loader, 9.13.2.1

setting to the current date with SQL*Loader, 9.13.5

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

specifying

SQL*Loader, 9.3

specifying as PIECED

SQL*Loader, 11.4.7.1

using SQL*Loader, 9.13.3

comments

in Export and Import parameter files, 20.3.3

with external tables, 13.1, 14.1.1

COMMIT parameter

Import utility, 20.10.2

COMPILE parameter

Import utility, 20.10.3

completion messages

Export, 20.14.4

Import, 20.14.4

COMPRESS parameter

Export utility, 20.9.2

COMPRESSION parameter

Data Pump Export utility, 2.4.2

CONCATENATE parameter

SQL*Loader utility, 8.12

concurrent conventional path loads, 11.8.4

configuration

of LogMiner utility, 18.2.1

CONSISTENT parameter

Export utility, 20.9.3

nested tables and, 20.9.3

partitioned table and, 20.9.3

consolidating

extents, 20.9.2

CONSTANT parameter

SQL*Loader, 9.13.2

constraints

automatic integrity and SQL*Loader, 11.8.2.2

direct path load, 11.8

disabling referential constraints, 20.6.2

enabling

after a parallel direct path load, 11.9.7

enforced on a direct load, 11.8.1.1

failed

Import, 20.28.1.1.1

load method, 11.3.8

CONSTRAINTS parameter

Export utility, 20.9.4

Import utility, 20.10.4

constructors

attribute-value, 10.1.6

overriding, 10.1.6

user-defined, 10.1.6

loading column objects with, 10.1.6

CONTENT parameter

Data Pump Export utility, 2.4.3

Data Pump Import utility, 3.4.1

CONTINUE_CLIENT parameter

Data Pump Export utility

interactive-command mode, 2.6.2

Data Pump Import utility

interactive-command mode, 3.6.1

CONTINUEIF parameter

SQL*Loader utility, 8.12

control files

character sets, 8.10.5.3

creating

guidelines, 6.3

data definition language syntax, 8.1

specifying data, 8.6

specifying SQL*Loader discard file, 8.9

CONTROL parameter

SQL*Loader command line, 7.2.4

conventional path Export

compared to direct path, 20.27.1

conventional path loads

behavior when discontinued, 8.11.1

compared to direct path loads, 11.3.7

concurrent, 11.9.1

of a single partition, 11.2

SQL*Loader bind array, 8.16.2

when to use, 11.2.2

conversion of character sets

during Export/Import, 20.17.1

effect of character set sorting on, 20.17.1.1

conversion of data

during direct path loads, 11.3.1

conversion of input characters, 8.10.5

CREATE SESSION privilege

Export, 20.2.3

Import, 20.2.3

creating

incident package, 15.8.2

tables

manually, before import, 20.6.1

D

data

conversion

direct path load, 11.3.1

delimiter marks in data and SQL*Loader, 9.4.5.4

distinguishing different input formats for SQL*Loader, 8.15

distinguishing different input row object subtypes, 8.15, 8.15.3

exporting, 20.9.24

generating unique values with SQL*Loader, 9.13.6

including in control files, 8.6

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

loading in sections

SQL*Loader, 11.4.7.1

loading into more than one table

SQL*Loader, 8.15

maximum length of delimited data for SQL*Loader, 9.4.5.5

moving between operating systems using SQL*Loader, 9.7

recovery

SQL*Loader direct path load, 11.4.6

saving in a direct path load, 11.4.5

saving rows

SQL*Loader, 11.5.3

unsorted

SQL*Loader, 11.5.2.2

values optimized for SQL*Loader performance, 9.13.1

data fields

specifying the SQL*Loader datatype, 9.3.2

data movement

in Data Pump Export and Import, 1.2

DATA parameter

SQL*Loader command line, 7.2.5

Data Pump Export utility

and transparent data encryption, 2.4.10

ATTACH parameter, 2.4.1

command-line mode, 2.4, 3.4

compared to original Export utility, 2.5

COMPRESSION parameter, 2.4.2

CONTENT parameter, 2.4.3, 2.4.3

controlling resource consumption, 4.2.1

data movement methods, 1.2

DATA_OPTIONS parameter, 2.4.4

dump file set, 2.1

DUMPFILE parameter, 2.4.6

encryption of SecureFiles, 2.4.7

ENCRYPTION parameter, 2.4.7

ENCRYPTION_ALGORITHM parameter, 2.4.8

ENCRYPTION_MODE parameter, 2.4.9

ENCRYPTION_PASSWORD parameter, 2.4.10

ESTIMATE parameter, 2.4.11

ESTIMATE_ONLY parameter, 2.4.12

EXCLUDE parameter, 2.4.13

excluding objects, 2.4.13

export modes, 2.2.2

FILESIZE command

interactive-command mode, 2.6.4

FILESIZE parameter, 2.4.14

filtering data that is exported

using EXCLUDE parameter, 2.4.13

using INCLUDE parameter, 2.4.19

FLASHBACK_SCN parameter, 2.4.15

FLASHBACK_TIME parameter, 2.4.16

FULL parameter, 2.4.17

HELP parameter

interactive-command mode, 2.6.5

INCLUDE parameter, 2.4.19

interactive-command mode, 2.6

ADD_FILE parameter, 2.6.1

CONTINUE_CLIENT parameter, 2.6.2

EXIT_CLIENT parameter, 2.6.3

FILESIZE, 2.6.4

HELP parameter, 2.6.5

KILL_JOB parameter, 2.6.6

PARALLEL parameter, 2.6.7

START_JOB parameter, 2.6.8

STATUS parameter, 2.6.9

STOP_JOB parameter, 2.6.10, 3.6.8

interfaces, 2.2.1

invoking

as SYSDBA, 2.2, 3.2

job names

specifying, 2.4.20

JOB_NAME parameter, 2.4.20

LOGFILE parameter, 2.4.21

NETWORK_LINK parameter, 2.4.22

NOLOGFILE parameter, 2.4.23

PARALLEL parameter

command-line mode, 2.4.24

interactive-command mode, 2.6.7

PARFILE parameter, 2.4.25

QUERY parameter, 2.4.26

REMAP_DATA parameter, 2.4.27

REUSE_DUMPFILES parameter, 2.4.28

SAMPLE parameter, 2.4.29

SCHEMAS parameter, 2.4.30

specifying a job name, 2.4.20

syntax diagrams, 2.8

TABLES parameter, 2.4.32

TABLESPACES parameter, 2.4.33

TRANSPORT_FULL_CHECK parameter, 2.4.34

TRANSPORT_TABLESPACES parameter, 2.4.35

TRANSPORTABLE parameter, 2.4.36

VERSION parameter, 2.4.37

versioning, 1.6

Data Pump Import utility

and transparent data encryption, 3.4.6

ATTACH parameter, 3.4.1

attaching to an existing job, 3.4.1

changing name of source datafile, 3.4.23

command-line mode

NOLOGFILE parameter, 3.4.17

STATUS parameter, 3.4.31

compared to original Import utility, 3.5

CONTENT parameter, 3.4.2

controlling resource consumption, 4.2.1

data movement methods, 1.2

DATA_OPTIONS parameter, 3.4.3

DIRECTORY parameter, 3.4.4

DUMPFILE parameter, 3.4.5

ENCRYPTION_PASSWORD parameter, 3.4.6

ESTIMATE parameter, 3.4.7

estimating size of job, 3.4.7

EXCLUDE parameter, 3.4.8

filtering data that is imported

using EXCLUDE parameter, 3.4.8

using INCLUDE parameter, 3.4.13

FLASHBACK_SCN parameter, 3.4.9

FLASHBACK_TIME parameter, 3.4.10

full import mode, 3.2.2.1

FULL parameter, 3.4.11

HELP parameter

command-line mode, 3.4.12

interactive-command mode, 3.6.3

INCLUDE parameter, 3.4.13

interactive-command mode, 3.6

CONTINUE_CLIENT parameter, 3.6.1

EXIT_CLIENT parameter, 3.6.2

HELP parameter, 3.6.3

KILL_JOB parameter, 3.6.4

START_JOB parameter, 3.6.6

STATUS parameter, 3.6.7

STOP_JOB parameter, 3.6.8

interfaces, 3.2.1

JOB_NAME parameter, 3.4.14

LOGFILE parameter, 3.4.15

PARALLEL parameter

command-line mode, 3.4.18

interactive-command mode, 3.6.5

PARFILE parameter, 3.4.19

PARTITION_OPTIONS parameter, 3.4.20

QUERY parameter, 3.4.21

REMAP_DATA parameter, 3.4.22

REMAP_DATAFILE parameter, 3.4.23

REMAP_SCHEMA parameter, 3.4.24

REMAP_TABLE parameter, 3.4.25

REMAP_TABLESPACE parameter, 3.4.26

REUSE_DATAFILES parameter, 3.4.27

schema mode, 3.2.2.2

SCHEMAS parameter, 3.4.28

SKIP_UNUSABLE_INDEXES parameter, 3.4.29

specifying a job name, 3.4.14

specifying dump file set to import, 3.4.5

SQLFILE parameter, 3.4.30

STREAMS_CONFIGURATION parameter, 3.4.32

syntax diagrams, 3.8

table mode, 3.2.2.3

TABLE_EXISTS_ACTION parameter, 3.4.33

TABLES parameter, 3.4.34

tablespace mode, 3.2.2.4

TABLESPACES parameter, 3.4.35

TRANSFORM parameter, 3.4.36

TRANSPORT_DATAFILES parameter, 3.4.37

TRANSPORT_FULL_CHECK parameter, 3.4.38

TRANSPORT_TABLESPACES parameter, 3.4.39

TRANSPORTABLE parameter, 3.4.40

transportable tablespace mode, 3.2.2.5

VERSION parameter, 3.4.41

versioning, 1.6

DATA_OPTIONS parameter

Data Pump Export utility, 2.4.4

Data Pump Import utility, 3.4.3

database ID (DBID)

changing, 17.3.1

database identifier

changing, 17.3.1

database migration

partitioning of, 20.29

database name (DBNAME)

changing, 17.3.3

database objects

exporting LONG columns, 20.27.4.2

databases

changing the database ID, 17.3.1

changing the name, 17.3.3

exporting entire, 20.9.11

full import, 20.10.11

moving between platforms, 20.13

privileges for exporting and importing, 20.2.3

reducing fragmentation, 20.25

reusing existing datafiles

Import, 20.10.6

datafiles

preventing overwrite during import, 20.10.6

reusing during import, 20.10.6

specifying, 7.2.5

specifying buffering for SQL*Loader, 8.7

specifying for SQL*Loader, 8.5

specifying format for SQL*Loader, 8.7

DATAFILES parameter

Import utility, 20.10.5

datatypes

BFILE

Export, 20.27.4.6

Import, 20.28.5.5

BYTEINT, 9.4.1.5

CHAR, 9.4.2.1

converting SQL*Loader, 9.4.3

DATE, 9.4.2.2.1

datetime, 9.4.2.2

DECIMAL, 9.4.1.7

default in SQL*Loader, 9.3.2

describing for external table fields, 13.3.6

determining character field lengths for SQL*Loader, 9.4.6

determining DATE length, 9.4.6.3

DOUBLE, 9.4.1.4

FLOAT, 9.4.1.3

GRAPHIC, 9.4.2.3

GRAPHIC EXTERNAL, 9.4.2.4

identifying for external tables, 13.3.4

INTEGER (n), 9.4.1.1

interval, 9.4.2.2

length-value, 9.4, 9.4

LONG

Export, 20.27.4.2

Import, 20.28.5.11, 20.28.5.11

LONG VARRAW, 9.4.1.11

native

conflicting length specifications in SQL*Loader, 9.4.2.9

nonportable, 9.4.1

nonscalar, 10.1.5

NUMBER

SQL*Loader, 9.4.3, 9.4.4

numeric EXTERNAL, 9.4.2.5

portable, 9.4.2

RAW, 9.4.2.6

SMALLINT, 9.4.1.2

specifying the SQL*Loader datatype of a data field, 9.3.2

supported by the LogMiner utility, 18.13.1

unsupported by LogMiner utility, 18.13.2

value, 9.4, 9.4

VARCHAR, 9.4.1.9

VARCHAR2

SQL*Loader, 9.4.3

VARCHARC, 9.4.2.7

VARGRAPHIC, 9.4.1.8

VARRAW, 9.4.1.10

VARRAWC, 9.4.2.8

ZONED, 9.4.1.6

date cache feature

DATE_CACHE parameter, 7.2.6

external tables, 12.5.1

SQL*Loader, 11.5.6

DATE datatype

delimited form and SQL*Loader, 9.4.5

determining length, 9.4.6.3

mask

SQL*Loader, 9.4.6.3

SQL*Loader, 9.4.2.2.1

DATE_CACHE parameter

SQL*Loader utility, 7.2.6

datetime datatypes, 9.4.2.2

DBID (database identifier)

changing, 17.3.1

DBMS_DATAPUMP PL/SQL package, 5

DBMS_LOGMNR PL/SQL procedure

LogMiner utility and, 18.2.2

DBMS_LOGMNR_D PL/SQL procedure

LogMiner utility and, 18.2.2

DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure

LogMiner utility and, 18.2.2

DBMS_LOGMNR_D.BUILD PL/SQL procedure

LogMiner utility and, 18.2.2

DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure

LogMiner utility and, 18.2.2

DBMS_LOGMNR.ADD_LOGFILE PL/SQL procedure

ADDFILE option, 18.3.2

NEW option, 18.3.2

DBMS_LOGMNR.COLUMN_PRESENT function, 18.5.2

DBMS_LOGMNR.MINE_VALUE function, 18.5.2

null values and, 18.5.2.1

DBMS_LOGMNR.START_LOGMNR PL/SQL procedure, 18.4

calling multiple times, 18.8

COMMITTED_DATA_ONLY option, 18.6.1

CONTINUOUS_MINE option, 18.3.2

ENDTIME parameter, 18.6.3, 18.6.4

LogMiner utility and, 18.2.2

options for, 18.4

PRINT_PRETTY_SQL option, 18.6.6

SKIP_CORRUPTION option, 18.6.2

STARTTIME parameter, 18.6.3, 18.6.4

DBMS_METADATA PL/SQL package, 19.3.1

DBNAME

changing, 17.3.3

DBNEWID utility, 17

changing a database ID, 17.3.1

changing a database name, 17.3.3

effect on global database names, 17.2.1

restrictions, 17.4.2

syntax, 17.4

troubleshooting a database ID change, 17.3.4

DBVERIFY utility

output, 16.1.3

restrictions, 16

syntax, 16.1.1

validating a segment, 16.2

validating disk blocks, 16.1

DECIMAL datatype, 9.4.1.7

EXTERNAL format

SQL*Loader, 9.4.2.5

default schema

as determined by SQL*Loader, 8.13.1.1

DEFAULTIF parameter

SQL*Loader, 9.5

DELETE ANY TABLE privilege

SQL*Loader, 8.13.2.2.4

DELETE CASCADE

effect on loading nonempty tables, 8.13.2.2.2

SQL*Loader, 8.13.2.2.4

DELETE privilege

SQL*Loader, 8.13.2.2.2

delimited data

maximum length for SQL*Loader, 9.4.5.5

delimited fields

field length, 9.4.6.2

delimited LOBs, 10.4.2.2.3

delimiters

in external tables, 13.2.3

loading trailing blanks, 9.4.5.6

marks in data and SQL*Loader, 9.4.5.4

specifying for external tables, 13.3.1

specifying for SQL*Loader, 8.13.5, 9.4.5

SQL*Loader enclosure, 9.10.2.2

SQL*Loader field specifications, 9.10.2.2

termination, 9.10.2.2

DESTROY parameter

Import utility, 20.10.6

dictionary

requirements for LogMiner utility, 18.2.1.2

dictionary version mismatch, 18.9.4

DIRECT parameter

Export utility, 20.9.5

direct path Export, 20.27.1, 20.27.2

compared to conventional path, 20.27.1

effect of EXEMPT ACCESS POLICY privilege, 20.27.2.1

performance issues, 20.27.2.2

restrictions, 20.27.2.3

security considerations, 20.27.2.1

direct path load

advantages, 11.3.4

behavior when discontinued, 8.11.2

choosing sort order

SQL*Loader, 11.5.2.4

compared to conventional path load, 11.3.7

concurrent, 11.9.3, 11.9.3

conditions for use, 11.3.5

data saves, 11.4.5, 11.5.3

DIRECT command-line parameter

SQL*Loader, 11.4.2

dropping indexes, 11.7

effect of disabling archiving, 11.5.4

effect of PRIMARY KEY constraints, 11.9.8

effect of UNIQUE KEY constraints, 11.9.8

field defaults, 11.3.9

improper sorting

SQL*Loader, 11.5.2.2

indexes, 11.4.3

instance recovery, 11.4.6

intersegment concurrency, 11.9.3

intrasegment concurrency, 11.9.3

loading into synonyms, 11.3.10

location of data conversion, 11.3.1

media recovery, 11.4.6.1, 11.4.6.1

optimizing on multiple-CPU systems, 11.6

partitioned load

SQL*Loader, 11.8.4

performance, 11.4.3, 11.5

preallocating storage, 11.5.1

presorting data, 11.5.2

recovery, 11.4.6

ROWS command-line parameter, 11.4.5.1

setting up, 11.4.1

specifying, 11.4.2

specifying number of rows to be read, 7.2.22

SQL*Loader data loading method, 6.9.2

table insert triggers, 11.8.2

temporary segment storage requirements, 11.4.3.2

triggers, 11.8

using, 11.3.7, 11.4

version requirements, 11.3.5

directory aliases

exporting, 20.27.4.5

importing, 20.28.5.5

directory objects

Data Pump

effect of automatic storage management, 1.5.2.1

using with Data Pump, 1.5.2.1

DIRECTORY parameter

Data Pump Export utility, 2.4.5

Data Pump Import utility, 3.4.4

discard files

SQL*Loader, 8.9

specifying a maximum, 8.9.2

DISCARD parameter

SQL*Loader command-line, 7.2.8

discarded SQL*Loader records, 6.7

causes, 8.9.4

discard file, 8.9

limiting, 8.9.6

DISCARDMAX parameter

SQL*Loader command-line, 7.2.9

discontinued loads, 8.11

continuing, 8.11.5

conventional path behavior, 8.11.1

direct path behavior, 8.11.2

DOUBLE datatype, 9.4.1.4

dropped snapshots

Import, 20.18.2.1

dump files

maximum size, 20.9.8

DUMPFILE parameter

Data Pump Export utility, 2.4.6

Data Pump Import utility, 3.4.5

E

EBCDIC character set

Import, 20.17.3

eight-bit character set support, 20.17.3

EMCA

command-line arguments, 21.1

sample EMCA input file, 21.3

enclosed fields

specified with enclosure delimiters and SQL*Loader, 9.4.5.2

whitespace, 9.10.6

enclosure delimiters, 9.4.5

SQL*Loader, 9.4.5.2, 9.10.2.2

encrypted columns

in external tables, 14.1.6

ENCRYPTION parameter

Data Pump Export utility, 2.4.7

ENCRYPTION_ALGORITHM parameter

Data Pump Export utility, 2.4.8

ENCRYPTION_MODE parameter

Data Pump Export utility, 2.4.9

ENCRYPTION_PASSWORD parameter

Data Pump Export utility, 2.4.10

Data Pump Import utility, 3.4.6

errors

caused by tab characters in SQL*Loader data, 9.2.1

LONG data, 20.28.1.1.2

object creation, 20.28.1.2.1

Import parameter IGNORE, 20.10.14

resource errors on import, 20.28.1.2.3

row errors during import, 20.28.1.1

writing to export log file, 20.9.15

ERRORS parameter

SQL*Loader command line, 7.2.10

escape character

quoted strings and, 8.3.3.2

usage in Data Pump Export, 2.4

usage in Data Pump Import, 3.4

usage in Export, 20.9.26.1

usage in Import, 20.10.29

ESTIMATE parameter

Data Pump Export utility, 2.4.11

Data Pump Import utility, 3.4.7

ESTIMATE_ONLY parameter

Data Pump Export utility, 2.4.12

estimating size of job

Data Pump Export utility, 2.4.11

EVALUATE CHECK_CONSTRAINTS clause, 11.8.1.2

EXCLUDE parameter

Data Pump Export utility, 2.4.13

Data Pump Import utility, 3.4.8

exit codes

Export and Import, 20.15

SQL*Loader, 7.3

EXIT_CLIENT parameter

Data Pump Export utility

interactive-command mode, 2.6.3

Data Pump Import utility

interactive-command mode, 3.6.2

EXP_FULL_DATABASE role

assigning in Export, 20.2.1

expdat.dmp

Export output file, 20.9.7

Export

BUFFER parameter, 20.9.1

character set conversion, 20.17.1

COMPRESS parameter, 20.9.2

CONSISTENT parameter, 20.9.3

CONSTRAINTS parameter, 20.9.4

conventional path, 20.27.1

creating

necessary privileges, 20.2.1

necessary views, 20.2.1

database optimizer statistics, 20.9.25

DIRECT parameter, 20.9.5

direct path, 20.27.1

displaying online help, 20.9.13

example sessions, 20.11

full database mode, 20.11.1

partition-level, 20.11.4

table mode, 20.11.3

user mode, 20.9.17, 20.11.2

exit codes, 20.15

exporting an entire database, 20.9.11

exporting indexes, 20.9.14

exporting sequence numbers, 20.27.4.1

exporting synonyms, 20.27.4.11

exporting to another operating system, 20.9.20, 20.10.19

FEEDBACK parameter, 20.9.6

FILE parameter, 20.9.7

FILESIZE parameter, 20.9.8

FLASHBACK_SCN parameter, 20.9.9

FLASHBACK_TIME parameter, 20.9.10

full database mode

example, 20.11.1

FULL parameter, 20.9.11

GRANTS parameter, 20.9.12

HELP parameter, 20.9.13

INDEXES parameter, 20.9.14

invoking, 20.3

log files

specifying, 20.9.15

LOG parameter, 20.9.15

logging error messages, 20.9.15

LONG columns, 20.27.4.2

OBJECT_CONSISTENT parameter, 20.9.16

online help, 20.3.5

OWNER parameter, 20.9.17

parameter file, 20.9.18

maximum size, 20.3.3

parameter syntax, 20.9

PARFILE parameter, 20.9.18

partitioning a database migration, 20.29

QUERY parameter, 20.9.19

RECORDLENGTH parameter, 20.9.20

redirecting output to a log file, 20.14.1

remote operation, 20.16.2

restrictions based on privileges, 20.2.3

RESUMABLE parameter, 20.9.21

RESUMABLE_NAME parameter, 20.9.22

RESUMABLE_TIMEOUT parameter, 20.9.23

ROWS parameter, 20.9.24

sequence numbers, 20.27.4.1

STATISTICS parameter, 20.9.25

storage requirements, 20.2.2

table mode

example session, 20.11.3

table name restrictions, 20.9.26.1

TABLES parameter, 20.9.26

TABLESPACES parameter, 20.9.27

TRANSPORT_TABLESPACE parameter, 20.9.28

TRIGGERS parameter, 20.9.29

TTS_FULL_CHECK parameter, 20.9.30

user access privileges, 20.2.3

user mode

example session, 20.9.17, 20.11.2

specifying, 20.9.17

USERID parameter, 20.9.31

VOLSIZE parameter, 20.9.32

export dump file

importing the entire file, 20.10.11

export file

listing contents before importing, 20.10.24

specifying, 20.9.7

EXPRESSION parameter

SQL*Loader, 9.13.3, 9.13.3.1

extents

consolidating, 20.9.2

importing consolidated, 20.26.4

external files

exporting, 20.27.4.6

EXTERNAL parameter

SQL*Loader, 9.4.2.5

EXTERNAL SQL*Loader datatypes, 9.4.2.5

DECIMAL, 9.4.2.5

FLOAT, 9.4.2.5

GRAPHIC, 9.4.2.4

numeric, 9.4.2.5

determining len, 9.4.6

ZONED, 9.4.2.5

external tables

access parameters, 12.1.1

and encrypted columns, 14.1.6

big-endian data, 13.2.7

column_transforms clause, 13.1

datatypes, 13.3.6

date cache feature, 12.5.1

delimiters, 13.2.3

describing datatype of a field, 13.3.6

differences in load behavior from SQL*Loader, 12.7

field_definitions clause, 13.1, 13.3

fixed-length records, 13.2.1

identifying character sets, 13.2.4

identifying datatypes, 13.3.4

improving performance when using, 12.5

date cache feature, 12.5.1

little-endian data, 13.2.7

opaque_format_spec, 12.1.1

record_format_info clause, 13.1, 13.2

reserved words, 12.6

restrictions, 12.6

setting a field to a default value, 13.3.7

setting a field to null, 13.3.7

skipping records when loading data, 13.2.14

specifying delimiters, 13.3.1

specifying load conditions, 13.2.10

trimming blanks, 13.3.2

use of SQL strings, 12.6

using comments, 13.1, 14.1.1

using constructor functions with, 12.2.3

using to load data, 12.2

variable-length records, 13.2.2

EXTERNAL_TABLE parameter

SQL*Loader, 7.2.11

F

fatal errors

See nonrecoverable error messages

FEEDBACK parameter

Export utility, 20.9.6

Import utility, 20.10.7

field conditions

specifying for SQL*Loader, 9.5

field length

SQL*Loader specifications, 9.10.2

field location

SQL*Loader, 9.2

fields

character data length and SQL*Loader, 9.4.6

comparing to literals with SQL*Loader, 9.5.2

delimited

determining length, 9.4.6.2

SQL*Loader, 9.4.5

enclosed and SQL*Loader, 9.4.5.2

loading all blanks, 9.9

predetermined size

length, 9.4.6.1

SQL*Loader, 9.10.2.1

relative positioning and SQL*Loader, 9.10.3

specified with a termination delimiter and SQL*Loader, 9.4.5.1

specified with enclosure delimiters and SQL*Loader, 9.4.5.2

specifying default delimiters for SQL*Loader, 8.13.5

specifying for SQL*Loader, 9.3

SQL*Loader delimited

specifications, 9.10.2.2

terminated and SQL*Loader, 9.4.5.1

FIELDS clause

SQL*Loader, 8.13.5

terminated by whitespace, 9.10.4.1

FILE parameter

Export utility, 20.9.7

Import utility, 20.10.8

SQL*Loader utility, 11.9.6.1

filenames

quotation marks and, 8.3.3.1

specifying multiple SQL*Loader, 8.5.2

SQL*Loader, 8.3

SQL*Loader bad file, 8.8

FILESIZE parameter

Data Pump Export utility, 2.4.14

Export utility, 20.9.8

Import utility, 20.10.9

FILLER field

using as argument to init_spec, 9.3.1

filtering data

using Data Pump Export utility, 2.1

using Data Pump Import utility, 3.1

filtering metadata that is imported

Data Pump Import utility, 3.4.8

finalizing

in ADRCI utility, 15.2

fine-grained access support

Export and Import, 20.23

fixed-format records, 6.4.1

fixed-length records

external tables, 13.2.1

FLASHBACK_SCN parameter

Data Pump Export utility, 2.4.15

Data Pump Import utility, 3.4.9

Export utility, 20.9.9

FLASHBACK_TIME parameter

Data Pump Export utility, 2.4.16

Data Pump Import utility, 3.4.10

Export utility, 20.9.10

FLOAT datatype, 9.4.1.3

EXTERNAL format

SQL*Loader, 9.4.2.5

FLOAT EXTERNAL data values

SQL*Loader, 9.4.2.5

foreign function libraries

exporting, 20.27.4.3

importing, 20.28.5.6, 20.28.5.9

formats

SQL*Loader input records and, 8.15.2

formatting errors

SQL*Loader, 8.8

fragmentation

reducing, 20.25

FROMUSER parameter

Import utility, 20.10.10

full database mode

Import, 20.10.11

specifying with FULL, 20.9.11

full export mode

Data Pump Export utility, 2.2.2.1

FULL parameter

Data Pump Export utility, 2.4.17

Data Pump Import utility, 3.4.11

Export utility, 20.9.11

Import utility, 20.10.11

G

globalization

SQL*Loader, 8.10

grants

exporting, 20.9.12

importing, 20.4.1, 20.10.12

GRANTS parameter

Export utility, 20.9.12

Import utility, 20.10.12

GRAPHIC datatype

EXTERNAL format in SQL*Loader, 9.4.2.4

H

HELP parameter

Data Pump Export utility

command-line mode, 2.4.18

interactive-command mode, 2.6.5

Data Pump Import utility

command-line mode, 3.4.12

interactive-command mode, 3.6.3

Export utility, 20.9.13

Import utility, 20.10.13

hexadecimal strings

SQL*Loader, 9.5.2

homepath

in ADRCI utility, 15.2

I

IGNORE parameter

Import utility, 20.10.14

IMP_FULL_DATABASE role

assigning in Import, 20.2.1

Import

BUFFER parameter, 20.10.1

character set conversion, 20.17.1, 20.17.3

COMMIT parameter, 20.10.2

committing after array insert, 20.10.2

COMPILE parameter, 20.10.3

consolidated extents, 20.26.4

CONSTRAINTS parameter, 20.10.4

creating

necessary privileges, 20.2.1

necessary views, 20.2.1

creating an index-creation SQL script, 20.10.16

database optimizer statistics, 20.10.26

DATAFILES parameter, 20.10.5

DESTROY parameter, 20.10.6

disabling referential constraints, 20.6.2, 20.6.2

displaying online help, 20.10.13

dropping a tablespace, 20.21

errors importing database objects, 20.28.1.2

example sessions, 20.12

all tables from one user to another, 20.12.3

selected tables for specific user, 20.12.1

tables exported by another user, 20.12.2

using partition-level Import, 20.12.4

exit codes, 20.15

export file

importing the entire file, 20.10.11

listing contents before import, 20.10.24

failed integrity constraints, 20.28.1.1.1

FEEDBACK parameter, 20.10.7

FILE parameter, 20.10.8

FILESIZE parameter, 20.10.9

FROMUSER parameter, 20.10.10

FULL parameter, 20.10.11

grants

specifying for import, 20.10.12

GRANTS parameter, 20.10.12

HELP parameter, 20.10.13

IGNORE parameter, 20.10.14

importing grants, 20.10.12

importing objects into other schemas, 20.4.2

importing rows, 20.10.23

importing tables, 20.10.29

INDEXES parameter, 20.10.15

INDEXFILE parameter, 20.10.16

INSERT errors, 20.28.1.1.2

invalid data, 20.28.1.1.2

invoking, 20.3

LOG parameter, 20.10.17

LONG columns, 20.28.5.11, 20.28.5.11

manually creating tables before import, 20.6.1

manually ordering tables, 20.6.3

NLS_LANG environment variable, 20.17.3

object creation errors, 20.10.14

online help, 20.3.5

parameter file, 20.10.18

maximum size, 20.3.3

parameter syntax, 20.10

PARFILE parameter, 20.10.18

partition-level, 20.8.2

pattern matching of table names, 20.10.29

preserving size of initial extent, 20.26.4

read-only tablespaces, 20.20

RECORDLENGTH parameter, 20.10.19

records

specifying length, 20.10.19

redirecting output to a log file, 20.14.1

reducing database fragmentation, 20.25

refresh error, 20.18.1

remote operation, 20.16.2

reorganizing tablespace during, 20.22

resource errors, 20.28.1.2.3

restrictions

importing into own schema, 20.4

RESUMABLE parameter, 20.10.20

RESUMABLE_NAME parameter, 20.10.21

RESUMABLE_TIMEOUT parameter, 20.10.22

reusing existing datafiles, 20.10.6

rows

specifying for import, 20.10.23

ROWS parameter, 20.10.23

schema objects, 20.4.2

sequences, 20.28.1.2.2

SHOW parameter, 20.10.24

single-byte character sets, 20.17.3

SKIP_UNUSABLE_INDEXES parameter, 20.10.25

snapshot master table, 20.18.1

snapshots, 20.18

restoring dropped, 20.18.2.1

specifying by user, 20.10.10

specifying index creation commands, 20.10.16

specifying the export file, 20.10.8

STATISTICS parameter, 20.10.26

storage parameters

overriding, 20.26.3

stored functions, 20.28.5.7

stored procedures, 20.28.5.7

STREAMS_CONFIGURATION parameter, 20.10.27

STREAMS_INSTANTIATION parameter, 20.10.28

system objects, 20.4.3

table name restrictions, 20.10.29.1

table objects

import order, 20.5

table-level, 20.8.2

TABLES parameter, 20.10.29

TABLESPACES parameter, 20.10.30

TOID_NOVALIDATE parameter, 20.10.31

TOUSER parameter, 20.10.32

TRANSPORT_TABLESPACE parameter, 20.10.33

TTS_OWNER parameter, 20.10.34

tuning considerations, 20.28.4

types of errors during, 20.28.1

user access privileges, 20.2.3

USERID parameter, 20.10.35

VOLSIZE parameter, 20.10.36

incident

fault diagnosability infrastructure, 15.2

packaging, 15.8

incident package

fault diagnosability infrastructure, 15.2

INCLUDE parameter

Data Pump Export utility, 2.4.19

Data Pump Import utility, 3.4.13

index options

SORTED INDEXES with SQL*Loader, 8.14.1

SQL*Loader SINGLEROW parameter, 8.14.2

Index Unusable state

indexes left in Index Unusable state, 8.11.3, 11.4.4

indexes

creating manually, 20.10.16

direct path load

left in direct load state, 11.4.4

dropping

SQL*Loader, 11.7

estimating storage requirements, 11.4.3.1

exporting, 20.9.14

importing, 20.10.15

index-creation commands

Import, 20.10.16

left in unusable state, 8.11.3, 11.5.2.2

multiple-column

SQL*Loader, 11.5.2.3

presorting data

SQL*Loader, 11.5.2

skipping maintenance, 7.2.25, 11.7

skipping unusable, 7.2.26, 11.7

SQL*Loader, 8.14

state after discontinued load, 8.11.3

unique, 20.10.15

INDEXES parameter

Export utility, 20.9.14

Import utility, 20.10.15

INDEXFILE parameter

Import utility, 20.10.16

INFILE parameter

SQL*Loader utility, 8.5

insert errors

Import, 20.28.1.1.2

specifying, 7.2.10

INSERT into table

SQL*Loader, 8.13.2.1.1

instance affinity

Export and Import, 20.24

instance recovery, 11.4.6.2

INTEGER datatype, 9.4.1.1

EXTERNAL format, 9.4.2.5

integrity constraints

disabled during direct path load, 11.8.1.2

enabled during direct path load, 11.8.1.1

failed on Import, 20.28.1.1.1

load method, 11.3.8

interactive method

Data Pump Export utility, 2.2.1

internal LOBs

loading, 10.4.1

interrupted loads, 8.11

interval datatypes, 9.4.2.2

INTO TABLE statement

effect on bind array size, 8.16.6

multiple statements with SQL*Loader, 8.15

SQL*Loader, 8.13

column names, 9.3

discards, 8.9.4

invalid data

Import, 20.28.1.1.2

invoking

Export, 20.3

at the command line, 20.3.2

direct path, 20.27.2

interactively, 20.3.4

with a parameter file, 20.3.3

Import, 20.3

as SYSDBA, 20.3.1

at the command line, 20.3.2

interactively, 20.3.4

with a parameter file, 20.3.3

J

Java Message Service (JMS), 21.5

JOB_NAME parameter

Data Pump Export utility, 2.4.20

Data Pump Import utility, 3.4.14

K

key values

generating with SQL*Loader, 9.13.6

KILL_JOB parameter

Data Pump Export utility

interactive-command mode, 2.6.6

Data Pump Import utility, 3.6.4

L

leading whitespace

definition, 9.10.1

trimming and SQL*Loader, 9.10.4

length indicator

determining size, 8.16.4.1

length subfield

VARCHAR DATA

SQL*Loader, 9.4.1.9

length-value datatypes, 9.4, 9.4

length-value pair specified LOBs, 10.4.2.2.4

libraries

foreign function

exporting, 20.27.4.3

importing, 20.28.5.6, 20.28.5.9

little-endian data

external tables, 13.2.7

LOAD parameter

SQL*Loader command line, 7.2.13

collections, 10.6

column objects, 10.1

in variable record format, 10.1.2

with a derived subtype, 10.1.4

with user-defined constructors, 10.1.6

datafiles containing tabs

SQL*Loader, 9.2.1

external table data

skipping records, 13.2.14

specifying conditions, 13.2.7, 13.2.19

into LONG RAW columns, 9.4.3

LOBs, 10.4

nested column objects, 10.1.3

object tables, 10.2

object tables with a subtype, 10.2.1

REF columns, 10.3

subpartitioned tables, 11.3.2

tables, 11.3.2

XML columns, 10.4

LOB data, 6.5

compression during export, 20.9.2

Export, 20.27.4.2

in delimited fields, 10.4.1.2

in length-value pair fields, 10.4.1.3

in predetermined size fields, 10.4.1.1

LOB read buffer

size of, 7.2.18

LOBFILEs, 6.5, 10.4, 10.4.2

LOBs

loading, 10.4

log files

after a discontinued load, 8.11.4

Export, 20.9.15, 20.14.1

Import, 20.10.17, 20.14.1

specifying for SQL*Loader, 7.2.14

SQL*Loader, 6.8

LOG parameter

Export utility, 20.9.15

Import utility, 20.10.17

SQL*Loader command line, 7.2.14

LOGFILE parameter

Data Pump Export utility, 2.4.21

Data Pump Import utility, 3.4.15

logical records

consolidating multiple physical records using SQL*Loader, 8.12

LogMiner utility

accessing redo data of interest, 18.5

adjusting redo log file list, 18.8

analyzing output, 18.5.1

configuration, 18.2.1

considerations for reapplying DDL statements, 18.7

current log file list

stored information about, 18.10.1

DBMS_LOGMNR PL/SQL procedure and, 18.2.2

DBMS_LOGMNR_D PL/SQL procedure and, 18.2.2

DBMS_LOGMNR_D.ADD_LOGFILES PL/SQL procedure and, 18.2.2

DBMS_LOGMNR_D.BUILD PL/SQL procedure and, 18.2.2

DBMS_LOGMNR_D.END_LOGMNR PL/SQL procedure and, 18.2.2

DBMS_LOGMNR.START_LOGMNR PL/SQL procedure and, 18.2.2

DDL tracking

time or SCN ranges, 18.9.6

determining redo log files being analyzed, 18.3.2

dictionary

purpose of, 18.2.1

dictionary extracted to flat file

stored information about, 18.10

dictionary options, 18.3.1

flat file and, 18.3.1

online catalog and, 18.3.1

redo log files and, 18.3.1

ending a session, 18.11.6

executing reconstructed SQL, 18.6.5

extracting data values from redo logs, 18.5.2

filtering data by SCN, 18.6.4

filtering data by time, 18.6.3

formatting returned data, 18.6.6

graphical user interface, 18

levels of supplemental logging, 18.9

LogMiner dictionary defined, 18.2.1

mining a subset of data in redo log files, 18.8

mining database definition for, 18.2.1

operations overview, 18.2.2

parameters

stored information about, 18.10

redo log files

on a remote database, 18.8

stored information about, 18.10

requirements for dictionary, 18.2.1.2

requirements for redo log files, 18.2.1.2

requirements for source and mining databases, 18.2.1.2

restrictions with XMLType data, 18.5.3.1

sample configuration, 18.2.1.1

showing committed transactions only, 18.6.1

skipping corruptions, 18.6.2

source database definition for, 18.2.1

specifying redo log files to mine, 18.3.2

automatically, 18.3.2

manually, 18.3.2

specifying redo logs for analysis, 18.11.3

starting, 18.4, 18.11.4

starting multiple times within a session, 18.8

steps for extracting dictionary to a flat file, 18.3.1.3

steps for extracting dictionary to redo log files, 18.3.1.2

steps for using dictionary in online catalog, 18.3.1.1

steps in a typical session, 18.11

supplemental log groups, 18.9

conditional, 18.9

unconditional, 18.9

supplemental logging, 18.9

database level, 18.9.1

database-level identification keys, 18.9.1.2

disabling database-level, 18.9.2

interactions with DDL tracking, 18.9.5

log groups, 18.9

minimal, 18.9.1.1

stored information about, 18.10

table-level identification keys, 18.9.3.1

table-level log groups, 18.9.3.2

user-defined log groups, 18.9.3.3

support for transparent data encryption, 18.5

supported database versions, 18.13.3

supported datatypes, 18.13.1

supported redo log file versions, 18.13.3

suppressing delimiters in SQL_REDO and SQL_UNDO, 18.6.5

table-level supplemental logging, 18.9.3

tracking DDL statements, 18.9.4

requirements, 18.9.4

unsupported datatypes, 18.13.2

using the online catalog, 18.3.1.1

using to analyze redo log files, 18

V$DATABASE view, 18.10

V$LOGMNR_CONTENTS view, 18.2.2, 18.5.1, 18.6

V$LOGMNR_DICTIONARY view, 18.10

V$LOGMNR_LOGS view, 18.10

querying, 18.10.1

V$LOGMNR_PARAMETERS view, 18.9.6, 18.10

views, 18.10

LogMiner Viewer, 18

LONG data

C language datatype LONG FLOAT, 9.4.1.4

exporting, 20.27.4.2

importing, 20.28.5.11

LONG VARRAW datatype, 9.4.1.11

M

master tables

Oracle Data Pump API, 1.3.2

snapshots

original Import, 20.18.1

materialized views, 20.18

media recovery

direct path load, 11.4.6.1

Metadata API, 19

enhancing performance, 19.6

retrieving collections, 19.5

using to retrieve object metadata, 19.3

missing data columns

SQL*Loader, 8.13.6

moving databases between platforms, 20.13

multibyte character sets

blanks with SQL*Loader, 9.5.1

SQL*Loader, 8.10.1

multiple-column indexes