Skip Headers

Oracle9i Database Utilities
Release 2 (9.2)

Part Number A96652-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


A

access privileges
Export, 1-5
Import, 2-5
Advanced Queuing
exporting advanced queue tables, 1-58
importing advanced queue tables, 2-61
aliases
directory
exporting, 1-57
importing, 2-59
analyzer statistics, 2-68
ANYDATA type
effect on table-mode import, 2-13
APPEND parameter
for SQL*Loader utility, 5-38
append to table
example, 10-11
SQL*Loader, 5-33
archiving
disabling
effect on direct path loads, 9-20
arrays
committing after insert, 2-19
atomic null, 7-7
attributes
null, 7-6
attribute-value constructor, 7-8
attribute-value constructors
overriding, 7-8

B

backslash escape character, 5-6
backups
restoring dropped snapshots
Import, 2-64
Backus-Naur Form syntax
See syntax diagrams
bad files
specifying for SQL*Loader, 5-11
BAD parameter
for SQL*Loader command line, 4-3
BADDN parameter
for SQL*Loader utility, 5-12
BADFILE parameter
for SQL*Loader utility, 5-12
BEGINDATA parameter
for SQL*Loader control file, 5-10
BFILE columns
exporting, 1-57
importing, 2-59
BFILE datatype, 7-22
big endian data
external tables, 12-7
bind arrays
determining size of for SQL*Loader, 5-45
minimizing SQL*Loader memory requirements, 5-49
minimum requirements, 5-44
size with multiple SQL*Loader INTO TABLE statements, 5-50
specifying maximum size, 4-4
specifying number of rows, 4-12
SQL*Loader performance implications, 5-44
BINDSIZE parameter
for SQL*Loader command line, 4-4, 5-45
blanks
loading fields consisting of blanks, 6-41
SQL*Loader BLANKS parameter for field comparison, 6-31
trailing, 6-27
trimming, 6-42
external tables, 12-19
whitespace, 6-42
BLANKS parameter
for SQL*Loader utility, 6-31
BNF
See syntax diagrams
bound fillers, 6-6
BUFFER parameter
for Export utility, 1-16
for Import utility, 2-18
buffers
calculating for export, 1-17
space required by
VARCHAR data in SQL*Loader, 6-13
specifying with SQL*Loader BINDSIZE parameter, 5-45
byte order, 6-37
big endian, 6-37
little endian, 6-37
specifying in SQL*Loader control file, 6-38
byte order marks, 6-39
precedence
for first primary datafile, 6-39
for LOBFILEs and SDFs, 6-40
suppressing checks for, 6-41
BYTEINT datatype, 6-10
BYTEORDER parameter
for SQL*Loader utility, 6-38
BYTEORDERMARK parameter
for SQL*Loader utility, 6-41

C

cached sequence numbers
Export, 1-56
case studies
SQL*Loader, 10-1
SQL*Loader filenames, 10-4
See also SQL*Loader
catalog.sql script
preparing database for Export, 1-3
preparing database for Import, 2-5
catexp.sql script
preparing database for Export, 1-3
preparing database for Import, 2-5
catldr.sql script
preparing for direct path loads, 9-10
changing a database ID, 14-2
changing a database name, 14-4
CHAR columns
version 6 export files, 2-71
CHAR datatype
delimited form and SQL*Loader, 6-24
reference
SQL*Loader, 6-15
character datatypes
conflicting fields, 6-28
character fields
delimiters and SQL*Loader, 6-15, 6-24
determining length for SQL*Loader, 6-28
SQL*Loader datatypes, 6-15
character sets
conversion
during Export/Import, 1-54, 2-54
eight-bit to seven-bit conversions
Export/Import, 1-54, 2-55
identifying for external tables, 12-7
multibyte
SQL*Loader, 5-17
single-byte
Export/Import, 1-54, 2-55
SQL*Loader control file, 5-21
SQL*Loader conversion between, 5-16
Unicode, 5-17, 10-47
version 6 conversions
Import/Export, 2-56
character strings
external tables
specifying bytes or characters, 12-8
SQL*Loader, 6-32
character-length semantics, 5-22
CHARACTERSET parameter
for SQL*Loader utility, 5-20
CHARSET parameter
for Import utility, 2-18
check constraints
overriding disabling of, 9-26
CLOBs
example, 10-38
collections, 3-13
loading, 7-29
column array rows
specifying number of, 9-21
column objects
loading, 7-1
with user-defined constructors, 7-8
COLUMNARRAYROWS parameter
for SQL*Loader command line, 4-4
columns
exporting LONG datatypes, 1-56
loading REF columns, 7-15
naming
SQL*Loader, 6-5
objects
loading nested column objects, 7-4
stream record format, 7-2
variable record format, 7-3
reordering before Import, 2-8
setting to a constant value with SQL*Loader, 6-55
setting to a unique sequence number with SQL*Loader, 6-57
setting to an expression value with SQL*Loader, 6-56
setting to null with SQL*Loader, 6-55
setting to the current date with SQL*Loader, 6-56
setting to the datafile record number with SQL*Loader, 6-56
specifying
SQL*Loader, 6-5
specifying as PIECED
SQL*Loader, 9-16
using SQL*Loader, 6-56
command-line parameters
Export, 1-13
Import, 2-14
specifying in SQL*Loader control file, 5-4
SQL*Loader, 4-1
comments
in Export parameter file, 1-7
in Import parameter file, 2-12
in SQL*Loader control file, 10-12
with external tables, 12-2
COMMIT parameter
for Import utility, 2-19
COMPILE parameter
for Import utility, 2-19
completion messages
Export, 1-49
Import, 2-46
COMPRESS parameter
for Export utility, 1-17
CONCATENATE parameter
for SQL*Loader utility, 5-27
concurrent conventional path loads, 9-30
connect strings
Oracle Net, 1-53
CONSISTENT parameter
for Export utility, 1-18
nested tables and, 1-18
partitioned table and, 1-18
consolidating
extents, 1-17
CONSTANT parameter
SQL*Loader, 6-55
constraints
automatic integrity and SQL*Loader, 9-27
direct path load, 9-25
disabling referential constraints, 2-8
enabling
after a parallel direct path load, 9-34
enforced on a direct load, 9-25
failed
Import, 2-48
load method, 9-10
preventing Import errors due to uniqueness constraints, 2-19
CONSTRAINTS parameter
for Export utility, 1-20
for Import utility, 2-20
constructors
attribute-value, 7-8
overriding, 7-8
user-defined, 7-8
loading column objects with, 7-8
CONTINUEIF parameter
example, 10-15
for SQL*Loader utility, 5-27
control files
character sets, 5-21
creating
guidelines, 3-3
data definition language syntax, 5-2
specifying data, 5-10
specifying SQL*Loader discard file, 5-14
CONTROL parameter
for SQL*Loader command line, 4-4
conventional path Export
compared to direct path, 1-50
conventional path loads
behavior when discontinued, 5-24
compared to direct path loads, 9-9
concurrent, 9-31
of a single partition, 9-4
SQL*Loader bind array, 5-44
when to use, 9-4
conversion of character sets
during Export/Import, 1-54
effect of character set sorting on, 1-54
conversion of data
during direct path loads, 9-6
conversion of input characters, 5-19
CREATE SESSION privilege
Export, 1-4
Import, 2-5
CREATE USER command
Import, 2-71
creating
tables
manually, 2-8

D

data
delimiter marks in data and SQL*Loader, 6-26
distinguishing different input formats for SQL*Loader, 5-39
distinguishing different input row object subtypes, 5-39, 5-41
exporting, 1-27
formatted data and SQL*Loader, 10-28
generating unique values with SQL*Loader, 6-57
including in control files, 5-10
loading data contained in the SQL*Loader control file, 6-55
loading in sections
SQL*Loader, 9-16
loading into more than one table
SQL*Loader, 5-39
maximum length of delimited data for SQL*Loader, 6-27
moving between operating systems using SQL*Loader, 6-36
saving in a direct path load, 9-13
saving rows
SQL*Loader, 9-20
unsorted
SQL*Loader, 9-18
values optimized for SQL*Loader performance, 6-55
data conversion
direct path load, 9-6
data fields
specifying the SQL*Loader datatype, 6-7
DATA parameter
for SQL*Loader command line, 4-5
data path loads
direct and conventional, 9-1
data recovery
direct path load
SQL*Loader, 9-15
database ID (DBID)
changing, 14-2
database identifier
changing, 14-2
database migration
partitioning of, 1-60
database name (DBNAME)
changing, 14-4
database objects
exporting LONG columns, 1-56
extracting metadata of, 15-1
databases
changing the database ID, 14-2
changing the name, 14-4
exporting entire, 1-23
full import, 2-22
privileges for exporting, 1-4
reducing fragmentation, 2-53
reusing existing datafiles
Import, 2-20
datafiles
preventing overwrite during import, 2-20
reusing during import, 2-20
specifying, 4-5
specifying buffering for SQL*Loader, 5-11
specifying for SQL*Loader, 5-7
specifying format for SQL*Loader, 5-11
DATAFILES parameter
for Import utility, 2-20
datatypes
BFILE
Export, 1-57
Import, 2-59
BYTEINT, 6-10
CHAR, 6-15
conflicting character datatype fields, 6-28
converting SQL*Loader, 6-22
DATE, 6-16
datetime, 6-16
DECIMAL, 6-11
default in SQL*Loader, 6-7
describing for external table fields, 12-24
determining character field lengths for SQL*Loader, 6-28
determining DATE length, 6-29
DOUBLE, 6-10
FLOAT, 6-10
GRAPHIC, 6-18
GRAPHIC EXTERNAL, 6-19
identifying for external tables, 12-21
INTEGER (n), 6-8
interval, 6-16
length-value, 6-7
LONG
Export, 1-56
Import, 2-61
LONG VARRAW, 6-14
native
conflicting length specifications in SQL*Loader, 6-21
nonportable, 6-8
nonscalar, 7-6
NUMBER
SQL*Loader, 6-23
numeric EXTERNAL, 6-19
portable, 6-14
RAW, 6-20
SMALLINT, 6-9
specifying the SQL*Loader datatype of a data field, 6-7
value, 6-7
VARCHAR, 6-13
VARCHAR2
SQL*Loader, 6-23
VARCHARC, 6-20
VARGRAPHIC, 6-12
VARRAW, 6-14
VARRAWC, 6-21
ZONED, 6-10
date cache
DATE_CACHE parameter, 4-5
external tables, 11-6
date cache feature
SQL*Loader, 9-22
DATE datatype
delimited form and SQL*Loader, 6-24
determining length, 6-29
mask
SQL*Loader, 6-29
SQL*Loader, 6-16
DATE_CACHE parameter
for SQL*Loader utility, 4-5
datetime datatypes, 6-16
DB2 load utility
placement of statements
DISCARDDN, B-3
DISCARDS, B-3
restricted capabilities of SQL*Loader, B-3
RESUME parameter, 5-33
SQL*Loader compatibility
ignored statements, B-2
DBA role
EXP_FULL_DATABASE role, 1-4
DBCS (DB2 double-byte character set)
not supported by Oracle, B-4
DBID (database identifier)
changing, 14-2
DBMS_METADATA package, 15-4
browsing interface, 15-10
programmatic interface, 15-4
security, 15-4
using to implement Metadata API, 15-4
DBNAME
changing, 14-4
DBNEWID utility, 14-1
changing a database ID, 14-2
changing a database name, 14-4
examples, 14-9
restrictions, 14-8
reverting a stalled change operation, 14-6
syntax, 14-7
troubleshooting a database ID change, 14-5
troubleshooting a database name change, 14-6
DBVERIFY utility
output, 13-3
restrictions, 13-1
syntax, 13-2
validating a segment, 13-4
validating disk blocks, 13-2
DECIMAL datatype, 6-11
EXTERNAL format
SQL*Loader, 6-19
DEFAULT column values
Oracle version 6 export files, 2-71
DEFAULTIF parameter
SQL*Loader, 6-29
DELETE ANY TABLE privilege
SQL*Loader, 5-34
DELETE CASCADE
effect on loading nonempty tables, 5-34
SQL*Loader, 5-34
DELETE privilege
SQL*Loader, 5-33
delimited data
maximum length for SQL*Loader, 6-27
delimited fields
field length, 6-28
delimited LOBs, 7-26
delimiters
in external tables, 12-6
initial and trailing example, 10-28
loading trailing blanks, 6-27
marks in data and SQL*Loader, 6-26
specifying for external tables, 12-16
specifying for SQL*Loader, 5-36, 6-24
SQL*Loader enclosure, 6-45
SQL*Loader field specifications, 6-45
termination, 6-46
DESTROY parameter
for Import utility, 2-20
DIRECT parameter
for Export utility, 1-20
direct path Export, 1-50, 1-52
compared to conventional path, 1-50
effect of EXEMPT ACCESS POLICY privilege, 1-52
performance issues, 1-53
security considerations, 1-52
direct path load
advantages, 9-8
behavior when discontinued, 5-24
choosing sort order
SQL*Loader, 9-19
compared to conventional path load, 9-9
concurrent, 9-31
conditions for use, 9-8
data saves, 9-13, 9-20
DIRECT command-line parameter
SQL*Loader, 9-11
dropping indexes, 9-24
effect of disabling archiving, 9-20
effect of PRIMARY KEY constraints, 9-35
effect of UNIQUE KEY constraints, 9-35
example, 10-24
field defaults, 9-10
improper sorting
SQL*Loader, 9-18
indexes, 9-11
instance recovery, 9-15
intersegment concurrency, 9-31
intrasegment concurrency, 9-31
loading into synonyms, 9-10
location of data conversion, 9-6
media recovery, 9-15
optimizing on multiple-CPU systems, 9-23
partitioned load
SQL*Loader, 9-30
performance, 9-11, 9-17
preallocating storage, 9-17
presorting data, 9-18
recovery, 9-15
ROWS command-line parameter, 9-14
setting up, 9-10
specifying, 9-11
specifying number of rows to be read, 4-12
SQL*Loader data loading method, 3-12
table insert triggers, 9-27
temporary segment storage requirements, 9-12
triggers, 9-25
using, 9-9, 9-10
version requirements, 9-9
directory aliases
exporting, 1-57
importing, 2-59
discard files
DB2 load utility, B-3
SQL*Loader, 5-14
example, 10-15
specifying a maximum, 5-15
DISCARD parameter
for SQL*Loader command-line, 4-6
DISCARDDN parameter
in DB2 control file, B-3
discarded SQL*Loader records, 3-10
causes, 5-15
discard file, 5-14
limiting, 5-16
DISCARDMAX parameter
for SQL*Loader command-line, 4-6
DISCARDS parameter
in DB2 control file, B-3
discontinued loads, 5-24
continuing, 5-26
conventional path behavior, 5-24
direct path behavior, 5-24
DOUBLE datatype, 6-10
dropped snapshots
Import, 2-64
dump files
maximum size, 1-21

E

EBCDIC character set
Import, 2-55
eight-bit character set support, 1-54, 2-55
enclosed fields
specified with enclosure delimiters and SQL*Loader, 6-25
whitespace, 6-49
enclosure delimiters, 6-24
SQL*Loader, 6-25, 6-45
errors
caused by tab characters in SQL*Loader data, 6-4
export log file, 1-23
generated by DB2 load utility, B-3
Import, 2-45
Import resource errors, 2-49
LONG data, 2-48
nonrecoverable
Export, 1-49
Import, 2-46
object creation, 2-48
Import parameter IGNORE, 2-23
recoverable
Export, 1-48
Import, 2-46
row errors during import, 2-47
warning
Export, 1-48
Import, 2-46
ERRORS parameter
for SQL*Loader command line, 4-6
escape character
quoted strings, 5-6
usage in Export, 1-29
usage in Import, 2-30
EVALUATE_CHECK_CONSTRAINTS clause, 9-26
exit codes
Export, 1-49
Import, 2-47
SQL*Loader, 4-16
EXP_FULL_DATABASE role
assigning in Export, 1-4
expdat.dmp
Export output file, 1-20
Export
BUFFER parameter, 1-16
COMPRESS parameter, 1-17
CONSISTENT parameter, 1-18
CONSTRAINTS parameter, 1-20
conventional path, 1-50
conversion of character sets, 1-54
creating
necessary privileges, 1-4
necessary views, 1-4
creating version 7 export files, 1-62
database optimizer statistics, 1-27
DIRECT parameter, 1-20
direct path, 1-50
displaying online help, 1-23
eight-bit versus seven-bit character sets, 1-54
example sessions, 1-32
full database mode, 1-33
partition-level, 1-41
table mode, 1-38
user mode, 1-36
exit codes, 1-49
exporting an entire database, 1-23
exporting indexes, 1-23
exporting sequence numbers, 1-56
exporting synonyms, 1-58
exporting to another operating system, 1-26, 2-25
FEEDBACK parameter, 1-20
FILE parameter, 1-20
FILESIZE parameter, 1-21
FLASHBACK_SCN parameter, 1-22
FLASHBACK_TIME parameter, 1-22
full database mode
example, 1-33
FULL parameter, 1-23
GRANTS parameter, 1-23
HELP parameter, 1-23
INDEXES parameter, 1-23
interactive method, 1-43
invoking, 1-5
log files
specifying, 1-23
LOG parameter, 1-23
logging error messages, 1-23
LONG columns, 1-56
modes
objects exported by each, 1-8
network issues, 1-53
OBJECT_CONSISTENT parameter, 1-24
online help, 1-13
OWNER parameter, 1-24
parameter conflicts, 1-32
parameter file, 1-24
maximum size, 1-7
parameters, 1-13
PARFILE parameter, 1-24
partitioning a database migration, 1-60
QUERY parameter, 1-24
RECORDLENGTH parameter, 1-26
redirecting output to a log file, 1-48
remote operation, 1-53, 2-54
restrictions based on privileges, 1-5
RESUMABLE parameter, 1-26
RESUMABLE_NAME parameter, 1-26
RESUMABLE_TIMEOUT parameter, 1-27
ROWS parameter, 1-27
sequence numbers, 1-56
STATISTICS parameter, 1-27
storage requirements, 1-4
table mode
example session, 1-38
table name restrictions, 1-30
TABLES parameter, 1-28
TABLESPACES parameter, 1-30
transferring export files across a network, 1-53
TRANSPORT_TABLESPACE parameter, 1-31
TRIGGERS parameter, 1-31
TTS_FULL_CHECK parameter, 1-31
user access privileges, 1-4
user mode
example session, 1-36
specifying, 1-24
USERID parameter, 1-31
VOLSIZE parameter, 1-32
export file
importing the entire file, 2-22
listing contents before importing, 2-27
specifying, 1-20
Export messages
completion, 1-49
nonrecoverable, 1-49
warning, 1-48
exporting
from read-only databases, 1-60
EXPRESSION parameter
SQL*Loader, 6-56
extents
consolidating, 1-17
importing consolidated, 2-66
external files
exporting, 1-57
external LOBs (BFILEs), 7-22
EXTERNAL parameter
SQL*Loader, 6-20
EXTERNAL SQL*Loader datatypes, 6-19
DECIMAL, 6-19
FLOAT, 6-19
GRAPHIC, 6-19
numeric, 6-19
determining length, 6-28
ZONED, 6-19
external tables
access parameters, 12-1
big endian data, 12-7
datatypes, 12-24
date cache feature, 11-6
delimiters, 12-6
describing datatype of a field, 12-24
differences in load behavior from SQL*Loader, 11-7
field_definitions clause, 12-3, 12-15
fixed-length records, 12-4
identifying character sets, 12-7
identifying datatypes, 12-21
improving performance when using, 11-6
date cache feature, 11-6
little endian data, 12-7
record_format_info clause, 12-2, 12-3
restrictions, 11-3
setting a field to a default value, 12-31
setting a field to null, 12-31
skipping records when loading data, 12-10
specifying delimiters, 12-16
specifying load conditions, 12-8
trimming blanks, 12-19
using comments, 12-2
using constructor functions with, 11-5
using to load data, 11-5
variable-length records, 12-5

