Oracle8 Utilities
Release 8.0
A58244-01
Library
Product
Contents
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
Y
Z
A
access privileges
Export, 1-3
Import, 2-12
advanced queue (AQ) tables
exporting, 1-49
importing, 2-61
aliases
directory
exporting, 1-47
importing, 2-60
ANALYZE
Import parameter, 2-19
APPEND keyword
SQL*Loader, 5-37
APPEND to table
example, 4-11
SQL*Loader, 5-26
AQ (advanced queue) tables
exporting, 1-49
importing, 2-61
arrays
committing after insert
Import, 2-20
exporting, 1-47
importing, 2-59
ASCII
fixed-format files
exporting, 1-3
ASCII character set
Import, 2-55
B
backslash (\)
escape character in quoted strings
SQL*Loader, 5-13
quoted filenames and
SQL*Loader, 5-14
backups
restoring dropped snapshots
Import, 2-51
BAD
SQL*Loader command-line parameter, 6-3
bad file
rejected records
SQL*Loader, 3-13
specifying
bad records, 6-3
SQL*Loader, 5-19
BADDN keyword
SQL*Loader, 5-19
BADFILE keyword
SQL*Loader, 5-19
base backup
Export, 1-37
base tables
incremental export and, 1-41
BEGINDATA
control file keyword
SQL*Loader, 5-15
BFILE columns
exporting, 1-47
bind array
determining size
SQL*Loader, 5-65
determining size of
SQL*Loader, 5-67
minimizing memory requirements
SQL*Loader, 5-70
minimum requirements
SQL*Loader, 5-65
no space required for generated data
SQL*Loader, 5-71
performance implications
SQL*Loader, 5-66
size with multiple INTO TABLE clauses
SQL*Loader, 5-70
specifying number of rows
conventional path load
SQL*Loader, 6-6
specifying size
SQL*Loader, 6-3
BINDSIZE
SQL*Loader command-line parameter, 6-3
BINDSIZE command-line parameter
SQL*Loader, 5-66
blanks
BLANKS keyword for field comparison
SQL*Loader, 5-7,
5-38
loading fields consisting of blanks
SQL*Loader, 5-72
preserving
SQL*Loader, 5-78
trailing
loading with delimiters
SQL*Loader, 5-63
trimming
SQL*Loader, 5-72
whitespace
SQL*Loader, 5-72
BLANKS keyword
SQL*Loader, 5-38
BUFFER
Export parameter, 1-13
direct path export, 1-34,
1-36
Import parameter, 2-19
buffers
calculating for export, 1-13
calculating for import, 2-19
space required by
LONG DATA
SQL*Loader, 5-58
VARCHAR data
SQL*Loader, 5-56
specifying with BINDSIZE parameter
SQL*Loader, 5-67
BYTEINT datatype, 5-51
specification
SQL*Loader, 5-8
SQL*Loader, 5-52
C
cached sequence numbers
Export, 1-46
case studies
SQL*Loader, 4-1
associated files, 4-3
file names, 4-3
preparing tables, 4-4
CATALOG.SQL
preparing database for Export, 1-6
preparing database for Import, 2-7
CATEXP7.SQL
preparing database for Export, 1-50
CATEXP.SQL
preparing database for Export, 1-6
preparing database for Import, 2-7
CATLDR.SQL
setup script
SQL*Loader, 8-9
CHAR columns
Version 6 export files, 2-63
CHAR datatype
delimited form
SQL*Loader, 5-60
reference
SQL*Loader, 5-58
specification
SQL*Loader, 5-9
trimming whitespace
SQL*Loader, 5-73
character datatypes
conflicting fields
SQL*Loader, 5-63
character fields
datatypes
SQL*Loader, 5-58
delimiters
SQL*Loader, 5-60
determining length
SQL*Loader, 5-63
specified with delimiters
SQL*Loader, 5-58
character sets
conversion between
during Export/Import, 1-45,
2-55
SQL*Loader, 5-24
direct path export, 1-36,
1-45
eight-bit to seven-bit conversions
Export/Import, 1-46,
2-56
multi-byte
Export/Import, 1-46,
2-56
SQL*Loader, 5-24
NCHAR data
Export, 1-45
single-byte
Export/Import, 1-46,
2-55
Version 6 conversions
Import/Export, 2-56
character strings
as part of a field comparison
SQL*LOader, 5-7
padded
when shorter than field
SQL*Loader, 5-39
CHARACTERSET keyword
SQL*Loader, 5-24
CHARSET
Import parameter, 2-20
check constraints
Import, 2-48
clusters
Export, 1-42
columns
exporting LONG datatypes, 1-47
naming
SQL*Loader, 5-40
null columns at the end of a record
SQL*Loader, 5-72
reordering before Import, 2-15
setting to a constant value
SQL*Loader, 5-46
setting to a unique sequence number
SQL*Loader, 5-48
setting to datafile record number
SQL*Loader, 5-47
setting to null
SQL*Loader, 5-71
setting to null value
SQL*Loader, 5-47
setting to the current date
SQL*Loader, 5-47
setting value to zero
SQL*Loader, 5-71
specifiying as PIECED
SQL*Loader, 8-14
specifying
SQL*Loader, 5-39
combining partitions, 2-31
command-line parameters
description
SQL*Loader, 6-2
Export, 1-11
Import, 2-16
specifying defaults
SQL*Loader, 5-11
Comments
in Export parameter file, 1-10
in Import parameter file, 2-11
in SQL*Loader control file, 4-12
COMMIT
Import parameter, 2-20
complete exports, 1-37,
1-39
restrictions, 1-37
specifying, 1-17
completion messages
Export, 1-33
COMPRESS
Export parameter, 1-13,
2-53
COMPUTE option
STATISTICS Export parameter, 1-19
CONCATENATE keyword
SQL*Loader, 5-29
concurrent conventional path loads, 8-24
connect string
Net8, 1-44
CONSISTENT
Export parameter, 1-14
nested table and, 1-14
partitioned table and, 1-14
consolidating extents
Export parameter COMPRESS, 1-13
CONSTANT keyword
no space used in bind array
SQL*Loader, 5-71
SQL*Loader, 5-40,
5-46
CONSTRAINTS
Export parameter, 1-15
constraints
automatic
SQL*Loader, 8-22
check
Import, 2-48
direct path load, 8-20
disabling during a direct load, 8-20
disabling referential constraints
Import, 2-15
enabling after a direct load, 8-20
enforced on a direct load, 8-20
failed
Import, 2-48
load method
SQL*Loader, 8-8
not null
Import, 2-48
preventing Import errors due to uniqueness constraints, 2-21
referential integrity
Import, 2-48
uniqueness
Import, 2-48
continuation fields
SQL*Loader, 3-9
CONTINUE_LOAD keyword
SQL*Loader, 5-29
CONTINUEIF keyword
example
SQL*Loader, 4-14
SQL*Loader, 5-29
continuing interrupted loads
SQL*Loader, 5-27
CONTROL
SQL*Loader command-line parameter, 6-4
control files
CONTROL
SQL*Loader command-line parameter, 6-4
creating
SQL*Loader, 3-3
data definition language syntax
SQL*Loader, 5-4
data definitions
basics
SQL*Loader, 3-3
definition
SQL*Loader, 3-3
editing
SQL*Loader, 3-3
field delimiters
SQL*Loader, 5-10
guidelines for creating
SQL*Loader, 3-4
location
SQL*Loader, 3-5
specifying data
SQL*Loader, 5-15
specifying discard file
SQL*Loader, 5-21
storing
SQL*Loader, 3-5
conventional path Export
compared to direct path Export, 1-33
conventional path loads
basics, 8-2
bind array
SQL*Loader, 5-66
compared to direct path loads, 8-7
using, 8-3
CREATE SESSION privilege
Export, 1-3
Import, 2-12
CREATE USER command
Import, 2-14
CTIME column
SYS.INCEXP table, 1-43
cumulative exports, 1-37,
1-38
recording, 1-18
restrictions, 1-37
specifying, 1-17
SYS.INCFIL table, 1-44
SYS.INCVID table, 1-44
D
DATA
SQL*Loader command-line parameter, 6-4
data
binary versus character format
SQL*Loader, 3-9
delimiter marks in data
SQL*Loader, 5-62
distinguishing different input formats
SQL*Loader, 5-43
enclosed
SQL*Loader, 3-10
exporting, 1-19
formatted data
SQL*Loader, 4-27
generating unique values
SQL*Loader, 5-48
including in control files
SQL*Loader, 5-15
loading in sections
SQL*Loader, 8-14
loading into more than one table
SQL*Loader, 5-43
loading LONG
SQL*Loader, 5-58
loading without files
SQL*Loader, 5-46
mapping to Oracle format
SQL*Loader, 3-3
maximum length of delimited data
SQL*Loader, 5-63
methods of loading into tables
SQL*Loader, 5-25
moving between operating systems
SQL*Loader, 5-65
saving in a direct path load, 8-12
saving rows
SQL*Loader, 8-18
terminated
SQL*Loader, 3-10
unsorted
SQL*Loader, 8-17
values optimized for performance
SQL*Loader, 5-46
data conversion
description
SQL*Loader, 3-10
data definition language
basics
SQL*Loader, 3-3
BEGINDATA keyword, 5-15
BLANKS keyword
SQL*Loader, 5-38
CHARACTERSET keyword, 5-24
column_name
SQL*Loader, 5-8
CONCATENATE keyword, 5-29
CONSTANT keyword, 5-40,
5-46
CONTINUEIF keyword, 5-29
datatype_spec
SQL*Loader, 5-9
date mask
SQL*Loader, 5-10
DEFAULTIF keyword
SQL*Loader, 5-71
delimiter_spec
SQL*Loader, 5-10
description
SQL*Loader, 3-5
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-21
DISCARDDN keyword, 5-21
DISCARDMAX keyword
SQL*Loader, 5-23
example definition
SQL*Loader, 3-5
EXCEPTIONS keyword
SQL*Loader, 8-21
EXTERNAL keyword, 5-60
field_condition
SQL*Loader, 5-7
FILE keyword
SQL*Loader, 8-27
FLOAT keyword, 5-60
INDDN keyword, 5-16
INFILE keyword, 5-16
length
SQL*Loader, 5-10
loading data in sections
SQL*Loader, 8-14
NULLIF keyword
SQL*Loader, 5-71
parallel keyword
SQL*Loader, 8-26
pos_spec
SQL*Loader, 5-7
POSITION keyword, 5-40
precision
SQL*Loader, 5-10
RECNUM keyword, 5-40
REENABLE keyword
SQL*Loader, 8-21
reference
keywords and parameters
SQL*Loader, 5-1
SEQUENCE keyword, 5-48
syntax diagrams
expanded
SQL*Loader, 5-7
high-level
SQL*Loader, 5-4
syntax reference
SQL*Loader, 5-1
SYSDATE keyword, 5-47
TERMINATED keyword, 5-61
UNRECOVERABLE keyword
SQL*Loader, 8-18
WHITESPACE keyword, 5-61
data definition language (DDL), 3-3
data field
specifying the datatype
SQL*Loader, 5-40
data mapping
concepts
SQL*Loader, 3-3
data path loads
direct and conventional, 8-2
data recovery
direct path load
SQL*Loader, 8-13
database administrator (DBA)
privileges for export, 1-3
database objects
export privileges, 1-3
exporting LONG columns, 1-47
transferring across a network
Import, 2-50
databases
data structure changes
incremental export and, 1-41
full export, 1-16
full import, 2-23
importing into secondary
Import, 2-21
incremental export, 1-37
preparing for Export, 1-6
preparing for Import, 2-7
privileges for exporting, 1-3
privileges for importing, 2-11
reducing fragmentation via full export/import, 2-47
reusing existing data files
Import, 2-21
datafiles
preventing overwrite during import, 2-21
reusing during import, 2-21
specifying
SQL*Loader, 5-16,
6-4
specifying buffering
SQL*Loader, 5-18
specifying format
SQL*Loader, 5-18
storage
SQL*Loader, 3-6
datatypes
BFILE
Export, 1-47
BYTEINT, 5-52
SQL*Loader, 5-8
CHAR, 5-58
Import, 2-63
SQL*Loader, 5-9
conflicting character datatype fields, 5-63
converting
SQL*Loader, 3-10,
5-50
DATE, 5-58
determining length, 5-64
SQL*Loader, 5-9
DECIMAL, 5-53
SQL*Loader, 5-9
default
SQL*Loader, 5-40
determining character field lengths
SQL*Loader, 5-63
DOUBLE, 5-52
SQL*Loader, 5-8
FLOAT, 5-52
SQL*Loader, 5-8
GRAPHIC, 5-54
SQL*Loader, 5-9
GRAPHIC EXTERNAL, 5-54
INTEGER, 5-51
SQL*Loader, 5-8
LONG
Export, 1-47
Import, 2-61
MLSLABEL
Trusted Oracle7 Server, 5-59
native
conflicting length specifications
SQL*Loader, 5-57
inter-operating system transfer issues, 5-65
SQL*Loader, 3-9,
5-51
NUMBER
SQL*Loader, 5-50
numeric EXTERNAL, 5-60
trimming
SQL*Loader, 5-73
RAW, 5-54
SQL*Loader, 5-9
SMALLINT, 5-51
SQL*Loader, 5-8
specifications
SQL*Loader, 5-8
specifying
SQL*Loader, 5-50
specifying the datatype of a data field
SQL*Loader, 5-40
VARCHAR, 5-56
SQL*Loader, 5-9
VARCHAR2
Import, 2-63
SQL*Loader, 5-50
VARGRAPHIC, 5-55
SQL*Loader, 5-9
ZONED, 5-52
SQL*Loader, 5-9
DATE datatype
delimited form
SQL*Loader, 5-60
determining length
SQL*Loader, 5-64
mask
SQL*Loader, 5-64
specification
SQL*Loader, 5-9
SQL*Loader, 5-58
trimming whitespace
SQL*Loader, 5-73
date mask
SQL*Loader, 5-10
DB2 Load utility
use with SQL*Loader, 3-4
DB2 load utility, B-1
different placement of statements
DISCARDDDN, B-4
DISCARDS, B-4
restricted capabilities of SQL*Loader, B-4
RESUME keyword
SQL*Loader equivalents, 5-26
SQL*Loader compatibility
ignored statements, B-3
DBA role
EXP_FULL_DATABASE role, 1-7
DBCS (DB2 double-byte character set)
not supported by Oracle, B-5
DDL, 3-5
SQL*Loader data definition language, 3-3
DECIMAL datatype
(packed), 5-51
EXTERNAL format
SQL*Loader, 5-60
trimming whitespace
SQL*Loader, 5-73
length and precision
SQL*Loader, 5-10
specification
SQL*Loader, 5-9
SQL*Loader, 5-53
DEFAULT column values
Oracle Version 6 export files, 2-63
DEFAULTIF keyword
field condition
SQL*Loader, 5-37
SQL*Loader, 5-71
DELETE ANY TABLE privilege
SQL*Loader, 5-27
DELETE CASCADE
SQL*Loader, 5-26,
5-27
DELETE privilege
SQL*Loader, 5-26
delimited data
maximum length
SQL*Loader, 5-63
delimited fields
field length
SQL*Loader, 5-64
delimited files
exporting, 1-3
delimiter_spec
SQL*Loader, 5-10
delimiters
and SQL*Loader, 3-10
control files
SQL*Loader, 5-10
enclosure
SQL*Loader, 5-74
field specifications
SQL*Loader, 5-74
initial and trailing
case study, 4-27
loading trailing blanks
SQL*Loader, 5-63
marks in data
SQL*Loader, 5-62
optional enclosure
SQL*Loader, 5-74
specifying
SQL*Loader, 5-35,
5-60
termination
SQL*Loader, 5-74
DESTROY
Import parameter, 2-21
DIRECT
Export parameter, 1-15,
1-34
SQL*Loader command-line parameter, 6-4
direct path export, 1-33
BUFFER parameter, 1-36
character set and, 1-45
invoking, 1-34
performance, 1-36
RECORDLENGTH parameter, 1-36
direct path load
,
8-10
advantages, 8-6
case study, 4-24
choosing sort order
SQL*Loader, 8-17
compared to convetional path load, 8-7
conditions for use, 8-7
data saves, 8-12,
8-18
DIRECT
SQL*Loader command-line parameter, 6-4
DIRECT command line parameter
SQL*Loader, 8-9
DISABLED_CONSTRAINTS keyword, 8-21
disabling media protection
SQL*Loader, 8-18
dropping indexes, 8-19
to continue an interrupted load
SQL*Loader, 5-28
EXCEPTIONS keyword, 8-21
field defaults, 8-8
improper sorting
SQL*Loader, 8-17
indexes, 8-9
instance recovery, 8-13
loading into synonyms, 8-9
LONG data, 8-14
media recovery, 8-13
partitioned load
SQL*Loader, 8-24
performance, 8-15
performance issues, 8-9
preallocating storage, 8-15
presorting data, 8-16
recovery, 8-13
REENABLE keyword, 8-21
referential integrity constraints, 8-20
ROWS command line parameter, 8-12
setting up, 8-9
specifying, 8-9
specifying number of rows to be read
SQL*Loader, 6-6
SQL*Loader data loading method, 3-16
table insert triggers, 8-21
temporary segment storage requirements, 8-10
triggers, 8-20
using, 8-7,
8-9
version requirements, 8-9
directory aliases
exporting, 1-47
importing, 2-60
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-21
DISCARD
SQL*Loader command-line parameter, 6-4
discard file
basics
SQL*Loader, 3-15
DISCARDDN keyword
different placement from DB2, B-4
SQL*Loader, 5-21
DISCARDFILE keyword
example, 4-14
DISCARDMAX keyword
example, 4-14
SQL*Loader, 5-23
DISCARDS control file clause
different placement from DB2, B-4
DISCARDS keyword
SQL*Loader, 5-23
DISCRDMAX keyword
SQL*Loader, 5-23
SQL*Loader, 5-21
discarded records
causes
SQL*Loader, 5-23
discard file
SQL*Loader, 5-21
limiting the number
SQL*Loader, 5-23
SQL*Loader, 3-13
DISCARDMAX
SQL*Loader command-line parameter, 6-5
DISCARDMAX keyword
discarded records
SQL*Loader, 5-23
discontinued loads
continuing
SQL*Loader, 5-27
DOUBLE datatype, 5-51
specification
SQL*Loader, 5-8
SQL*Loader, 5-52
dropped snapshots
Import, 2-51
dropping
indexes
to continue a direct path load
SQL*LOader, 5-28
E
EBCDIC character set
Import, 2-55
eight-bit character set support, 1-46,
2-56
enclosed fields
and SQL*Loader, 3-10
ENCLOSED BY control file clause
SQL*Loader, 5-10
specified with enclosure delimiters
SQL*Loader, 5-61
whitespace in
SQL*Loader, 5-77
enclosure delimiters
and SQL*Loader, 3-10
SQL*Loader, 5-74
error handling
Export, 1-32
Import, 2-48
error messages
caused by tab characters in data
SQL*Loader, 5-42
Export, 1-32
export log file, 1-17
fatal errors
Export, 1-33
generated by DB2 load utility, B-4
row errors during import, 2-48
warning errors
Export, 1-32
ERRORS
SQL*Loader command-line parameter, 6-5
errors
fatal
Export, 1-33
Import, 2-49
Import resource errors, 2-49
LONG data, 2-48
object creation
Import parameter IGNORE, 2-23
object creation errors, 2-49
warning
Export, 1-32
escape character
Export, 1-20
Import, 2-28
quoted strings
SQL*Loader, 5-13
ESTIMATE option
STATISTICS Export parameter, 1-19
EXCEPTIONS keyword
SQL*Loader, 8-21
EXP_FULL_DATABASE role, 1-16
assigning, 1-7
Export, 1-3
Import, 2-12
EXPDAT.DMP
Export output file, 1-16
EXPID column
SYS.INCEXP table, 1-43
Export
base backup, 1-37
BUFFER parameter, 1-13
CATALOG.SQL
preparing database for Export, 1-6
CATEXP7.SQL
preparing the database for Version 7 export, 1-50
CATEXP.SQL
preparing database for Export, 1-6
command line, 1-7
complete, 1-17,
1-37,
1-39
privileges, 1-37
restrictions, 1-37
COMPRESS parameter, 1-13
CONSISTENT parameter, 1-14
CONSTRAINTS parameter, 1-15
creating necessary privileges, 1-7
creating Version 7 export files, 1-49
cumulative, 1-17,
1-37,
1-38
privileges required, 1-37
restrictions, 1-37
data structures, 1-41
database optimizer statistics, 1-19
DIRECT parameter, 1-15
direct path, 1-33
displaying help message, 1-17
eight-bit vs. seven-bit character sets, 1-46
establishing export views, 1-6
examples, 1-22
full database mode, 1-22
partition-level, 1-27
table mode, 1-25
user mode, 1-24
exporting an entire database, 1-16
exporting indexes, 1-17
exporting sequence numbers, 1-46
exporting to another operating system
RECORDLENGTH parameter, 1-18,
2-26
FEEDBACK parameter, 1-16
FILE parameter, 1-16
full database mode
example, 1-22
FULL parameter, 1-16
GRANTS parameter, 1-16
HELP parameter, 1-17
incremental, 1-17,
1-37
command syntax, 1-17
example, 1-42
privileges, 1-37
restrictions, 1-37
system tables, 1-43
INCTYPE parameter, 1-17
INDEXES parameter, 1-17
interactive method, 1-8,
1-29
invoking, 1-7
kinds of data exported, 1-41
last valid export
SYS.INCVID table, 1-44
log files
specifying, 1-17
LOG parameter, 1-17
logging error messages, 1-17
LONG columns, 1-47
message log file, 1-32
modes, 1-4
multi-byte character sets, 1-46
network issues, 1-44
NLS support, 1-46
NLS_LANG environment variable, 1-46
objects exported, 1-4
online help, 1-9
OWNER parameter, 1-17
parameter conflicts, 1-21
parameter file, 1-7,
1-10,
1-17
maximum size, 1-10
parameters, 1-11
PARFILE parameter, 1-7,
1-10,
1-17
POINT_IN_TIME_RECOVER, 1-18
preparing database, 1-6
previous versions, 1-49
RECORD parameter, 1-18
RECORDLENGTH parameter, 1-18
RECOVERY_TABLESPACES parameter, 1-19
redirecting output to a log file, 1-32
remote operation, 1-44
restrictions, 1-3
rollback segments, 1-42
ROWS parameter, 1-19
sequence numbers, 1-46
STATISTICS parameter, 1-19
storage requirements, 1-7
SYS.INCEXP table, 1-43
SYS.INCFIL table, 1-44
SYS.INCVID table, 1-44
table mode
example, 1-25
table name restrictions, 1-20
TABLES parameter, 1-19
tracking exported objects, 1-43
transferring export files across a network, 1-44
user access privileges, 1-3
user mode
examples, 1-24
specifying, 1-17
USER_SEGMENTS view, 1-7
USERID parameter, 1-21
using, 1-6
warning messages, 1-32
export file
displaying contents, 1-3
importing the entire file, 2-23
listing contents before importing, 2-27
reading, 1-3
specifying, 1-16
extent allocation
FILE
SQL*Loader command line parameter, 6-5
extents
consolidating into one extent
Export, 1-13
importing consolidated, 2-53
EXTERNAL datatypes
DECIMAL
SQL*Loader, 5-60
FLOAT
SQL*Loader, 5-60
GRAPHIC
SQL*Loader, 5-54
INTEGER, 5-60
numeric
determining length
SQL*Loader, 5-63
SQL*Loader, 5-60
trimming
SQL*Loader, 5-73
SQL*Loader, 3-9
ZONED
SQL*Loader, 5-60
external files
exporting, 1-47
EXTERNAL keyword
SQL*Loader, 5-60
F
fatal errors
Export, 1-33
Import, 2-48,
2-49
FEEDBACK
Export parameter, 1-16
Import parameter, 2-22
field conditions
specifying
SQL*Loader, 5-37
field length
specifications
SQL*Loader, 5-73
fields
and SQL*Loader, 3-10
character
data length
SQL*Loader, 5-63
comparing
SQL*Loader, 5-7
comparing to literals
SQL*Loader, 5-39
continuation
SQL*Loader, 3-9
DECIMAL EXTERNAL
trimming whitespace
SQL*Loader, 5-73
delimited
determining length
SQL*Loader, 5-64
specifications
SQL*Loader, 5-74
SQL*Loader, 5-60
enclosed
SQL*Loader, 5-61
FLOAT EXTERNAL
trimming whitespace
SQL*Loader, 5-73
INTEGER EXTERNAL
trimming whitespace
SQL*Loader, 5-73
length of
SQL*Loader, 5-10
loading all blanks
SQL*Loader, 5-72
location
SQL*Loader, 5-40
numeric and precision versus length
SQL*Loader, 5-10
numeric EXTERNAL
trimming whitespace
SQL*Loader, 5-73
precision
SQL*Loader, 5-10
predetermined size
length
SQL*Loader, 5-64
SQL*Loader, 5-73
relative positioning
SQL*Loader, 5-74
specification of position
SQL*Loader, 5-7
specified with a termination delimiter
SQL*Loader, 5-61
specified with enclosure delimiters
SQL*Loader, 3-10,
5-61
specifying
SQL*Loader, 5-39
specifying default delimiters
SQL*Loader, 5-35
terminated
SQL*Loader, 5-61
VARCHAR
never trimmed
SQL*Loader, 5-73
ZONED EXTERNAL
trimming whitespace
SQL*Loader, 5-73
FIELDS clause
SQL*Loader, 5-35
terminated by whitespace
SQL*Loader, 5-76
FILE
Export parameter, 1-16
Import parameter, 2-22
keyword
SQL*Loader, 8-27
SQL*Loader command-line parameter, 6-5
FILE columns
Import, 2-60
filenames
bad file
SQL*Loader, 5-19
quotation marks
SQL*Loader, 5-13
specifying more than one
SQL*Loader, 5-17
SQL*Loader, 5-12
files
file processing options string
SQL*Loader, 5-18
logfile
SQL*Loader, 3-15
SQL*Loader
bad file, 3-13
discard file, 3-15
storage
SQL*Loader, 3-6
fixed format records
SQL*Loader, 3-6
fixed-format records
vs. variable
SQL*Loader, 3-6,
3-7
FLOAT datatype, 5-51
EXTERNAL format
SQL*Loader, 5-60
trimming whitespace
SQL*Loader, 5-73
specification
SQL*Loader, 5-8
SQL*Loader, 5-52
FLOAT EXTERNAL data values
SQL*Loader, 5-60
FLOAT keyword
SQL*Loader, 5-60
foreign function libraries
exporting, 1-47
importing, 2-60
FORMAT statement in DB2
not allowed by SQL*Loader, B-5
formats
and input records
SQL*Loader, 5-44
formatting errors
SQL*Loader, 5-19
fragmentation
reducing database fragmentation via full export/import, 2-47
FROMUSER
Import parameter, 2-22
FTP
Export files, 1-44
FULL
Export parameter, 1-16
Import parameter, 2-23
full database mode
Import, 2-23
G
GRANTS
Export parameter, 1-16
Import parameter, 2-23
grants
exporting, 1-16
importing, 2-13,
2-23
GRAPHIC datatype, 5-51
EXTERNAL format
SQL*Loader, 5-54
specification
SQL*Loader, 5-9
SQL*Loader, 5-54
GRAPHIC EXTERNAL datatype, 5-51
H
HELP
Export parameter, 1-17
Import parameter, 2-23
help
Export, 1-9
Import, 2-10
hexadecimal strings
as part of a field comparison
SQL*Loader, 5-7
padded
when shorter than field
SQL*Loader, 5-39
I
IGNORE
Import parameter, 2-23
existing objects, 2-49
object identifiers and, 2-57
IMP_FULL_DATABASE role, 2-23
created by CATEXP.SQL, 2-7
Import, 2-12,
2-29
Import, 2-1
ANALYZE parameter, 2-19
backup files, 2-51
BUFFER parameter, 2-19
CATALOG.SQL
preparing the database, 2-7
CATEXP.SQL
preparing the database, 2-7
character set conversion, 1-45,
2-55
character sets, 2-55
CHARSET parameter, 2-20
COMMIT parameter, 2-20
committing after array insert, 2-20
compatibility, 2-5
complete export file, 2-43
consolidated extents, 2-53
controlling size of rollback segments, 2-21
conversion of Version 6 CHAR columns to VARCHAR2, 2-63
creating an index-creation SQL script, 2-25
cumulative, 2-43
data files
reusing, 2-21
database
reusing existing data files, 2-21
DESTROY parameter, 2-21
disabling referential constraints, 2-15
displaying online help, 2-23
dropping a tablespace, 2-54
error handling, 2-48
errors importing database objects, 2-48
example session, 2-33
export COMPRESS parameter, 2-53
export file
importing the entire file, 2-23
listing contents before import, 2-27
failed integrity constraints, 2-48
fatal errors, 2-48,
2-49
FEEDBACK parameter, 2-22
FILE parameter, 2-22
FROMUSER parameter, 2-22
full database mode
specifying, 2-23
FULL parameter, 2-23
grants
specifying for import, 2-23
GRANTS parameter, 2-23
HELP parameter, 2-10,
2-23
IGNORE parameter, 2-23,
2-49
IMP_FULL_DATABASE role, 2-12
importing grants, 2-13,
2-23
importing objects into other schemas, 2-14
importing rows, 2-27
importing tables, 2-27
incremental, 2-43
specifying, 2-24
INCTYPE parameter, 2-24
INDEXES parameter, 2-25
INDEXFILE parameter, 2-25
INSERT errors, 2-48
interactive method, 2-41
into a secondary database, 2-21
invalid data, 2-48
invoking, 2-7
length of Oracle Version 6 export file DEFAULT columns, 2-63
log files
LOG parameter, 2-26
LONG columns, 2-61
manually ordering tables, 2-15
modes, 2-5
NLS considerations, 2-55
NLS_LANG environment variable, 2-56
object creation errors, 2-23
objects imported, 1-4
OPTIMAL storage parameter, 2-52
Oracle Version 6 integrity constraints, 2-63
parameter file, 2-11,
2-26
parameters, 2-16
PARFILE parameter, 2-26
POINT_IN_TIME_RECOVER parameter, 2-26
preparing the database, 2-7
privileges required, 2-11,
2-12
read-only tablespaces, 2-53
recompiling stored procedures, 2-60
RECORDLENGTH parameter, 2-26
records
specifying length, 2-26
reducing database fragmentation, 2-47
refresh error, 2-51
reorganizing tablespace during, 2-54
resource errors, 2-49
restrictions, 2-53
rows
specifying for import, 2-27
ROWS parameter, 2-27
schema objects, 2-12,
2-14
schemas
specifying for import, 2-22
sequences, 2-49
SHOW parameter, 1-3,
2-27
single-byte character sets, 2-55
SKIP_UNUSABLE_INDEXES parameter, 2-27
snapshot log, 2-50
snapshot master table, 2-51
snapshots, 2-50
restoring dropped, 2-51
specifying by user, 2-22
specifying index creation commands, 2-25
specifying the export file, 2-22
SQL*Net
See
Net8
statistics on imported data, 2-62
storage parameters
overriding, 2-53
stored functions, 2-60
stored packages, 2-60
stored procedures, 2-60
system objects, 2-14,
2-23
table objects
import order, 2-4
tables created before import, 2-15
TABLES parameter, 2-27
tablespaces, 2-21
TOUSER parameter, 2-29
transferring files across networks, 2-50
Trusted Oracle and, 2-2
unique indexes, 2-24
uniqueness constraints
preventing import errors, 2-21
user definitions, 2-14
user mode
specifying, 2-29
USERID parameter, 2-29
using Oracle Version 6 files, 2-63
incremental export, 1-37
backing up data, 1-42
command syntax, 1-17
data selected, 1-41
recording, 1-18
restrictions, 1-37
session example, 1-42
specifying, 1-17
SYS.INCFIL table, 1-44
SYS.INCVID table, 1-44
incremental import
parameter, 2-24
specifying, 2-24
INCTYPE
Export parameter, 1-17
Import parameter, 2-24
INDDN keyword
SQL*Loader, 5-16
index options
SINGLEROW keyword
SQL*Loader, 5-37
SORTED INDEXES
SQL*Loader, 5-36
Index Unusable state
indexes left in Index Unusable state, 8-11
INDEXES
Export parameter, 1-17
Import parameter, 2-25
indexes
creating manually, 2-25
direct path load
left in direct load state, 8-11
dropping
before continuing a direct path load
SQL*Loader, 5-28
SQL*Loader, 8-19
exporting, 1-17
importing, 2-25
index-creation commands
Import, 2-25
left direct load state
SQL*Loader, 8-17
multiple column
SQL*Loader, 8-17
presorting data
case study, 4-24
SQL*Loader, 8-16
skipping unusable, 2-27
SQL*Loader, 5-36
state after discontinued load
SQL*Loader, 5-27
unique, 2-24
INDEXFILE
Import parameter, 2-25
INFILE keyword
SQL*Loader, 5-16
INIT.ORA file
Export, 1-36
insert errors
Import, 2-48
specifying allowed number before termination
SQL*Loader, 6-5
INSERT into table
SQL*Loader, 5-26
INTEGER datatype, 5-51
EXTERNAL format, 5-60
trimming whitespace
SQL*Loader, 5-73
specification
SQL*Loader, 5-8
integrity constraints
failed on Import, 2-48
load method
SQL*Loader, 8-8
Oracle Version 6 export files, 2-63
interactive method
Export, 1-29
Import, 2-41
interrupted loads
continuing
SQL*Loader, 5-27
INTO TABLE clause
effect on bind array size
SQL*Loader, 5-70
INTO TABLE statement
column names
SQL*Loader, 5-40
discards
SQL*Loader, 5-23
multiple
SQL*Loader, 5-43
SQL*Loader, 5-33
invalid data
Import, 2-48
invalid objects
warning messages
during export, 1-32
invoking Export, 1-7
direct path, 1-34
invoking Import, 2-7
ITIME column
SYS.INCEXP table, 1-43
K
key values
generating
SQL*Loader, 5-48
key words, A-2
L
language support
Export, 1-45
Import, 2-55
leading whitespace
definition
SQL*Loader, 5-72
trimming
SQL*Loader, 5-75
length
specifying record length for export, 1-18,
2-26
length indicator
determining size
SQL*loader, 5-68
length of a numeric field
SQL*Loader, 5-10
length subfield
VARCHAR DATA
SQL*Loader, 5-56
libraries
foreign function
exporting, 1-47
importing, 2-60
LOAD
SQL*Loader command-line parameter, 6-5
loading
combined physical records
SQL*Loader, 4-14
datafiles containing TABs
SQL*Loader, 5-41
delimited, free-format files, 4-11,
4-32
fixed-length data, 4-8
negative numbers
SQL*Loader, 4-14
variable-length data, 4-5
LOB data, 1-7
compression, 1-13
Export, 1-47
LOG
Export parameter, 1-17,
1-32
Import parameter, 2-26
SQL*Loader command-line parameter, 6-6
log file
specifying
SQL*Loader, 6-6
log files
after a discontinued load
SQL*Loader, 5-28
datafile information
SQL*Loader, 7-4
example, 4-25,
4-30
Export, 1-17,
1-32
global information
SQL*Loader, 7-2
header Information
SQL*Loader, 7-2
Import, 2-26
SQL*Loader, 3-15
summary statistics
SQL*Loader, 7-5
table information
SQL*Loader, 7-3
table load information
SQL*Loader, 7-4
logical records
consolidating multiple physical records into
SQL*Loader, 5-29
versus physical records
SQL*Loader, 3-9
LONG data
exporting, 1-47
importing, 2-61
loading
SQL*Loader, 5-58
loading with direct path load, 8-14
LONG FLOAT
C language datatype, 5-52
LXBCNF executable, 9-16
LXEGEN executable, 9-20
LXINST executable, 9-2
M
master table
snapshots
Import, 2-51
media protection
disabling for direct path loads
SQL*Loader, 8-18
media recovery
direct path load, 8-13
SQL*Loader, 8-13
memory
controlling usage
SQL*Loader, 5-18
merging partitions in a table, 2-7,
2-31
messages
Export, 1-32
Import, 2-47
migrating data across partitions, 2-31
missing data columns
SQL*Loader, 5-35
MLSLABEL datatype
SQL*Loader
Trusted Oracle7 Server, 5-59
mode
full database
Export, 1-16,
1-22
Import, 2-23
objects exported by each, 1-4
table
Export, 1-19,
1-25
Import, 2-27
user
Export, 1-17,
1-24
multi-byte character sets
blanks
SQL*Loader, 5-39
Export and Import issues, 1-46,
2-56
SQL*Loader, 5-24
multiple CPUs
SQL*Loader, 8-24
multiple table load
control file specification
SQL*Loader, 5-43
discontinued
SQL*Loader, 5-28
generating unique sequence numbers for
SQL*Loader, 5-49
multiple-column indexes
SQL*Loader, 8-17
N
NAME column
SYS.INCEXP table, 1-43
National Language Support
SQL*Loader, 5-24
National Language Support (NLS)
data object files, 9-4
Export, 1-45
Import, 2-20,
2-55
NLS Configuration Utility, 9-16
NLS Data Installation Utility, 9-2
native datatypes
and SQL*Loader, 5-51
binary versus character data
SQL*Loader, 3-9
conflicting length specifications
SQL*Loader, 5-57
delimiters
SQL*Loader, 5-51
inter-operating system transfer issues
SQL*Loader, 5-65
NCHAR data
Export, 1-45
Import, 2-57
negative numbers
loading
SQL*Loader, 4-14
nested tables
exporting, 1-49
consistency and, 1-14
importing, 2-58
networks
Export, 1-44
Import and, 2-50
transporting Export files across a network, 1-44
NLS
See
National Language Support (NLS)
NLS Calendar Utility, 9-20
NLS Data Installation Utility, 9-2
NLS_LANG
environment variable
SQL*Loader, 5-24
NLS_LANG environment variable
Export, 1-46
Import, 2-56
NONE option
STATISTICS Export parameter, 1-19
non-fatal errors
warning messages, 1-32
normalizing data during a load
SQL*Loader, 4-18
NOT NULL constraint
Import, 2-48
load method
SQL*Loader, 8-8
null columns
at end of record
SQL*Loader, 5-72
setting
SQL*Loader, 5-71
null data
missing columns at end of record
SQL*Loader, 5-35
unspecified columns
SQL*Loader, 5-39
NULLIF keyword
field condition
SQL*Loader, 5-37
SQL*Loader, 5-71,
5-72
NULLIF...BLANKS
case study, 4-25
NULLIF...BLANKS keyword
SQL*Loader, 5-38
NUMBER datatype
SQL*Loader, 5-50
numeric EXTERNAL datatypes
binary versus character data
SQL*Loader, 3-9
delimited form
SQL*Loader, 5-60
determining length
SQL*Loader, 5-63
SQL*Loader, 5-60
trimming
SQL*Loader, 5-73
trimming whitespace
SQL*Loader, 5-73
numeric fields
precision versus length
SQL*Loader, 5-10
O
object identifiers
Export, 1-48
Import, 2-57
object names
SQL*Loader, 5-12
object tables
Import, 2-58
object type definitions
exporting, 1-48
importing, 2-58
objects
considerations for Importing, 2-57
creation errors, 2-48,
2-49
identifiers, 2-57
ignoring existing objects during import, 2-23
import creation errors, 2-23
privileges, 2-12
restoring sets
Import, 2-43
online help
Export, 1-9
Import, 2-10
operating systems
moving data to different systems
SQL*Loader, 5-65
OPTIMAL storage parameter, 2-52
optimizing
direct path loads, 8-15
input file processing
SQL*Loader, 5-18
OPTIONALLY ENCLOSED BY
SQL*Loader, 5-10,
5-74
OPTIONS keyword
for parallel loads
SQL*Loader, 5-34
SQL*Loader, 5-11
Oracle Version 6
exporting database objects, 2-63
Oracle7
creating export files with, 1-50
ORANLS option, 9-2,
9-16
output file
specifying for Export, 1-16
OWNER
Export parameter, 1-17
OWNER# column
SYS.INCEXP table, 1-43
P
packed decimal data
SQL*Loader, 5-10
padding of literal strings
SQL*Loader, 5-39
PARALLEL
SQL*Loader command-line parameter, 6-6
PARALLEL keyword
SQL*Loader, 8-26
parallel loads
allocating extents
FILE
SQL*Loader command-line parameter, 6-5
PARALLEL
SQL*Loader command-line parameter, 6-6
parameter file
comments, 1-10,
2-28
Export, 1-10,
1-17
Import, 2-11,
2-26
maximum size
Export, 1-10
parameters
ANALYZE
Import, 2-19
BUFFER
Export, 1-13
Import, 2-19
CHARSET
Import, 2-20
COMMIT
Import, 2-20
COMPRESS, 1-13
conflicts between export parameters, 1-21
CONSTRAINTS
Export, 1-15
DESTROY
Import, 2-21
DIRECT
Export, 1-15
Export, 1-11
FEEDBACK
Export, 1-16
Import, 2-22
FILE
Export, 1-16
Import, 2-22
FROMUSER
Import, 2-22
FULL
Export, 1-16
Import, 2-23
GRANTS
Export, 1-16
Import, 2-23
HELP
Export, 1-17
Import, 2-23
IGNORE
Import, 2-23
INCTYPE
Export, 1-17
Import, 2-24
INDEXES
Export, 1-17
Import, 2-25
INDEXFILE
Import, 2-25
LOG, 1-32
Export, 1-17
Import, 2-26
OWNER
Export, 1-17
PARFILE
Export, 1-7,
1-17
Import, 2-26
POINT_IN_TIME_RECOVER
Export, 1-18
Import, 2-26
RECORD
Export, 1-18
RECORDLENGTH
Export, 1-18
Import, 2-26
RECOVERY_TABLESPACES
Export, 1-19
ROWS
Export, 1-19
Import, 2-27
SHOW
Import, 2-27
SKIP_UNUSABLE_INDEXES
Import, 2-27
STATISTICS
Export, 1-19
TABLES
Export, 1-19
Import, 2-27
TOUSER
Import, 2-29
USERID
Export, 1-21
Import, 2-29
PARFILE
Export command-line option, 1-7,
1-10,
1-17
Import command-line option, 2-11,
2-26
SQL*Loader command-line parameter, 6-6
PART statement in DB2
not allowed by SQL*Loader, B-5
partitioned load
concurrent conventional path loads, 8-24
SQL*Loader, 8-24
partitioned table
export consistency and, 1-14
exporting, 1-6
importing, 2-6,
2-31,
2-33
partitioned tables in DB2
no Oracle equivalent, B-5
partition-level Export, 1-6
examples, 1-27
partition-level Import, 2-30
guidelines, 2-30
merging partitions, 2-31
reconfiguring partitions, 2-32
specifying, 1-19
passwords
hiding, 2-8
performance
direct path Export, 1-33,
1-36
direct path loads, 8-15
Import, 2-21
optimizing reading of data files
SQL*Loader, 5-18
partitioned load
SQL*Loader, 8-24
performance improvement
conventional path for small loads, 8-21
physical versus logical records
SQL*Loader, 3-9
PIECED keyword
SQL*Loader, 8-14
POINT_IN_TIME_RECOVER
Export parameter, 1-18
Import parameter, 2-26
POSITION keyword
specification of field position
SQL*Loader, 5-7
SQL*Loader, 5-40
tabs, 5-41
with multiple INTO TABLE clauses
SQL*Loader, 5-42,
5-45
precision of a numeric field versus length
SQL*Loader, 5-10
predetermined size fields
SQL*Loader, 5-73
preface
Send Us Your Comments, xix
prerequisites
SQL*Loader, 3-16
PRESERVE BLANKS keyword
SQL*Loader, 5-78
presorting data for a direct path load
case study, 4-24
primary keys
Import, 2-48
privileges
complete export, 1-37
creating for Export, 1-7
cumulative export, 1-37
DELETE
SQL*Loader, 5-26
DELETE ANY TABLE
SQL*Loader, 5-27
Export and, 1-3
granted to others, 2-13
Import, 2-11,
2-12
incremental export, 1-37
required for SQL*Loader, 3-16
See also
grants, roles
SQL*Loader and Trusted Oracle7 Server, 3-16
Q
quotation marks
backslash
escape character
SQL*Loader, 5-13
in filenames
SQL*Loader, 5-14
filenames
SQL*Loader, 5-13
SQL string
SQL*Loader, 5-13
table names and, 1-20,
2-28
use with database object names
SQL*Loader, 5-12
R
RAW datatype, 5-51
specification
SQL*Loader, 5-9
SQL*Loader, 5-54
READBUFFERS keyword
SQL*Loader, 5-18,
8-15
read-consistent export, 1-14
read-only tablespaces
Import, 2-53
RECNUM keyword
no space used in bind array
SQL*Loader, 5-71
SQL*Loader, 5-40
use with SKIP
SQL*Loader, 5-47
recompiling
stored functions, procedures, and packages, 2-60
reconfiguring partitions, 2-32
RECORD
Export parameter, 1-18
RECORDLENGTH
Export parameter, 1-18
direct path export, 1-34,
1-36
Import parameter, 2-26
records
consolidating into a single logical record
SQL*Loader, 5-29
discarded
DISCARD
SQL*Loader command-line parameter, 6-4
DISCARDMAX
SQL*Loader command-line parameter, 6-5
SQL*Loader, 5-21
discarded by SQL*Loader, 3-13,
5-23
distinguishing different formats
SQL*Loader, 5-44
extracting multiple logical records
SQL*Loader, 5-43
fixed format
SQL*Loader, 3-6
null columns at end
SQL*Loader, 5-72
physical versus logical
SQL*Loader, 3-9
rejected
SQL*Loader, 5-19
rejected by Oracle
SQL*Loader, 3-15
rejected by SQL*Loader, 3-13
setting column to record number
SQL*Loader, 5-47
short
missing data columns
SQL*Loader, 5-35
skipping
SQL*Loader, 6-8
specifying how to load
LOAD
SQL*Loader command-line parameter, 6-5
specifying length for export, 1-18,
2-26
specifying length for import, 2-26
stream format
SQL Loader, 3-8
SQL*Loader, 3-6
variable format
SQL*Loader, 3-8
RECOVERABLE keyword
SQL*Loader, 5-12
recovery
direct path load
SQL*Loader, 8-13
replacing rows, 5-26
RECOVERY_TABLESPACES parameter
Export, 1-19
redo log files
direct path load, 8-13
instance and media recovery
SQL*Loader, 8-13
saving space
direct path load, 8-18
REENABLE keyword
SQL*Loader, 8-21
REF data
exporting, 1-13
importing, 2-59
referential integrity constraints
disabling for import, 2-15
Import, 2-48
SQL*Loader, 8-20
refresh error
snapshots
Import, 2-51
reject file
specifying
SQL*Loader, 5-19
rejected records
SQL*Loader, 3-13,
5-19
relative field positioning
where a field starts
SQL*Loader, 5-74
with multiple INTO TABLE clauses
SQL*Loader, 5-44
remote operation
Export/Import, 1-44
REPLACE table
example, 4-14
to replace table during a load
SQL*LOader, 5-26
reserved words, A-2
SQL*Loader, A-2
resource errors
Import, 2-49
RESOURCE role, 2-12
restrictions
DB2 load utility, B-4
Export, 1-3
Import, 2-53
importing grants, 2-13
importing into another user's schema, 2-14
importing into own schema, 2-12
table names in Export parameter file, 1-20
table names in Import parameter file, 2-28
RESUME
DB2 keyword
SQL*Loader equivalents, 5-26
roles
EXP_FULL_DATABASE, 1-3,
1-7
IMP_FULL_DATABASE, 2-7,
2-12,
2-23,
2-29
RESOURCE, 2-12
rollback segments
CONSISTENT Export parameter, 1-14
controlling size during import, 2-21
during loads
SQL*Loader, 5-20
Export, 1-42
Import, 2-53
row errors
Import, 2-48
ROWID
Import, 2-51
ROWS
command line parameter
SQL*Loader, 8-12
Export parameter, 1-19
Import parameter, 2-27
performance issues
SQL*Loader, 8-18
SQL*Loader command-line parameter, 6-6
rows
choosing which to load
SQL*Loader, 5-34
exporting, 1-19
specifying for import, 2-27
specifying number to insert before save
SQL*Loader, 8-12
updates to existing
SQL*Loader, 5-26
S
schemas
export privileges, 1-3
specifying for Export, 1-19
specifying for import, 2-22
scientific notation for FLOAT EXTERNAL, 5-60
script files
preparing database for Import, 2-7
running before Export, 1-6,
1-50
secondary database
importing, 2-21
segments
temporary
FILE keyword
SQL*Loader, 8-27
Send Us Your Comments
boilerplate, xix
SEQUENCE keyword
SQL*Loader, 5-48
sequence numbers
cached, 1-46
exporting, 1-46
for multiple tables
SQL*Loader, 5-49
generated by SEQUENCE clause
example, 4-11
SQL*Loader, 5-48
generated, not read
SQL*Loader, 5-40
no space used in bind array
SQL*Loader, 5-71
setting column to a unique number
SQL*Loader, 5-48
sequences, 2-49
exporting, 1-46
short records with missing data
SQL*Loader, 5-35
SHORTINT
C Language datatype, 5-52
SHOW
Import parameter, 1-3,
2-27
SILENT
SQL*Loader command-line parameter, 6-7
single table load
discontinued
SQL*Loader, 5-28
single-byte character sets
Import, 2-55
SINGLEROW
SQL*Loader, 5-37
SKIP
control file keyword
SQL*Loader, 5-66
effect on RECNUM specification
SQL*Loader, 5-47
SQL*Loader, 5-29
SQL*Loader command-line parameter, 6-8
SKIP_UNUSABLE_INDEXES parameter
Import, 2-27
SMALLINT datatype, 5-51
specification
SQL*Loader, 5-8
SQL*Loader, 5-51
snapshot log
Import, 2-51
snapshots
importing, 2-50
log
Import, 2-50
master table
Import, 2-51
restoring dropped
Import, 2-51
SORTED INDEXES
case study, 4-24
direct path loads
SQL*Loader, 5-36
SQL*Loader, 8-16
sorting
multiple column indexes
SQL*Loader, 8-17
optimum sort order
SQL*Loader, 8-17
presorting in direct path load, 8-16
SORTED INDEXES statement
SQL*Loader, 8-16
special characters, A-2
SQL
key words, A-2
reserved words, A-2
special characters, A-2
SQL operators
applying to fields
SQL*Loader, 5-78
SQL string
applying SQL operators to fields
SQL*Loader, 5-78
example of, 4-27
quotation marks
SQL*Loader, 5-13
SQL*Loader
appending rows to tables, 5-26
BAD
command-line parameter, 6-3
bad file, 3-13
BADDN keyword, 5-19
BADFILE keyword, 5-19
basics, 3-2
bind arrays and performance, 5-66
BINDSIZE
command-line parameter, 6-3
BINDSIZE command-line parameter, 5-66
case studies, 4-1
associated files, 4-3
direct path load, 4-24
extracting data from a formatted report, 4-27
loading combined physical records, 4-14
loading data into multiple tables, 4-18
loading delimited, free-format files, 4-11,
4-32
loading fixed-length data, 4-8
loading variable-length data, 4-5
preparing tables, 4-4
choosing which rows to load, 5-34
command-line arguments, 6-3
command-line parameters, 6-2
summary, 6-2
CONCATENATE keyword, 5-29
concepts, 3-1
concurrent sessions, 8-26
CONTINUE_LOAD keyword, 5-29
CONTINUEIF keyword, 5-29
CONTROL
command-line parameter, 6-4
control file
creating, 3-3
controlling memory usage, 5-18
conventional path loads, 8-2
DATA
command-line parameter, 6-4
data conversion, 3-10
data definition language
expanded syntax diagrams, 5-7
high-level syntax diagrams, 5-4
data definition language (DDL), 3-5
data definition language syntax, 5-4
data mapping concepts, 3-3
datafiles
specifying, 5-16
datatype specifications, 3-10
DB2 load utility, B-1
DDL syntax reference, 5-1
delimiters, 3-10
DIRECT
command-line parameter, 6-4
DIRECT command line parameter, 8-9
DISCARD
command-line parameter, 6-4
discard file, 3-15
discarded records, 3-13
DISCARDFILE keyword, 5-21
DISCARDMAX
command-line parameter, 6-5
DISCARDMAX keyword, 5-23
DISCARDS keyword, 5-23
enclosed data, 3-10
ERRORS
command-line parameter, 6-5
errors caused by tabs, 5-41
example sessions, 4-1
exclusive access, 8-24
fields, 3-10
FILE
command-line parameter, 6-5
filenames, 5-12
index options, 5-36
INTO TABLE statement, 5-33
keywords and parameters
reference, 5-1
LOAD
command-line parameter, 6-5
load methods, 8-2
loading data
direct path method, 3-16
loading data without files, 5-46
loading LONG data, 5-58
LOG
command-line parameter, 6-6
log file
datafile information, 7-4
global information, 7-2
header information, 7-2
summary statistics, 7-5
table information, 7-3
table load information, 7-4
log file entries, 7-1
log files, 3-15
mapping data, 3-3
methods for loading data into tables, 5-25
methods of loading data, 3-16
multiple INTO TABLE statements, 5-43
National Language Support, 5-24
native datatype handling, 3-9
NULLIF...BLANKS clause
case study, 4-25
object names, 5-12
PARALLEL
command-line parameter, 6-6
parallel data loading, 8-25,
8-29
parallel loading, 8-26
PARFILE
command-line parameter, 6-6
READBUFFERS keyword, 5-18
rejected records, 3-13
replacing rows in tables, 5-26
required privileges, 3-16
reserved words, A-2
ROWS
command-line parameter, 6-6
rows
inserting into tables, 5-26
SILENT
command-line parameter, 6-7
SINGLEROW index keyword, 5-37
SKIP
command-line parameter, 6-8
SKIP keyword, 5-29
SORTED INDEXES
case study, 4-24
direct path loads, 5-36
specifying a single load method for all tables, 5-27
specifying columns, 5-39
specifying data format, 3-5
specifying data location, 3-5
specifying datatypes, 5-50
specifying field conditions, 5-37
specifying fields, 5-39
specifying more than one data file, 5-17
suppressing messages
SILENT, 6-7
terminated data, 3-10
updating rows, 5-27
USERID
command-line parameter, 6-8
SQL*Net
See
Net8
SQL/DS option (DB2 file format)
not supported by SQL*Loader, B-5
STATISTICS
Export parameter, 1-19
statistics
generating on imported data, 2-62
specifying for Export, 1-19
storage parameters, 2-52
estimating export requirements, 1-7
exporting tables, 1-13
OPTIMAL parameter, 2-52
overriding
Import, 2-53
preallocating
direct path load, 8-15
temporary for a direct path load, 8-10
stored functions
importing, 2-60
stored packages
importing, 2-60
stored procedures
direct path load, 8-23
importing, 2-60
stream format records, 3-8
SQL*Loader, 3-6
string comparisons
SQL*Loader, 5-7,
5-39
synonyms
direct path load, 8-9
Export, 1-42
syntax
data definition language
SQL*Loader, 5-1
Export command, 1-7
Import command, 2-7
syntax diagrams
SQL*Loader
expanded, 5-7
high-level, 5-4
SYSDATE datatype
case study, 4-27
no space used in bind array
SQL*Loader, 5-71
SYSDATE keyword
SQL*Loader, 5-47
SYSDBA, 1-8,
1-29,
2-42
SYS.INCEXP table
Export, 1-43
SYS.INCFIL table
Export, 1-44
SYS.INCVID table
Export, 1-44
system objects
importing, 2-14,
2-23
system tables
incremental export, 1-43
T
table-level Export, 1-6
table-level Import, 2-30
table-mode Export
specifying, 1-19
table-mode Import
examples, 2-33
tables
advanced queue (AQ)
exporting, 1-49
advanced queue (AQ) importing, 2-61
appending rows to
SQL*Loader, 5-26
continuing a multiple table load
SQL*Loader, 5-28
continuing a single table load
SQL*Loader, 5-28
defining before Import, 2-15
definitions
creating before import, 2-15
exclusive access during direct path loads
SQL*Loader, 8-24
exporting
specifying, 1-19
importing, 2-27
insert triggers
direct path load
SQL*Loader, 8-21
inserting rows
SQL*Loader, 5-26
loading data into more than one table
SQL*Loader, 5-43
loading data into tables
SQL*Loader, 5-25
loading method
for individual tables
SQL*Loader, 5-34
maintaining consistency, 1-14
manually ordering for import, 2-15
master table
Import, 2-51
name restrictions
Export, 1-20
Import, 2-27
nested
exporting, 1-49
importing, 2-58
object import order, 2-4
partitioned, 1-6,
2-6,
2-30
partitioned in DB2
no Oracle equivalent, B-5
replacing rows in
SQL*Loader, 5-26
size
USER_SEGMENTS view, 1-7
specifying a single load method for all tables
SQL*Loader, 5-27
specifying table-mode Export, 1-19
system
incremental export, 1-43
truncating
SQL*Loader, 5-27
updating existing rows
SQL*Loader, 5-26
TABLES parameter
Export, 1-19
Import, 2-27
tablespaces
dropping during import, 2-54
Export, 1-42
pre-created, 2-21
read-only
Import, 2-53
reorganizing
Import, 2-54
tabs
loading data files and
SQL*Loader, 5-41
trimming
SQL*Loader, 5-72
whitespace
SQL*Loader, 5-72
temporary segments
FILE keyword
SQL*Loader, 8-27
not exported during backup, 1-42
temporary storage in a direct path load, 8-10
TERMINATED BY
SQL*Loader, 5-10,
5-61
WHITESPACE
SQL*Loader, 5-61,
5-75
with OPTIONALLY ENCLOSED BY
SQL*Loader, 5-74
terminated fields
specified with a delimiter
SQL*Loader, 5-61,
5-74
TOUSER
Import parameter, 2-29
trailing
whitespace
trimming
SQL*Loader, 5-76
trailing blanks
loading with delimiters
SQL*Loader, 5-63
TRAILING NULLCOLS
case study, 4-27
control file keyword
SQL*LOader, 5-36
triggers
,
8-22
database insert triggers
,
8-21
permanently disabled
,
8-24
update triggers
SQL*Loader, 8-22
trimming
summary
SQL*Loader, 5-77
trailing whitespace
SQL*Loader, 5-76
VARCHAR fields
SQL*Loader, 5-73
Trusted Oracle
migrating with export/import, 2-2
Trusted Oracle7 Server
privileges for SQL*Loader, 3-16
TYPE# column
SYS.INCEXP table, 1-43
U
unique indexes
Import, 2-24
unique values
generating
SQL*Loader, 5-48
uniqueness constraints
Import, 2-48
preventing errors during import, 2-21
UNLOAD (DB2 file format)
not supported by SQL*Loader, B-5
UNRECOVERABLE keyword
SQL*Loader, 5-12,
8-18
unsorted data
direct path load
SQL*Loader, 8-17
updating rows in a table
SQL*Loader, 5-27
user definitions
importing, 2-14
USER_SEGMENTS view
Export and, 1-7
USERID
Export parameter, 1-21
Import parameter, 2-29
SQL*Loader command-line parameter, 6-8
user-mode Export
specifying, 1-17
user-mode Import
specifying, 2-29
V
VARCHAR datatype, 5-51
specification
SQL*Loader, 5-9
SQL*Loader, 5-56
trimming whitespace
SQL*Loader, 5-73
VARCHAR2 datatype, 2-63
SQL*Loader, 5-50
VARGRAPHIC datatype, 5-51
specification
SQL*Loader, 5-9
SQL*Loader, 5-55
variable format records
vs. fixed
SQL*Loader, 3-6
views
creating views necessary for Export, 1-7
Export, 1-42
W
warning messages, 1-32
WHEN clause
discards resulting from
SQL*Loader, 5-23
example, 4-18
field condition
SQL*Loader, 5-37
SQL*Loader, 5-34
whitespace
included in a field, or not
SQL*Loader, 5-75
leading
SQL*Loader, 5-72
preserving
SQL*Loader, 5-78
terminating a field with
SQL*Loader, 5-75
trailing, 5-72
trimming
SQL*Loader, 5-72
WHITESPACE
SQL*Loader, 5-10
WHITESPACE keyword
SQL*Loader, 5-61
Z
ZONED datatype, 5-51
EXTERNAL format
SQL*LOader, 5-60
trimming whitespace
SQL*Loader, 5-73
length versus precision
SQL*Loader, 5-10
specification
SQL*Loader, 5-9
SQL*Loader, 5-52
Prev
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents