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

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

Backus-Naur Form syntax

See syntax diagrams

bad files

specifying for SQL*Loader, 8.8

BAD parameter

SQL*Loader command line, 7.2.1

BADFILE parameter

SQL*Loader utility, 8.8

BEGINDATA parameter

SQL*Loader control file, 8.6

BFILE columns

exporting, 20.27.4.6

importing, 20.28.5.5

BFILE datatype, 10.5

big-endian data

external tables, 14.2.5

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, 14.3.2

whitespace, 9.10

BLANKS parameter

SQL*Loader utility, 9.5.1

BNF

See syntax diagrams

bound fillers, 9.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

case studies

SQL*Loader, 12

See also SQL*Loader

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, 14.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, 12.16

character strings

external tables

specifying bytes or characters, 14.2.7

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

CLOBs

example, 12.14

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

in SQL*Loader control file, 12.8.1

with external tables, 14.1, 15.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

CONCATENATE parameter

SQL*Loader utility, 8.12

concurrent conventional path loads, 11.8.4

configuration

of LogMiner utility, 19.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

preventing Import errors due to uniqueness constraints, 20.10.2

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.2

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

example, 12.9

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

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

formatted data and SQL*Loader, 12.12

generating unique values with SQL*Loader, 9.13.6

including in control files, 8.6

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

loading in sections

SQL*Loader, 11.4.7.1

loading into more than one table

SQL*Loader, 8.15

maximum length of delimited data for SQL*Loader, 9.4.5.5

moving between operating systems using SQL*Loader, 9.7

recovery

SQL*Loader direct path load, 11.4.6

saving in a direct path load, 11.4.5

saving rows

SQL*Loader, 11.5.3

unsorted

SQL*Loader, 11.5.2.2

values optimized for SQL*Loader performance, 9.13.1

data fields

specifying the SQL*Loader datatype, 9.3.2

DATA parameter

SQL*Loader command line, 7.2.5

Data Pump Export utility

ATTACH parameter, 2.4.1

command-line mode, 2.4, 3.4

compared to original Export utility, 2.5

CONTENT parameter, 2.4.2, 2.4.2

controlling resource consumption, 4.2.1

dump file set, 2.1

DUMPFILE parameter, 2.4.4

ESTIMATE parameter, 2.4.5

ESTIMATE_ONLY parameter, 2.4.6

EXCLUDE parameter, 2.4.7

excluding objects, 2.4.7

export modes, 2.2.2

FILESIZE parameter, 2.4.8

filtering data that is exported

using EXCLUDE parameter, 2.4.7

using INCLUDE parameter, 2.4.13

FLASHBACK_SCN parameter, 2.4.9

FLASHBACK_TIME parameter, 2.4.10

FULL parameter, 2.4.11

HELP parameter

interactive-command mode, 2.6.4

INCLUDE parameter, 2.4.13

interactive-command mode, 2.6

ADD_FILE parameter, 2.6.1

CONTINUE_CLIENT parameter, 2.6.2

EXIT_CLIENT parameter, 2.6.3

HELP parameter, 2.6.4

KILL_JOB parameter, 2.6.5

PARALLEL parameter, 2.6.6

START_JOB parameter, 2.6.7

STATUS parameter, 2.6.8

STOP_JOB parameter, 2.6.9, 3.6.8

interfaces, 2.2.1

invoking

as SYSDBA, 2.2, 3.2

job names

specifying, 2.4.14

JOB_NAME parameter, 2.4.14

LOGFILE parameter, 2.4.15

NETWORK_LINK parameter, 2.4.16

NOLOGFILE parameter, 2.4.17

PARALLEL parameter

command-line mode, 2.4.18

interactive-command mode, 2.6.6

PARFILE parameter, 2.4.19

QUERY parameter, 2.4.20

SCHEMAS parameter, 2.4.21

specifying a job name, 2.4.14

syntax diagrams, 2.8

TABLES parameter, 2.4.23

TABLESPACES parameter, 2.4.24

TRANSPORT_FULL_CHECK parameter, 2.4.25

TRANSPORT_TABLESPACES parameter, 2.4.26

VERSION parameter, 2.4.27

Data Pump Import utility

ATTACH parameter, 3.4.1

attaching to an existing job, 3.4.1

changing name of source datafile, 3.4.19

command-line mode

NOLOGFILE parameter, 3.4.15

STATUS parameter, 3.4.26

compared to original Import utility, 3.5

CONTENT parameter, 3.4.2

controlling resource consumption, 4.2.1

data filters, 2.3.1, 3.3.1

DIRECTORY parameter, 3.4.3

DUMPFILE parameter, 3.4.4

ESTIMATE parameter, 3.4.5

estimating size of job, 3.4.5

EXCLUDE parameter, 3.4.6

filtering data that is imported

using EXCLUDE parameter, 3.4.6

using INCLUDE parameter, 3.4.11

FLASHBACK_SCN parameter, 3.4.7

FLASHBACK_TIME parameter, 3.4.8

full import mode, 3.2.2.1

FULL parameter, 3.4.9

HELP parameter

command-line mode, 3.4.10

interactive-command mode, 3.6.3

importing entire source, 3.4.9

INCLUDE parameter, 3.4.11

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, 2.4.22, 3.4.26, 3.6.7

STOP_JOB parameter, 3.6.8

interfaces, 3.2.1

JOB_NAME parameter, 3.4.12

LOGFILE parameter, 3.4.13

network mode

enabling, 3.4.14

NETWORK_LINK parameter, 3.4.14

PARALLEL parameter

command-line mode, 3.4.16

interactive-command mode, 3.6.5

PARFILE parameter, 3.4.17

QUERY parameter, 3.4.18

REMAP_DATAFILE parameter, 3.4.19

REMAP_SCHEMA parameter, 3.4.20

REMAP_TABLESPACE parameter, 3.4.21

REUSE_DATAFILES parameter, 3.4.22

schema mode, 3.2.2.2

SCHEMAS parameter, 3.4.23

SKIP_UNUSABLE_INDEXES parameter, 3.4.24

specifying a job name, 3.4.12

specifying dump file set to import, 3.4.4

SQLFILE parameter, 3.4.25

STREAMS_CONFIGURATION parameter, 3.4.27

syntax diagrams, 3.8

table mode, 3.2.2.3

TABLE_EXISTS_ACTION parameter, 3.4.28

TABLES parameter, 3.4.29

tablespace mode, 3.2.2.4

TABLESPACES parameter, 3.4.30

TRANSFORM parameter, 3.4.31

TRANSPORT_DATAFILES parameter, 3.4.32

TRANSPORT_FULL_CHECK parameter, 3.4.33

TRANSPORT_TABLESPACES parameter, 2.4.26, 3.4.34

transportable tablespace mode, 3.2.2.5

VERSION parameter, 3.4.35

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, 14.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, 14.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, 19.13.1

unsupported by LogMiner utility, 19.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, 13.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

DBA_DATAPUMP_JOBS view, 1.6.1

DBA_DATAPUMP_SESSIONS view, 1.6.2

DBID (database identifier)

changing, 17.3.1

DBMS_DATAPUMP PL/SQL package, 5

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, 18.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.4

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, 14.2.3

initial and trailing example, 12.12

loading trailing blanks, 9.4.5.6

marks in data and SQL*Loader, 9.4.5.4

specifying for external tables, 14.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, 19.2.1.2

dictionary version mismatch, 19.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

example, 12.11

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.7.2.1

using with Data Pump, 1.7.2.1

DIRECTORY parameter

Data Pump Export utility, 2.4.3

Data Pump Import utility, 3.4.3

discard files

SQL*Loader, 8.9

example, 12.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.4

Data Pump Import utility, 3.4.4

E

EBCDIC character set

Import, 20.17.3

eight-bit character set support, 20.17.3

enclosed fields

specified with enclosure delimiters and SQL*Loader, 9.4.5.2

whitespace, 9.10.6

enclosure delimiters, 9.4.5

SQL*Loader, 9.4.5.2, 9.10.2.2

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.5

Data Pump Import utility, 3.4.5

ESTIMATE_ONLY parameter

Data Pump Export utility, 2.4.6

estimating size of job

Data Pump Export utility, 2.4.5

EVALUATE CHECK_CONSTRAINTS clause, 11.8.1.2

EXCLUDE parameter

Data Pump Export utility, 2.4.7

Data Pump Import utility, 3.4.6

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

big-endian data, 14.2.5

column_transforms clause, 14.1

datatypes, 14.3.6

date cache feature, 13.5.1

delimiters, 14.2.3

describing datatype of a field, 14.3.6

differences in load behavior from SQL*Loader, 13.7

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, 13.5

date cache feature, 13.5.1

little-endian data, 14.2.5

record_format_info clause, 14.1, 14.2

reserved words, 13.6

restrictions, 13.6

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.12

specifying delimiters, 14.3.1

specifying load conditions, 14.2.8

trimming blanks, 14.3.2

using comments, 14.1, 15.1.1

using constructor functions with, 13.2.3

using to load data, 13.2

variable-length records, 14.2.2

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.8

Export utility, 20.9.8

Import utility, 20.10.9

FILLER field

example, 12.14

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.6

fine-grained access support

Export and Import, 20.23

fixed record length

example, 12.13

fixed-format records, 6.4.1

fixed-length records

external tables, 14.2.1

FLASHBACK_SCN parameter

Data Pump Export utility, 2.4.9

Data Pump Import utility, 3.4.7

Export utility, 20.9.9

FLASHBACK_TIME parameter

Data Pump Export utility, 2.4.10

Data Pump Import utility, 3.4.8

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.11

Data Pump Import utility, 3.4.9

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.12

interactive-command mode, 2.6.4

Data Pump Import utility

command-line mode, 3.4.10

interactive-command mode, 3.6.3

Export utility, 20.9.13

Import utility, 20.10.13

hexadecimal strings

SQL*Loader, 9.5.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

controlling size of rollback segments, 20.10.2

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

uniqueness constraints

preventing import errors, 20.10.2

user access privileges, 20.2.3

USERID parameter, 20.10.35

VOLSIZE parameter, 20.10.36

INCLUDE parameter

Data Pump Export utility, 2.4.13

Data Pump Import utility, 3.4.11

index maintenance

postponing during Data Pump Import, 3.4.24

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

original Export and Import, 20.3.4

internal LOBs

loading, 10.4.1

interrupted loads, 8.11

interval datatypes, 9.4.2.2

INTO TABLE statement

effect on bind array size, 8.16.6

multiple statements with SQL*Loader, 8.15

SQL*Loader, 8.13

column names, 9.3

discards, 8.9.4

invalid data

Import, 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

JOB_NAME parameter

Data Pump Export utility, 2.4.14

Data Pump Import utility, 3.4.12

K

key values

generating with SQL*Loader, 9.13.6

KILL_JOB parameter

Data Pump Export utility

interactive-command mode, 2.6.5

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, 14.2.5

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

combined physical records, 12.9

datafiles containing tabs

SQL*Loader, 9.2.1

delimited, free-format files, 12.8

external table data

skipping records, 14.2.12

specifying conditions, 14.2.5, 14.2.16

fixed-length data, 12.7

LOBs, 10.4

negative numbers, 12.9

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

variable-length data, 12.6

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

example, 12.14

LOBs

loading, 10.4

log files

after a discontinued load, 8.11.4

example, 12.11.4, 12.12.5

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.15

Data Pump Import utility, 3.4.13

logical records

consolidating multiple physical records using SQL*Loader, 8.12

LogMiner utility

accessing redo data of interest, 19.5

adjusting redo log file list, 19.8

analyzing output, 19.5.1

chained rows support, 19.9

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

support for, 19.9

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

direct-path inserts support, 19.9

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

index clusters support, 19.9

levels of supplemental logging, 19.9

LogMiner dictionary defined, 19.2.1

migrated rows support, 19.9

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

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

datatype support and, 19.9

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

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

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.5.2

snapshots

original Import, 20.18.1

materialized views, 20.18

media recovery

direct path load, 11.4.6.1

Metadata API, 18

enhancing performance, 18.6

retrieving collections, 18.5

using to retrieve object metadata, 18.3

missing data columns

SQL*Loader, 8.13.6

moving databases between platforms, 20.13

multibyte character sets

blanks with SQL*Loader, 9.5.1

SQL*Loader, 8.10.1

multiple-column indexes

SQL*Loader, 11.5.2.3

multiple-CPU systems

optimizing direct path loads, 11.6

multiple-table load

generating unique sequence numbers using SQL*Loader, 9.13.7

SQL*Loader control file specification, 8.15

multithreading

on multiple-CPU systems, 11.6

MULTITHREADING parameter

SQL*Loader command line, 7.2.15

N

native datatypes

conflicting length specifications

SQL*Loader, 9.4.2.9

negative numbers

loading, 12.9

nested column objects

loading, 10.1.3

nested tables

exporting, 20.27.4.9

consistency and, 20.9.3

importing, 20.28.5.3

NETWORK_LINK parameter

Data Pump Export utility, 2.4.16

Data Pump Import utility, 3.4.14

networks

Export and Import, 20.16

NLS_LANG environment variable, 20.17.2

with Export and Import, 20.17.3

NOLOGFILE parameter

Data Pump Export utility, 2.4.17

Data Pump Import utility, 3.4.15

nonrecoverable error messages

Export, 20.14.3

Import, 20.14.3

nonscalar datatypes, 10.1.5

normalizing data during a load

SQL*Loader, 12.10

NOT NULL constraint

load method, 11.3.8

null data

missing columns at end of record during load, 8.13.6

unspecified columns and SQL*Loader, 9.3

NULL values

objects, 10.1.5

NULLIF clause

SQL*Loader, 9.5, 9.9

NULLIF...BLANKS clause

example, 12.11.1, 12.11.1

SQL*Loader, 9.5.1

nulls

atomic, 10.1.5.2

attribute, 10.1.5.1

NUMBER datatype

SQL*Loader, 9.4.3, 9.4.4

numeric EXTERNAL datatypes

delimited form and SQL*Loader, 9.4.5

determining length, 9.4.6

SQL*Loader, 9.4.2.5

O

object identifiers, 10.2

importing, 20.28.5.1

object names

SQL*Loader, 8.3

object support, 6.11

object tables

loading, 10.2, 10.2

with a subtype

loading, 10.2.1

object type definitions

exporting, 20.27.4.8

OBJECT_CONSISTENT parameter

Export utility, 20.9.16

objects, 6.10

considerations for importing, 20.28.5

creation errors, 20.28.1.2.1

ignoring existing objects during import, 20.10.14

import creation errors, 20.10.14

loading nested column objects, 10.1.3

NULL values, 10.1.5

stream record format, 10.1.1

variable record format, 10.1.2

offline locally managed tablespaces

exporting, 20.27.4.4

OID

See object identifiers

online help

Export and Import, 20.3.5

operating systems

moving data to different systems using SQL*Loader, 9.7

OPTIMAL storage parameter

used with Export/Import, 20.26.1

optimizer statistics, 20.28.3

optimizing

direct path loads, 11.5

SQL*Loader input file processing, 8.7

OPTIONALLY ENCLOSED BY clause

SQL*Loader, 9.10.2.2

OPTIONS parameter

for parallel loads, 8.13.3

SQL*Loader utility, 8.2.1

Oracle Advanced Queuing

See Advanced Queuing

Oracle Data Pump

direct path loads

restrictions, 1.3.1

direct path unload, 1.3.1

external tables access driver, 1.3.2

features requiring privileges, 1.2

master table, 1.5.2

tuning performance, 4.2

Oracle Data Pump API, 5

client interface, 5.1

job states, 5.1.1

monitoring job progress, 1.6.3

Oracle Data Pump views

DBA_DATAPUMP_JOBS, 1.6.1

DBA_DATAPUMP_SESSIONS, 1.6.2

USER_DATAPUMP_JOBS, 1.6.1

ORACLE_DATAPUMP access driver

reserved words, 15, 15.5

ORACLE_LOADER access driver

reserved words, 14, 14.5

OWNER parameter

Export utility, 20.9.17

P

padding of literal strings

SQL*Loader, 9.5.2

parallel loads, 11.9

restrictions on direct path, 11.9.4

PARALLEL parameter

Data Pump Export utility

command-line interface, 2.4.18

interactive-command mode, 2.6.6

Data Pump Import utility

command-line mode, 3.4.16

interactive-command mode, 3.6.5

SQL*Loader command line, 7.2.16

parameter files

Export, 20.9.18

Export and Import

comments in, 20.3.3

maximum size, 20.3.3

Import, 20.10.18

SQL*Loader, 7.2.17

PARFILE parameter

Data Pump Export utility, 2.4.19

Data Pump Import utility, 3.4.17

Export command line, 20.9.18

Import command line, 20.10.18

SQL*Loader command line, 7.2.17

partitioned loads

concurrent conventional path loads, 11.8.4

SQL*Loader, 11.8.4

partitioned tables

example, 12.13

export consistency and, 20.9.3

exporting, 20.8.1

importing, 20.8.2.1, 20.12.1

loading, 11.3.2

partitioning a database migration, 20.29

advantages of, 20.29

disadvantages of, 20.29

procedure during export, 20.29.3

partition-level Export, 20.8.1

example session, 20.11.4

partition-level Import, 20.8.2

specifying, 20.9.26

pattern matching

table names during import, 20.10.29

performance

Import, 20.10.2

improving when using integrity constraints, 11.8.4

issues when using external tables, 13.5

optimizing for direct path loads, 11.5

optimizing reading of SQL*Loader data files, 8.7

tuning original Import, 20.28.4

performance tuning

Oracle Data Pump, 4.2

PIECED parameter

SQL*Loader, 11.4.7.1

POSITION parameter

using with data containing tabs, 9.2.1

with multiple SQL*Loader INTO TABLE clauses, 8.15.2.1, 9.2, 9.2.2

predetermined size fields

SQL*Loader, 9.10.2.1

predetermined size LOBs, 10.4.2.2.2

prerequisites

SQL*Loader, 11.1

PRESERVE parameter, 8.12.2

preserving

whitespace, 9.11

presorting

data for a direct path load

example, 12.11

PRIMARY KEY constraints

effect on direct path load, 11.9.8

primary key OIDs

example, 10.2, 12.15

primary key REF columns, 10.3.2, 10.3.2

privileges

EXEMPT ACCESS POLICY

effect on direct path export, 20.27.2.1

required for Export and Import, 20.2.1

required for SQL*Loader, 11.1

Q

QUERY parameter

Data Pump Export utility, 2.4.20

Data Pump Import utility, 3.4.18

Export utility, 20.9.19

restrictions, 20.9.19.1

quotation marks

escape characters and, 8.3.3.2

filenames and, 8.3.3.1

SQL strings and, 8.3.2

table names and, 20.9.26.1, 20.10.29.1

usage in Data Pump Export, 2.4

usage in Data Pump Import, 3.4

use with database object names, 8.3.1

R

RAW datatype

SQL*Loader, 9.4.2.6

read-consistent export, 20.9.3

read-only tablespaces

Import, 20.20

READSIZE parameter

SQL*Loader command line, 7.2.18

effect on LOBs, 7.2.18

maximum size, 7.2.18

RECNUM parameter

use with SQL*Loader SKIP parameter, 9.13.4

RECORDLENGTH parameter

Export utility, 20.9.20

Import utility, 20.10.19

records

consolidating into a single logical record

SQL*Loader, 8.12

discarded by SQL*Loader, 6.7, 8.9

DISCARDMAX command-line parameter, 7.2.9

distinguishing different formats for SQL*Loader, 8.15.2

extracting multiple logical records using SQL*Loader, 8.15

fixed format, 6.4.1

missing data columns during load, 8.13.6

rejected by SQL*Loader, 6.7, 6.7.1.1, 6.7.1.2, 8.8

setting column to record number with SQL*Loader, 9.13.4

specifying how to load, 7.2.13

specifying length for export, 20.9.20

specifying length for import, 20.10.19

stream record format, 6.4.3

recovery

direct path load

SQL*Loader, 11.4.6

replacing rows, 8.13.2.2

redo log file

LogMiner utility

versions supported, 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, 11.4.6.1

instance and media recovery

SQL*Loader, 11.4.6.1

minimizing use during direct path loads, 11.5.4

saving space

direct path load, 11.5.4.2

REF columns, 10.3

loading, 10.3

primary key, 10.3.2

system-generated, 10.3.1

REF data

importing, 20.28.5.4

REF fields

example, 12.15

referential integrity constraints

disabling for import, 20.6.2

SQL*Loader, 11.8

refresh error

snapshots

Import, 20.18.1

reject files

specifying for SQL*Loader, 8.8

rejected records

SQL*Loader, 6.7, 8.8

relative field positioning

where a field starts and SQL*Loader, 9.10.3

with multiple SQL*Loader INTO TABLE clauses, 8.15.1.1

REMAP_DATAFILE parameter

Data Pump Import utility, 3.4.19

REMAP_SCHEMA parameter

Data Pump Import utility, 3.4.20

REMAP_TABLESPACE parameter

Data Pump Import utility, 3.4.21

remote operation

Export/Import, 20.16.2

REPLACE table

example, 12.9

replacing a table using SQL*Loader, 8.13.2.2.2

reserved words

external tables, 13.6

ORACLE_DATAPUMP access driver, 15, 15.5

ORACLE_LOADER access driver, 14, 14.5

SQL*Loader, 6.3

resource consumption

controlling in Data Pump Export utility, 4.2.1

controlling in Data Pump Import utility, 4.2.1

resource errors

Import, 20.28.1.2.3

RESOURCE role, 20.4

restrictions

importing into another user's schema, 20.4.2

table names in Export parameter file, 20.9.26.1

table names in Import parameter file, 20.10.29.1

RESUMABLE parameter

Export utility, 20.9.21

Import utility, 20.10.20

SQL*Loader utility, 7.2.19

resumable space allocation

enabling and disabling, 7.2.19, 20.9.21, 20.10.20

RESUMABLE_NAME parameter

Export utility, 20.9.22

Import utility, 20.10.21

SQL*Loader utility, 7.2.20

RESUMABLE_TIMEOUT parameter

Export utility, 20.9.23

Import utility, 20.10.22

SQL*Loader utility, 7.2.21

retrieving object metadata

using Metadata API, 18.3

REUSE_DATAFILES parameter

Data Pump Import utility, 3.4.22

roles

EXP_FULL_DATABASE, 20.2.3

RESOURCE, 20.4

rollback segments

controlling size during import, 20.10.2

effects of CONSISTENT Export parameter, 20.9.3

row errors

Import, 20.28.1.1.1

ROWID columns

loading with SQL*Loader, 11.1.1

rows

choosing which to load using SQL*Loader, 8.13.4

exporting, 20.9.24

specifying for import, 20.10.23

specifying number to insert before save

SQL*Loader, 11.4.5.1

updates to existing rows with SQL*Loader, 8.13.2.2.3

ROWS parameter

Export utility, 20.9.24

Import utility, 20.10.23

performance issues

SQL*Loader, 11.5.3

SQL*Loader command line, 7.2.22

using to specify when data saves occur, 11.4.5.1

S

schema mode export

Data Pump Export utility, 2.2.2.2

schemas

specifying for Export, 20.9.26

SCHEMAS parameter

Data Pump Export utility, 2.4.21

Data Pump Import utility, 3.4.23

scientific notation for FLOAT EXTERNAL, 9.4.2.5

script files

running before Export and Import, 20.2.1

SDFs

See secondary datafiles

secondary datafiles, 6.5, 10.6.2

security considerations

direct path export, 20.27.2.1

segments

temporary

FILE parameter in SQL*Loader, 11.9.6.1

sequence numb, 9.13.6

sequence numbers

cached, 20.27.4.1

exporting, 20.27.4.1

for multiple tables and SQL*Loader, 9.13.7

generated by SQL*Loader SEQUENCE clause, 9.13.6, 12.8

generated, not read and SQL*Loader, 9.3

short records with missing data

SQL*Loader, 8.13.6

SHORTINT datatype

C language, 9.4.1.2

SHOW parameter

Import utility, 20.10.24

SILENT parameter

SQL*Loader command line, 7.2.23

single-byte character sets

Export and Import, 20.17.3

SINGLEROW parameter, 8.14.2, 11.7

single-table loads

continuing, 8.11.5

SKIP parameter

effect on SQL*Loader RECNUM specification, 9.13.4

SQL*Loader command line, 7.2.24, 7.2.24

SKIP_INDEX_MAINTENANCE parameter

SQL*Loader command line, 7.2.25, 11.7

SKIP_UNUSABLE_INDEXES parameter

Import utility, 20.10.25

SQL*Loader command line, 7.2.26, 11.7

SKIP_USABLE_INDEXES parameter

Data Pump Import utility, 3.4.24

skipping index maintenance, 7.2.25, 11.7

skipping unusable indexes, 7.2.26, 11.7

SMALLINT datatype, 9.4.1.2

snapshot log

Import, 20.18.1

snapshots, 20.18.2

importing, 20.18

master table

Import, 20.18.1

restoring dropped

Import, 20.18.2.1

SORTED INDEXES clause

direct path loads, 8.14.1

example, 12.11.1

SQL*Loader, 11.5.2.1

sorting

multiple-column indexes

SQL*Loader, 11.5.2.3

optimum sort order

SQL*Loader, 11.5.2.4

presorting in direct path load, 11.5.2

SORTED INDEXES clause

SQL*Loader, 11.5.2.1

SQL operators

applying to fields, 9.12

SQL strings

applying SQL operators to fields, 9.12

example, 12.12

quotation marks and, 8.3.2

SQL*Lo, 8.12

SQL*Loader

appending rows to tables, 8.13.2.2.1

BAD command-line parameter, 7.2.1

bad file, 7.2.1

BADFILE parameter, 8.8

bind arrays and performance, 8.16.2

BINDSIZE command-line parameter, 7.2.2, 8.16.3

case studies, 12

direct path load, 12.11

extracting data from a formatted report, 12.12

loading combined physical records, 12.9

loading data in Unicode character set, 12.16

loading data into multiple tables, 12.10

loading delimited, free-format files, 12.8

loading fixed-length data, 12.7

loading LOBFILEs (CLOBs), 12.14

loading partitioned tables, 12.13

loading REF fields, 12.15

loading variable-length data, 12.6

loading VARRAYs, 12.15

choosing which rows to load, 8.13.4

COLUMNARRAYROWS command-line parameter, 7.2.3

command-line parameters, 7.1

CONTINUEIF parameter, 8.12

continuing single-table loads, 8.11.5

CONTROL command-line parameter, 7.2.4

conventional path loads, 11.2

DATA command-line parameter, 7.2.5

data conversion, 6.6

data definition language

syntax diagrams, A

datatype specifications, 6.6

DATE_CACHE command-line parameter, 7.2.6

determining default schema, 8.13.1.1

DIRECT command-line parameter, 11.4.2

direct path method, 6.9.2

using date cache feature to improve performance, 11.5.6

DISCARD command-line parameter, 7.2.8

discarded records, 6.7

DISCARDFILE parameter, 8.9.1

DISCARDMAX command-line parameter, 7.2.9

DISCARDMAX parameter, 8.9.6

DISCARDS parameter, 8.9.6

errors caused by tabs, 9.2.1

ERRORS command-line parameter, 7.2.10

example sessions, 12

exclusive access, 11.8.3

FILE command-line parameter, 7.2.12

filenames, 8.3

globalization technology, 8.10

index options, 8.14

inserting rows into tables, 8.13.2.1.1

INTO TABLE statement, 8.13

LOAD command-line parameter, 7.2.13

load methods, 11.1

loading column objects, 10.1

loading data across different platforms, 9.7

loading data contained in the control file, 9.13.1

loading object tables, 10.2

LOG command-line parameter, 7.2.14

log files, 6.8

methods of loading data, 6.9

multiple INTO TABLE statements, 8.15

MULTITHREADING command-line parameter, 7.2.15

object names, 8.3

parallel data loading, 11.9, 11.9.3, 11.10

PARFILE command-line parameter, 7.2.17

READSIZE command-line parameter, 7.2.18

maximum size, 7.2.18

rejected records, 6.7

replacing rows in tables, 8.13.2.2.2

required privileges, 11.1

RESUMABLE parameter, 7.2.19

RESUMABLE_NAME parameter, 7.2.20

RESUMABLE_TIMEOUT parameter, 7.2.21

ROWS command-line parameter, 7.2.22

SILENT command-line parameter, 7.2.23

SINGLEROW parameter, 8.14.2

SKIP_INDEX_MAINTENANCE command-line parameter, 7.2.25

SKIP_UNUSABLE_INDEXES command-line parameter, 7.2.26

SORTED INDEXES during direct path loads, 8.14.1

specifying columns, 9.3

specifying datafiles, 8.5

specifying field conditions, 9.5

specifying fields, 9.3

specifying more than one datafile, 8.5.2

STREAMSIZE command-line parameter, 7.2.27

suppressing messages, 7.2.23

updating rows, 8.13.2.2.3

USERID command-line parameter, 7.2.28

SQLFILE parameter

Data Pump Import utility, 3.4.25

START_JOB parameter

Data Pump Export utility

interactive-command mode, 2.6.7

Data Pump Import utility

interactive-command mode, 3.6.6

starting

LogMiner utility, 19.4

statistics

analyzer, 20.28.3

database optimizer

specifying for Export, 20.9.25

optimizer, 20.28.3

specifying for Import, 20.10.26

STATISTICS parameter

Export utility, 20.9.25

Import utility, 20.10.26

STATUS parameter

Data Pump Export utility, 2.4.22

interactive-command mode, 2.6.8

Data Pump Import utility, 3.4.26

interactive-command mode, 3.6.7

STOP_JOB parameter

Data Pump Export utility

interactive-command mode, 2.6.9

Data Pump Import utility

interactive-command mode, 3.6.8

STORAGE parameter, 11.9.6.1.2

storage parameters

estimating export requirements, 20.2.2

OPTIMAL parameter, 20.26.1

overriding

Import, 20.26.3

preallocating

direct path load, 11.5.1

temporary for a direct path load, 11.4.3.2

using with Export/Import, 20.26

stored functions

importing, 20.28.5.7

effect of COMPILE parameter, 20.28.5.7

stored package, 20.28.5.7

stored packages

importing, 20.28.5.7

stored procedures

direct path load, 11.8.2.6

importing, 20.28.5.7

effect of COMPILE parameter, 20.28.5.7

stream buffer

specifying size for direct path, 11.5.5

stream record format, 6.4.3

loading column objects in, 10.1.1

STREAMS_CONFIGURATION parameter

Data Pump Import utility, 3.4.27

Import utility, 20.10.27

STREAMS_INSTANTIATION parameter

Import utility, 20.10.28

STREAMSIZE parameter

SQL*Loader command line, 7.2.27

string comparisons

SQL*Loader, 9.5.2

subpartitioned tables

loading, 11.3.2

subtypes

loading multiple, 8.15.3

supplemental logging

LogMiner utility, 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

See also LogMiner utility

synonyms

direct path load, 11.3.10

exporting, 20.27.4.11

syntax diagrams

Data Pump Export, 2.8

Data Pump Import, 3.8

SQL*Loader, A

symbols used in BNF variant, B

SYSDATE datatype

example, 12.12

SYSDATE parameter

SQL*Loader, 9.13.5

system objects

importing, 20.4.3

system triggers

effect on import, 20.7

testing, 20.7

system-generated OID REF columns, 10.3.1

T

table names

preserving case sensitivity, 20.9.26.1

TABLE_EXISTS_ACTION parameter

Data Pump Import utility, 3.4.28

table-level Export, 20.8.1

table-level Import, 20.8.2

table-mode Export

Data Pump Export utility, 2.2.2.3

specifying, 20.9.26

table-mode Import

examples, 20.12.1

tables

Advanced Queuing

exporting, 20.27.4.10

importing, 20.28.5.10

appending rows with SQL*Loader, 8.13.2.2.1

defining before Import, 20.6.1

definitions

creating before Import, 20.6.1

exclusive access during direct path loads

SQL*Loader, 11.8.3

external, 13

importing, 20.10.29

insert triggers

direct path load in SQL*Loader, 11.8.2

inserting rows using SQL*Loader, 8.13.2.1.1

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

loading object tables, 10.2

maintaining consistency during Export, 20.9.3

manually ordering for Import, 20.6.3

master table

Import, 20.18.1

name restrictions

Export, 20.9.26.1

Import, 20.10.29, 20.10.29.1

nested

exporting, 20.27.4.9

importing, 20.28.5.3

objects

order of import, 20.5

partitioned, 20.8.1

replacing rows using SQL*Loader, 8.13.2.2.2

specifying for export, 20.9.26

specifying table-mode Export, 20.9.26

SQL*Loader method for individual tables, 8.13.2

truncating

SQL*Loader, 8.13.2.2.4

updating existing rows using SQL*Loader, 8.13.2.2.3

See also external tables

TABLES parameter

Data Pump Export utility, 2.4.23

Data Pump Import utility, 3.4.29

Export utility, 20.9.26

Import utility, 20.10.29

tablespace mode Export

Data Pump Export utility, 2.2.2.4

tablespaces

dropping during import, 20.21

exporting a set of, 20.19

metadata

transporting, 20.10.33

read-only

Import, 20.20

reorganizing

Import, 20.22

TABLESPACES parameter

Data Pump Export utility, 2.4.24

Data Pump Import utility, 3.4.30

Export utility, 20.9.27

Import utility, 20.10.30

tabs

loading datafiles containing tabs, 9.2.1

trimming, 9.10

whitespace, 9.10

temporary segments, 11.9.6.1

FILE parameter

SQL*Loader, 11.9.6.1

temporary storage in a direct path load, 11.4.3.2

TERMINATED BY clause

WHITESPACE

SQL*Loader, 9.4.5.1

with OPTIONALLY ENCLOSED BY, 9.10.2.2

terminated fields

specified with a delimiter, 9.10.2.2

specified with delimiters and SQL*Loader, 9.4.5.1

time

SQL*Loader datatypes for, 9.4.2.2

TOID_NOVALIDATE parameter

Import utility, 20.10.31

TOUSER parameter

Import utility, 20.10.32

trailing blanks

loading with delimiters, 9.4.5.6

TRAILING NULLCOLS parameter

example, 12.12

SQL*Loader utility, 8.1, 8.13.6.1

trailing whitespace

trimming, 9.10.5

TRANSFORM parameter

Data Pump Import utility, 3.4.31

TRANSPORT_DATAFILES parameter

Data Pump Import utility, 3.4.32

TRANSPORT_FULL_CHECK parameter

Data Pump Export utility, 2.4.25

Data Pump Import utility, 3.4.33

TRANSPORT_TABLESPACE parameter

Export utility, 20.9.28

Import utility, 20.10.33

TRANSPORT_TABLESPACES parameter

Data Pump Export utility, 2.4.26

Data Pump Import utility, 3.4.34

transportable tablespaces, 20.19

transportable-tablespace mode Export

Data Pump Export utility, 2.2.2.5

triggers

database insert, 11.8.2

logon

effect in SQL*Loader, 8.13.1.1

permanently disabled, 11.8.3

replacing with integrity constraints, 11.8.2.1

system

testing, 20.7

update

SQL*Loader, 11.8.2.4

TRIGGERS parameter

Export utility, 20.9.29

trimming

summary, 9.10

trailing whitespace

SQL*Loader, 9.10.5

TTS_FULL_CHECK parameter

Export utility, 20.9.30

TTS_OWNERS parameter

Import utility, 20.10.34

U

UNIQUE KEY constraints

effect on direct path load, 11.9.8

unique values

generating with SQL*Loader, 9.13.6

uniqueness constraints

preventing errors during import, 20.10.2

unloading entire database

Data Pump Export utility, 2.2.2.1

UNRECOVERABLE clause

SQL*Loader, 11.5.4.2

unsorted data

direct path load

SQL*Loader, 11.5.2.2

updating

rows in a table

SQL*Loader, 8.13.2.2.3

user mode export

specifying, 20.9.17

USER_DATAPUMP_JOBS view, 1.6.1

USER_SEGMENTS view

Export and, 20.2.2

user-defined constructors, 10.1.6

loading column objects with, 10.1.6

USERID parameter

Export utility, 20.9.31

Import utility, 20.10.35

SQL*Loader command line, 7.2.28

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.6.3

value datatypes, 9.4, 9.4

VARCHAR datatype

SQL*Loader, 9.4.1.9

VARCHAR2 datatype

SQL*Loader, 9.4.3

VARCHARC datatype

SQL*Loader, 9.4.2.7

VARGRAPHIC datatype

SQL*Loader, 9.4.1.8

variable records, 6.4.2

format, 10.1.2

variable-length records

external tables, 14.2.2

VARRAW datatype, 9.4.1.10

VARRAWC datatype, 9.4.2.8

VARRAY columns

memory issues when loading, 10.8.1

VERSION parameter

Data Pump Export utility, 2.4.27

Data Pump Import utility, 3.4.35

VOLSIZE parameter

Export utility, 20.9.32

Import utility, 20.10.36

W

warning messages

Export, 20.14.2

Import, 20.14.2

WHEN clause

example, 12.10

SQL*Loader, 8.13.4, 9.5

SQL*Loader discards resulting from, 8.9.4

whitespace

included in a field, 9.10.4

leading, 9.10.1

preserving, 9.11

terminating a field, 9.4.5, 9.10.4.1

trimming, 9.10

X

XML columns

loading, 10.4

treatment by SQL*Loader, 10.4

XML type tables

identifying in SQL*Loader, 8.4

XMLTYPE clause

in SQL*Loader control file, 8.4

Z

ZONED datatype, 9.4.1.6

EXTERNAL format

SQL*Loader, 9.4.2.5