F

fatal errors
See nonrecoverable errors
features, new, xliii
FEEDBACK parameter
for Export utility, 1-20
for Import utility, 2-21
field conditions
specifying for SQL*Loader, 6-29
field length
SQL*Loader specifications, 6-45
field location
SQL*Loader, 6-3
fields
character data length and SQL*Loader, 6-28
comparing to literals with SQL*Loader, 6-32
delimited
determining length, 6-28
SQL*Loader, 6-24
enclosed and SQL*Loader, 6-25
loading all blanks, 6-41
predetermined size
length, 6-28
SQL*Loader, 6-45
relative positioning and SQL*Loader, 6-46
specified with a termination delimiter and SQL*Loader, 6-25
specified with enclosure delimiters and SQL*Loader, 6-25
specifying default delimiters for SQL*Loader, 5-36
specifying for SQL*Loader, 6-5
SQL*Loader delimited
specifications, 6-45
terminated and SQL*Loader, 6-25
FIELDS clause
SQL*Loader, 5-36
terminated by whitespace, 6-48
FILE parameter
for Export utility, 1-20
for Import utility, 2-21
for SQL*Loader utility, 9-33
filenames
quotation marks, 5-6
specifying multiple SQL*Loader, 5-9
SQL*Loader, 5-5
SQL*Loader bad file, 5-11
FILESIZE parameter
for Export utility, 1-21
for Import utility, 2-21
FILLER field
example, 10-39
using as argument to init_spec, 6-6
fine-grained access support
Export, 1-59
Import, 2-56
fixed record length
example, 10-34
fixed-format records, 3-4
fixed-length records
external tables, 12-4
FLASHBACK_SCN parameter
for Export utility, 1-22
FLASHBACK_TIME parameter
for Export utility, 1-22
FLOAT datatype, 6-9
EXTERNAL format
SQL*Loader, 6-19
FLOAT EXTERNAL data values
SQL*Loader, 6-20
foreign function libraries
exporting, 1-56
importing, 2-60
FORMAT statement in DB2
not allowed by SQL*Loader, B-3
formats
SQL*Loader input records and, 5-40
formatting errors
SQL*Loader, 5-12
fragmentation
reducing, 2-53
FROMUSER parameter
for Import utility, 2-22
FTP
using to transport Export files, 1-53
full database mode
Export, 1-8
Import, 2-22
specifying with FULL, 1-23
FULL parameter
for Export utility, 1-23
for Import utility, 2-22

G

globalization
SQL*Loader, 5-16
grants
exporting, 1-23
importing, 2-7, 2-23
GRANTS parameter
for Export utility, 1-23
for Import utility, 2-22
GRAPHIC datatype
EXTERNAL format in SQL*Loader, 6-19

H

HELP parameter
for Export utility, 1-13, 1-23
for Import utility, 2-23
hexadecimal strings
SQL*Loader, 6-32

I

IGNORE parameter
for Import utility, 2-23
IMP_FULL_DATABASE role, 2-5
Import
BUFFER parameter, 2-18
catexp.sql script
preparing the database, 2-5
character set conversion, 2-55
character sets, 2-55
CHARSET parameter, 2-18
COMMIT parameter, 2-19
committing after array insert, 2-19
compatibility with other versions, 2-3
COMPILE parameter, 2-19
consolidated extents, 2-66
CONSTRAINTS parameter, 2-20
controlling size of rollback segments, 2-19
conversion of version 6 CHAR columns to VARCHAR2, 2-71
creating an index-creation SQL script, 2-24
database optimizer statistics, 2-28
DATAFILES parameter, 2-20
DESTROY parameter, 2-20
disabling referential constraints, 2-8
displaying online help, 2-23
dropping a tablespace, 2-67
errors importing database objects, 2-48
example sessions, 2-34
all tables from one user to another, 2-37
selected tables for specific user, 2-35
tables exported by another user, 2-36
using partition-level import, 2-38
exit codes, 2-47
export file
importing the entire file, 2-22
listing contents before import, 2-27
failed integrity constraints, 2-48
FEEDBACK parameter, 2-21
FILE parameter, 2-21
FILESIZE parameter, 2-21
FROMUSER parameter, 2-22
FULL parameter, 2-22
globalization considerations, 2-54
grants
specifying for import, 2-22
GRANTS parameter, 2-22
HELP parameter, 2-23
IGNORE parameter, 2-23
importing grants, 2-22
importing objects into other schemas, 2-7
importing rows, 2-27
importing tables, 2-29
INDEXES parameter, 2-24
INDEXFILE parameter, 2-24
INSERT errors, 2-48
interactive method, 2-44
invalid data, 2-48
invoking, 2-10
at the command line, 2-10
interactively, 2-10
with a parameter file, 2-11
length of Oracle version 6 export file DEFAULT columns, 2-71
LOG parameter, 2-25
LONG columns, 2-61
manually creating tables before import, 2-8
manually ordering tables, 2-9
message log file, 2-46
modes, 2-13
NLS_LANG environment variable, 2-55
object creation errors, 2-23
OPTIMAL storage parameter, 2-66
parameter file, 2-25
maximum size, 2-11
parameters, 2-14
PARFILE parameter, 2-25
partition-level, 2-49
pattern matching of table names, 2-29
preparing the database, 2-5
preserving size of initial extent, 2-66
read-only tablespaces, 2-66
RECORDLENGTH parameter, 2-25
records
specifying length, 2-25
redirecting output to a log file, 2-46
reducing database fragmentation, 2-53
refresh error, 2-63
reorganizing tablespace during, 2-67
resource errors, 2-49
restrictions
importing into own schema, 2-6
RESUMABLE parameter, 2-26
RESUMABLE_NAME parameter, 2-26
RESUMABLE_TIMEOUT parameter, 2-26
reusing existing datafiles, 2-20
rows
specifying for import, 2-27
ROWS parameter, 2-27
schema objects, 2-7
sequences, 2-49
SHOW parameter, 2-27
single-byte character sets, 2-55
SKIP_UNUSABLE_INDEXES parameter, 2-27
snapshot master table, 2-63
snapshots, 2-63
restoring dropped, 2-64
specifying by user, 2-22
specifying index creation commands, 2-24
specifying the export file, 2-21
STATISTICS parameter, 2-27
storage parameters
overriding, 2-66
stored functions, 2-60
stored packages, 2-60
stored procedures, 2-60
STREAMS_CONFIGURATION parameter, 2-28
STREAMS_INSTANTIATION parameter, 2-28
system objects, 2-7
table name restrictions, 2-31
table objects
import order, 2-3
table-level, 2-49
TABLES parameter, 2-29
TABLESPACES parameter, 2-31
TOID_NOVALIDATE parameter, 2-31
TOUSER parameter, 2-32
TRANSPORT_TABLESPACE parameter, 2-33
TTS_OWNER parameter, 2-33
types of errors during, 2-47
uniqueness constraints
preventing import errors, 2-19
user definitions, 2-71
USERID parameter, 2-33
using Oracle version 6 files, 2-71
VOLSIZE parameter, 2-34
warning messages, 2-46
index options
SORTED INDEXES with SQL*Loader, 5-38
SQL*Loader SINGLEROW parameter, 5-38
Index Unusable state
indexes left in Index Unusable state, 5-26, 9-12
indexes
creating manually, 2-24
direct path load
left in direct load state, 9-12
dropping
SQL*Loader, 9-24
estimating storage requirements, 9-12
exporting, 1-23
importing, 2-24
index-creation commands
Import, 2-24
left in unusable state, 5-26, 9-18
multiple-column
SQL*Loader, 9-19
presorting data
SQL*Loader, 9-18
skipping maintenance, 4-14, 9-24
skipping unusable, 2-27, 4-14, 9-24
SQL*Loader, 5-38
state after discontinued load, 5-26
unique, 2-24
INDEXES parameter
for Export utility, 1-23
for Import utility, 2-24
INDEXFILE parameter
for Import utility, 2-24
INFILE parameter
for SQL*Loader utility, 5-7
insert errors
Import, 2-48
specifying, 4-6
INSERT into table
SQL*Loader, 5-33
instance affinity
Export, 1-55
instance recovery, 9-15
INTEGER datatype, 6-8
EXTERNAL format, 6-19
integrity constraints
disabled during direct path load, 9-25
enabled during direct path load, 9-25
failed on Import, 2-48
load method, 9-10
interactive method
Export, 1-43
Import, 2-44
internal LOBs
loading, 7-19
interrupted loads, 5-24
interval datatypes, 6-16
INTO TABLE statement
effect on bind array size, 5-50
multiple statements with SQL*Loader, 5-39
SQL*Loader, 5-31
column names, 6-5
discards, 5-15
invalid data
Import, 2-48
invalid objects
warning messages during import, 2-46
invoking
Export, 1-5
as SYSDBA, 1-7
at the command line, 1-5
direct path, 1-52
interactively, 1-6
with a parameter file, 1-6
Import, 2-10
as SYSDBA, 2-12
at the command line, 2-10
interactively, 2-10
with a parameter file, 2-11

