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