K

key values
generating with SQL*Loader, 6-57

L

leading whitespace
definition, 6-44
trimming and SQL*Loader, 6-47
length indicator
determining size, 5-47
length subfield
VARCHAR DATA
SQL*Loader, 6-13
length-value datatypes, 6-7
length-value pair specified LOBs, 7-27
libraries
foreign function
exporting, 1-56
importing, 2-60
little endian data
external tables, 12-7
LOAD parameter
for SQL*Loader command line, 4-9
loading
collections, 7-29
column objects, 7-1
in variable record format, 7-3
with a derived subtype, 7-4
with user-defined constructors, 7-8
combined physical records, 10-14
datafiles containing tabs
SQL*Loader, 6-4
delimited, free-format files, 10-11
external table data
skipping records, 12-10
specifying conditions, 12-7, 12-12
fixed-length data, 10-8
LOBs, 7-18
negative numbers, 10-15
nested column objects, 7-4
object tables, 7-12
object tables with a subtype, 7-13
REF columns, 7-15
subpartitioned tables, 9-6
tables, 9-6
variable-length data, 10-5
XML columns, 7-18
LOB data, 3-9
compression during export, 1-18
Export, 1-56
in delimited fields, 7-20
in length-value pair fields, 7-21
in predetermined size fields, 7-19
LOB read buffer
size of, 4-11
LOBFILEs, 3-9, 7-18, 7-23
example, 10-38
LOBs
loading, 7-18
log files
after a discontinued load, 5-26
example, 10-26, 10-32
Export, 1-23, 1-48
Import, 2-25, 2-46
specifying for SQL*Loader, 4-9
SQL*Loader, 3-11
SQL*Loader datafile information, 8-4
SQL*Loader global information, 8-2
SQL*Loader header Information, 8-1
SQL*Loader summary statistics, 8-5
SQL*Loader table information, 8-2
SQL*Loader table load information, 8-5
LOG parameter
for Export utility, 1-23
for Import utility, 2-25
for SQL*Loader command line, 4-9
logical records
consolidating multiple physical records using SQL*Loader, 5-27
LONG data
C language datatype LONG FLOAT, 6-10
exporting, 1-56
importing, 2-61
LONG VARRAW datatype, 6-14

M

master tables
snapshots
Import, 2-63
materialized views, 2-63
media recovery
direct path load, 9-15
messages
Export
completion, 1-49
nonrecoverable, 1-49
warning, 1-48
Import
completion, 2-46
nonrecoverable, 2-46
warning, 2-46
Metadata API, 15-2
browsing interface, 15-10
enhancing performance, 15-9
implementation, 15-4
programmatic interface, 15-4
programming example, 15-11
missing data columns
SQL*Loader, 5-37
multibyte character sets
blanks with SQL*Loader, 6-32
SQL*Loader, 5-17
multiple-column indexes
SQL*Loader, 9-19
multiple-CPU systems
optimizing direct path loads, 9-23
multiple-table load
generating unique sequence numbers using SQL*Loader, 6-58
SQL*Loader control file specification, 5-39
multithreading
on multiple-CPU systems, 9-23
MULTITHREADING parameter
for SQL*Loader command line, 4-9

N

native datatypes
conflicting length specifications
SQL*Loader, 6-21
negative numbers
loading, 10-15
nested column objects
loading, 7-4
nested tables
exporting, 1-58
consistency and, 1-18
importing, 2-58
networks
Import and, 2-54
transporting export files across, 1-53
new features, xliii
NLS_LANG environment variable, 2-55
Export, 1-54
Import, 2-55
NOLOG attribute, 9-21
nonrecoverable errors
Export, 1-49
Import, 2-46
nonscalar datatypes, 7-6
normalizing data during a load
SQL*Loader, 10-19
NOT NULL constraint
load method, 9-10
null data
missing columns at end of record during load, 5-37
unspecified columns and SQL*Loader, 6-5
NULL values
objects, 7-6
NULLIF clause
SQL*Loader, 6-29, 6-41
NULLIF...BLANKS clause
example, 10-25
SQL*Loader, 6-31
nulls
atomic, 7-7
attribute, 7-6
NUMBER datatype
SQL*Loader, 6-23
numeric EXTERNAL datatypes
delimited form and SQL*Loader, 6-24
determining length, 6-28
SQL*Loader, 6-19

O

object identifiers, 7-12
importing, 2-56
object names
SQL*Loader, 5-5
object support, 3-15
object tables
loading, 7-12
with a subtype
loading, 7-13
object type definitions
exporting, 1-57
OBJECT_CONSISTENT parameter
for Export utility, 1-24
objects, 3-13
considerations for importing, 2-56
creation errors, 2-48
ignoring existing objects during import, 2-23
import creation errors, 2-23
loading nested column objects, 7-4
NULL values, 7-6
stream record format, 7-2
variable record format, 7-3
offline bitmapped tablespaces
exporting, 1-56
OID. See object identifiers
online help
Export, 1-13
Import, 2-14
operating systems
moving data to different systems using SQL*Loader, 6-36
OPTIMAL storage parameter
for Import utility, 2-66
optimizer statistics, 2-68
optimizing
direct path loads, 9-17
SQL*Loader input file processing, 5-11
OPTIONALLY ENCLOSED BY clause
SQL*Loader, 6-46
OPTIONS parameter
for parallel loads, 5-34
for SQL*Loader utility, 5-4
Oracle Advanced Queuing. See Advanced Queuing
Oracle Net
using to export over a network, 1-53
Oracle version 6
exporting database objects, 2-71
OWNER parameter
for Export utility, 1-24

P

padding of literal strings
SQL*Loader, 6-32
parallel loads, 9-30
restrictions on direct path, 9-32
PARALLEL parameter, 9-32
for SQL*Loader command line, 4-10
parameter files
Export, 1-24
comments in, 1-7
maximum size, 1-7
Import, 2-25
comments in, 2-12
maximum size, 2-11
SQL*Loader, 4-10
PARFILE parameter
for Export command line, 1-24
for Import command line, 2-25
for SQL*Loader command line, 4-10
PART statement in DB2
not allowed by SQL*Loader, B-3
partitioned loads
concurrent conventional path loads, 9-30
SQL*Loader, 9-30
partitioned tables
example, 10-34
export consistency and, 1-18
exporting, 1-12
importing, 2-35, 2-50
in DB2
no Oracle equivalent, B-3
loading, 9-6
partitioning a database migration, 1-60
advantages of, 1-60, 2-69
disadvantages of, 1-60, 2-69
procedure during export, 1-61
procedure during import, 2-69
partition-level Export, 1-12
example session, 1-41
partition-level Import, 2-49
specifying, 1-28
pattern matching
table names during import, 2-29
performance
Import, 2-19
improving when using integrity constraints, 9-30
issues when using external tables, 11-6
optimizing for direct path loads, 9-17
optimizing reading of SQL*Loader data files, 5-11
PIECED parameter
SQL*Loader, 9-16
POSITION parameter
using with data containing tabs, 6-4
with multiple SQL*Loader INTO TABLE clauses, 5-41, 6-3, 6-4
predetermined size fields
SQL*Loader, 6-45
predetermined size LOBs, 7-25
prerequisites
SQL*Loader, 9-2
PRESERVE BLANKS option
SQL*Loader, 6-49
PRESERVE parameter, 5-29
preserving
whitespace, 6-49
presorting
data for a direct path load
example, 10-25
PRIMARY KEY constraints
effect on direct path load, 9-35
primary key OIDs
example, 7-12, 10-43
primary key REF columns, 7-16
privileges
EXEMPT ACCESS POLICY
effect on direct path export, 1-52
required for Export, 1-4
required for Import, 2-5
required for SQL*Loader, 9-2

Q

QUERY parameter
for Export utility, 1-24
restrictions, 1-25
quotation marks
escaping, 5-6
filenames, 5-6
SQL string, 5-5
table names and, 1-29, 2-31
use with database object names, 5-5

R

RAW datatype
SQL*Loader, 6-20
read-consistent export, 1-18
read-only databases
exporting from, 1-60
read-only tablespaces
Import, 2-66
READSIZE parameter
for SQL*Loader command line, 4-10
effect on LOBs, 4-11
maximum size, 4-11
real REF columns, 7-15
RECNUM parameter
use with SQL*Loader SKIP parameter, 6-56
RECORDLENGTH parameter
for Export utility, 1-26
for Import utility, 2-25
records
consolidating into a single logical record
SQL*Loader, 5-27
discarded by SQL*Loader, 3-10, 5-14
DISCARDMAX command-line parameter, 4-6
distinguishing different formats for SQL*Loader, 5-40
extracting multiple logical records using SQL*Loader, 5-39
fixed format, 3-4
missing data columns during load, 5-37
rejected by SQL*Loader, 3-10, 5-12
setting column to record number with SQL*Loader, 6-56
specifying how to load, 4-9
specifying length for export, 1-26
specifying length for import, 2-25
stream record format, 3-6
recoverable errors
flagged as warnings in Export, 1-48
flagged as warnings in Import, 2-46
recovery
direct path load
SQL*Loader, 9-15
replacing rows, 5-33
redo logs
direct path load, 9-15
instance and media recovery
SQL*Loader, 9-15
minimizing use during direct path loads, 9-20
saving space
direct path load, 9-20
REF columns, 7-15
loading, 7-15
primary key, 7-16
real, 7-15
REF data
importing, 2-59
REF fields
example, 10-43
referential integrity constraints
disabling for import, 2-8
SQL*Loader, 9-25
refresh error
snapshots
Import, 2-63
reject files
specifying for SQL*Loader, 5-11
rejected records
SQL*Loader, 3-10, 5-12
relative field positioning
where a field starts and SQL*Loader, 6-46
with multiple SQL*Loader INTO TABLE clauses, 5-40
remote operation
Export/Import, 1-53, 2-54
REPLACE table
example, 10-15
replacing a table using SQL*Loader, 5-33
resource errors
Import, 2-49
RESOURCE role, 2-6
restrictions
DB2 load utility, B-3
importing into another user's schema, 2-7
table names in Export parameter file, 1-30
table names in Import parameter file, 2-31
RESUMABLE parameter
for Export utility, 1-26
for Import utility, 2-26
for SQL*Loader utility, 4-11
resumable space allocation
enabling and disabling, 1-26, 2-26, 4-11
RESUMABLE_NAME parameter
for Export utility, 1-26
for Import utility, 2-26
for SQL*Loader utility, 4-12
RESUMABLE_TIMEOUT parameter
for Export utility, 1-27
for Import utility, 2-26
for SQL*Loader utility, 4-12
RESUME parameter
for DB2, 5-33, B-1
roles
EXP_FULL_DATABASE, 1-5
IMP_FULL_DATABASE, 2-5
RESOURCE, 2-6
rollback segments
controlling size during import, 2-19
effects of CONSISTENT Export parameter, 1-18
row errors
Import, 2-48
rows
choosing which to load using SQL*Loader, 5-35
exporting, 1-27
specifying for import, 2-27
specifying number to insert before save
SQL*Loader, 9-14
updates to existing rows with SQL*Loader, 5-34
ROWS parameter
for Export utility, 1-27
for Import utility, 2-27
for SQL*Loader command line, 4-12
performance issues
SQL*Loader, 9-20
using to specify when data saves occur, 9-14

S

schemas
specifying for Export, 1-28
scientific notation for FLOAT EXTERNAL, 6-20
script files
running before Export, 1-3
running before Import, 2-5
SDFs. See secondary datafiles
secondary datafiles, 3-9, 7-31
security considerations
direct path export, 1-52
segments
temporary
FILE parameter in SQL*Loader, 9-33
sequence numbers
cached, 1-56
exporting, 1-56
for multiple tables and SQL*Loader, 6-58
generated by SQL*Loader SEQUENCE clause, 6-57, 10-11
generated, not read and SQL*Loader, 6-5
setting column to a unique number with SQL*Loader, 6-57
SEQUENCE parameter
SQL*Loader, 6-57
short records with missing data
SQL*Loader, 5-37
SHORTINT datatype
C language, 6-9
SHOW parameter
for Import utility, 2-27
SILENT parameter
for SQL*Loader command line, 4-12
single-byte character sets
Import, 2-55
SINGLEROW parameter, 5-38, 9-25
single-table loads
continuing, 5-26
SKIP parameter
effect on SQL*Loader RECNUM specification, 6-56
for SQL*Loader command line, 4-13
SKIP_INDEX_MAINTENANCE parameter
for SQL*Loader command line, 4-14, 9-24
SKIP_UNUSABLE_INDEXES parameter
for Import utility, 2-27
for SQL*Loader command line, 4-14, 9-24
skipping index maintenance, 4-14, 9-24
skipping unusable indexes, 4-14, 9-24
SMALLINT datatype, 6-9
snapshot log
Import, 2-63
snapshots, 2-64
importing, 2-63
master table
Import, 2-63
restoring dropped
Import, 2-64
SORTED INDEXES clause
direct path loads, 5-38
example, 10-25
SQL*Loader, 9-18
sorting
multiple-column indexes
SQL*Loader, 9-19
optimum sort order
SQL*Loader, 9-19
presorting in direct path load, 9-18
SORTED INDEXES clause
SQL*Loader, 9-18
SQL operators
applying to fields, 6-50
SQL strings
applying SQL operators to fields, 6-50
example, 10-28
quotation marks, 5-5
SQL*Loader
appending rows to tables, 5-33
BAD command-line parameter, 4-3
bad file, 4-3
BADDN parameter, 5-12
BADFILE parameter, 5-12
bind arrays and performance, 5-44
BINDSIZE command-line parameter, 4-4, 5-45
case studies, 10-2
direct path load, 10-24
extracting data from a formatted report, 10-28
loading combined physical records, 10-14
loading data in Unicode character set, 10-47
loading data into multiple tables, 10-18
loading delimited, free-format files, 10-11
loading fixed-length data, 10-8
loading LOBFILEs (CLOBs), 10-38
loading partitioned tables, 10-34
loading REF fields, 10-43
loading variable-length data, 10-5
loading VARRAYs, 10-43
choosing which rows to load, 5-35
COLUMNARRAYROWS command-line parameter, 4-4
command-line parameters, 4-1
CONCATENATE parameter, 5-27
CONTINUEIF parameter, 5-27
continuing single-table loads, 5-26
CONTROL command-line parameter, 4-4
conventional path loads, 9-4
DATA command-line parameter, 4-5
data conversion, 3-9
data definition language
syntax diagrams, A-1
datatype specifications, 3-9
DATE_CACHE command-line parameter, 4-5
DIRECT command-line parameter, 9-11
direct path method, 3-12
using date cache feature to improve performance, 9-22
DISCARD command-line parameter, 4-6
discarded records, 3-10
DISCARDFILE parameter, 5-14
DISCARDMAX command-line parameter, 4-6
DISCARDMAX parameter, 5-16
DISCARDS parameter, 5-16
errors caused by tabs, 6-4
ERRORS command-line parameter, 4-6
example sessions, 10-2
exclusive access, 9-30
FILE command-line parameter, 4-9
filenames, 5-5
globalization technology, 5-16
index options, 5-38
inserting rows into tables, 5-33
INTO TABLE statement, 5-31
LOAD command-line parameter, 4-9
load methods, 9-1
loading column objects, 7-1
loading data across different platforms, 6-36
loading data contained in the control file, 6-55
loading object tables, 7-12
LOG command-line parameter, 4-9
log file datafile information, 8-4
log file entries, 8-1
log file global information, 8-2
log file header information, 8-1
log file summary statistics, 8-5
log file table information, 8-2
log file table load information, 8-5
log files, 3-11
methods of loading data, 3-11
multiple INTO TABLE statements, 5-39
MULTITHREADING command-line parameter, 4-9
object names, 5-5
parallel data loading, 9-30, 9-31, 9-35
PARFILE command-line parameter, 4-10
READSIZE command-line parameter, 4-10
maximum size, 4-11
rejected records, 3-10
replacing rows in tables, 5-33
required privileges, 9-2
RESUMABLE parameter, 4-11
RESUMABLE_NAME parameter, 4-12
RESUMABLE_TIMEOUT parameter, 4-12
ROWS command-line parameter, 4-12
SILENT command-line parameter, 4-12
SINGLEROW parameter, 5-38
SKIP_INDEX_MAINTENANCE command-line parameter, 4-14
SKIP_UNUSABLE_INDEXES command-line parameter, 4-14
SORTED INDEXES during direct path loads, 5-38
specifying columns, 6-5
specifying datafiles, 5-7
specifying field conditions, 6-29
specifying fields, 6-5
specifying more than one datafile, 5-9
STREAMSIZE command-line parameter, 4-15
suppressing messages, 4-12
updating rows, 5-34
USERID command-line parameter, 4-15
SQL/DS option (DB2 file format)
not supported by SQL*Loader, B-4
statistics
analyzer, 2-68
database optimizer
specifying for Export, 1-27
optimizer, 2-68
specifying for Import, 2-28
STATISTICS parameter
for Export utility, 1-27
for Import utility, 2-27
STORAGE parameter, 9-34
storage parameters, 2-65
estimating export requirements, 1-4
OPTIMAL parameter, 2-66
overriding
Import, 2-66
preallocating
direct path load, 9-17
temporary for a direct path load, 9-12
stored functions
importing, 2-60
effect of COMPILE parameter, 2-60
stored packages
importing, 2-60
effect of COMPILE parameter, 2-60
stored procedures
direct path load, 9-29
importing, 2-60
effect of COMPILE parameter, 2-60
stream buffer
specifying size for direct path, 9-21
stream record format, 3-6
loading column objects in, 7-2
STREAMS_CONFIGURATION parameter
for Import utility, 2-28
STREAMS_INSTANTIATION parameter
for Import utility, 2-28
STREAMSIZE parameter
for SQL*Loader command line, 4-15
string comparisons
SQL*Loader, 6-32
subpartitioned tables
loading, 9-6
synonyms
direct path load, 9-10
exporting, 1-58
syntax diagrams
SQL*Loader, A-1
symbols used in BNF variant, C-1
SYSDATE datatype
example, 10-28
SYSDATE parameter
SQL*Loader, 6-56
system objects
importing, 2-7
system triggers
effect on import, 2-9
testing, 2-9

T

table mode export, 1-8
table names
preserving case sensitivity, 1-29
table-level Export, 1-12
table-level Import, 2-49
table-mode Export
specifying, 1-28
table-mode Import
examples, 2-35
tables
Advanced Queuing
exporting, 1-58
importing, 2-61
appending rows with SQL*Loader, 5-33
defining before Import, 2-8
definitions
creating before Import, 2-8
exclusive access during direct path loads
SQL*Loader, 9-30
external, 11-1
importing, 2-29
insert triggers
direct path load in SQL*Loader, 9-27
inserting rows using SQL*Loader, 5-33
loading data into more than one table using SQL*Loader, 5-39
loading object tables, 7-12
maintaining consistency during Export, 1-18
manually ordering for Import, 2-9
master table
Import, 2-63
name restrictions
Export, 1-30
Import, 2-29, 2-31
nested
exporting, 1-58
importing, 2-58
objects
order of import, 2-3
partitioned, 1-12
partitioned in DB2
no Oracle equivalent, B-3
replacing rows using SQL*Loader, 5-33
specifying for export, 1-28
specifying table-mode Export, 1-28
SQL*Loader method for individual tables, 5-32
truncating
SQL*Loader, 5-34
updating existing rows using SQL*Loader, 5-34
See also external tables
TABLES parameter
for Export utility, 1-28
for Import utility, 2-29
tablespace mode export, 1-8
tablespaces
dropping during import, 2-67
exporting a set of, 1-59
metadata
transporting, 2-33
moving from one database to another, 2-64
read-only
Import, 2-66
reorganizing
Import, 2-67
TABLESPACES parameter
for Export utility, 1-30
for Import utility, 2-31
tabs
loading datafiles containing tabs, 6-4
trimming, 6-42
whitespace, 6-42
temporary segments, 9-33
FILE parameter
SQL*Loader, 9-33
temporary storage in a direct path load, 9-12
TERMINATED BY
SQL*Loader, 6-25
WHITESPACE
SQL*Loader, 6-25
TERMINATED BY clause
with OPTIONALLY ENCLOSED BY, 6-46
terminated fields
specified with a delimiter, 6-46
specified with delimiters and SQL*Loader, 6-25
time
SQL*Loader datatypes for, 6-16
TOID_NOVALIDATE parameter
for Import utility, 2-31
TOUSER parameter
for Import utility, 2-32
trailing blanks
loading with delimiters, 6-27
TRAILING NULLCOLS parameter
example, 10-28
for SQL*Loader utility, 5-3, 5-37
trailing whitespace
trimming, 6-49
TRANSPORT_TABLESPACE parameter
for Export utility, 1-31
for Import utility, 2-33
transportable tablespaces, 1-59, 2-64
triggers
database insert, 9-27
permanently disabled, 9-30
replacing with integrity constraints, 9-27
schema and database
effect on Import, 2-9
system
testing, 2-9
update
SQL*Loader, 9-28
TRIGGERS parameter
for Export utility, 1-31
trimming
summary, 6-43
trailing whitespace
SQL*Loader, 6-49
TTS_FULL_CHECK parameter
for Export utility, 1-31
TTS_OWNERS parameter
for Import utility, 2-33

U

UNIQUE KEY constraints
effect on direct path load, 9-35
unique values
generating with SQL*Loader, 6-57
uniqueness constraints
preventing errors during import, 2-19
UNLOAD statement (DB2 file format)
not supported by SQL*Loader, B-3
UNRECOVERABLE parameter
SQL*Loader, 9-20
unsorted data
direct path load
SQL*Loader, 9-18
updating
rows in a table
SQL*Loader, 5-34
user definitions
importing, 2-71
user mode export, 1-8
specifying, 1-24
USER_SEGMENTS view
Export and, 1-4
user-defined constructors, 7-8
loading column objects with, 7-8
USERID parameter
for Export utility, 1-31
for Import utility, 2-33
for SQL*Loader command line, 4-15

V

value datatypes, 6-7
VARCHAR datatype
SQL*Loader, 6-13
VARCHAR2 datatype, 2-71
SQL*Loader, 6-23
VARCHARC datatype
SQL*Loader, 6-20
VARGRAPHIC datatype
SQL*Loader, 6-12
variable records, 3-5
format, 7-3
variable-length records
external tables, 12-5
VARRAW datatype, 6-14
VARRAWC datatype, 6-21
VARRAY columns
memory issues when loading, 7-34
VOLSIZE parameter
for Export utility, 1-32
for Import utility, 2-34

W

WHEN clause
example, 10-19
SQL*Loader, 5-35, 6-29
SQL*Loader discards resulting from, 5-15
whitespace
included in a field, 6-47
leading, 6-44
preserving, 6-49
terminating a field, 6-24, 6-47
trimming, 6-42
WHITESPACE parameter
SQL*Loader, 6-25

X

XML columns
loading, 7-18
treatment by SQL*Loader, 7-18

Z

ZONED datatype, 6-10
EXTERNAL format
SQL*Loader, 6-19

Go to previous page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback