Oracle8(TM) Server Utilities
Release 8.0

A54652-01

Library

Product

Contents

Prev


A

access privileges
Export, 1-4
Import, 2-10
advanced queue (AQ) tables
exporting, 1-49
importing, 2-60
aliases
directory
exporting, 1-47
importing, 2-59
ANALYZE
Import parameter, 2-16
APPEND keyword
SQL*Loader, 5-28, 5-40
APPEND to table
example, 4-9
SQL*Loader, 5-28
AQ (advanced queue) tables
exporting, 1-49
importing, 2-60
arrays
committing after insert
Import, 2-17
exporting, 1-48
importing, 2-59
ASCII
fixed-format files
exporting, 1-3
ASCII character set
Import, 2-54

B

backslash (\)
escape character in quoted strings
SQL*Loader, 5-14
quoted filenames and
SQL*Loader, 5-15
backups
restoring dropped snapshots
Import, 2-50
BAD
SQL*Loader command-line parameter, 6-3
bad file
rejected records
SQL*Loader, 3-14
specifying
bad records, 6-3
SQL*Loader, 5-21
BADDN keyword
SQL*Loader, 5-21
BADFILE keyword
SQL*Loader, 5-21
base backup
Export, 1-36
base tables
incremental export and, 1-40
BEGINDATA
control file keyword
SQL*Loader, 5-17
BFILE columns
exporting, 1-48
bind array
determining size
SQL*Loader, 5-69
determining size of
SQL*Loader, 5-71
minimizing memory requirements
SQL*Loader, 5-73
minimum requirements
SQL*Loader, 5-69
no space required for generated data
SQL*Loader, 5-74
performance implications
SQL*Loader, 5-70
size with multiple INTO TABLE clauses
SQL*Loader, 5-74
specifying number of rows
conventional path load
SQL*Loader, 6-6
specifying size
SQL*Loader, 6-4
BINDSIZE
SQL*Loader command-line parameter, 6-4
BINDSIZE command-line parameter
SQL*Loader, 5-70
blanks
BLANKS keyword for field comparison
SQL*Loader, 5-9, 5-42
loading fields consisting of blanks
SQL*Loader, 5-76
preserving
SQL*Loader, 5-81
trailing
loading with delimiters
SQL*Loader, 5-67
trimming
SQL*Loader, 5-76
whitespace
SQL*Loader, 5-76
BLANKS keyword
SQL*Loader, 5-42
BUFFER
Export parameter, 1-13
direct path export, 1-33, 1-35
Import parameter, 2-16
buffers
calculating for export, 1-13
calculating for import, 2-16
space required by
LONG DATA
SQL*Loader, 5-62
VARCHAR data
SQL*Loader, 5-60
specifying with BINDSIZE parameter
SQL*Loader, 5-71
BYTEINT datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-56

C

cached sequence numbers
Export, 1-47
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-7
preparing database for Import, 2-7
CATEXP.SQL
preparing database for Export, 1-7
preparing database for Import, 2-7
CATEXP7.SQL
preparing database for Export, 1-51
CATLDR.SQL
setup script
SQL*Loader, 8-9
CHAR columns
Version 6 export files, 2-62
CHAR datatype
delimited form
SQL*Loader, 5-64
reference
SQL*Loader, 5-62
specification
SQL*Loader, 5-10
trimming whitespace
SQL*Loader, 5-76
character datatypes
conflicting fields
SQL*Loader, 5-67
character fields
datatypes
SQL*Loader, 5-61
delimiters
SQL*Loader, 5-64
determining length
SQL*Loader, 5-67
specified with delimiters
SQL*Loader, 5-61
character sets
conversion between
during Export/Import, 1-45, 2-54
SQL*Loader, 5-26
direct path export, 1-34, 1-45
eight-bit to seven-bit conversions
Export/Import, 1-46, 2-54
multi-byte
Export/Import, 1-46, 2-55
SQL*Loader, 5-26
NCHAR data
Export, 1-46
single-byte
Export/Import, 1-46, 2-54
Version 6 conversions
Import/Export, 2-55
character strings
as part of a field comparison
SQL*LOader, 5-9
padded
when shorter than field
SQL*Loader, 5-42
CHARACTERSET keyword
SQL*Loader, 5-27
CHARSET
Import parameter, 2-17
check constraints
Import, 2-46
clusters
Export, 1-41
columns
end of a field
SQL*Loader, 5-44
exporting LONG datatypes, 1-47
naming
SQL*Loader, 5-41, 5-43
null columns at the end of a record
SQL*Loader, 5-75
reordering before Import, 2-13
setting to a constant value
SQL*Loader, 5-50
setting to a unique sequence number
SQL*Loader, 5-52
setting to datafile record number
SQL*Loader, 5-51
setting to null
SQL*Loader, 5-75
setting to null value
SQL*Loader, 5-51
setting to the current date
SQL*Loader, 5-51
setting value to zero
SQL*Loader, 5-74
specifiying as PIECED
SQL*Loader, 8-14
specifying
SQL*Loader, 5-43
starting position of a field
SQL*Loader, 5-44
combining partitions, 2-29
command-line parameters
description
SQL*Loader, 6-2
Export, 1-11
Import, 2-14
specifying defaults
SQL*Loader, 5-12
Comments
in Export parameter file, 1-10
in Import parameter file, 2-10
in SQL*Loader control file, 4-10
COMMIT
Import parameter, 2-17
complete exports, 1-36, 1-38
restrictions, 1-36
specifying, 1-17
completion messages
Export, 1-32
COMPRESS
Export parameter, 1-13, 2-51
COMPUTE option
STATISTICS Export parameter, 1-20
CONCATENATE keyword
SQL*Loader, 5-32
concurrent conventional path loads, 8-25
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-74
SQL*Loader, 5-43, 5-50
CONSTRAINTS
Export parameter, 1-15
constraints
automatic
SQL*Loader, 8-23
check
Import, 2-46
direct path load, 8-21
disabling during a direct load, 8-21
disabling referential constraints
Import, 2-13
enabling after a direct load, 8-21
enforced on a direct load, 8-21
failed
Import, 2-46
load method
SQL*Loader, 8-8
not null
Import, 2-46
preventing Import errors due to uniqueness constraints, 2-18
referential integrity
Import, 2-46
uniqueness
Import, 2-46
continuation fields
SQL*Loader, 3-10
CONTINUE_LOAD keyword
SQL*Loader, 5-31
CONTINUEIF keyword
example
SQL*Loader, 4-12
SQL*Loader, 5-32
continuing interrupted loads
SQL*Loader, 5-30
CONTROL
SQL*Loader command-line parameter, 6-4
control files
CONTROL
SQL*Loader command-line parameter, 6-4
creating
SQL*Loader, 3-4
data definition language syntax
SQL*Loader, 5-4
data definitions
basics
SQL*Loader, 3-4
definition
SQL*Loader, 3-4
editing
SQL*Loader, 3-4
field delimiters
SQL*Loader, 5-11
guidelines for creating
SQL*Loader, 3-5
location
SQL*Loader, 3-5
specifying data
SQL*Loader, 5-17
specifying discard file
SQL*Loader, 5-23
storing
SQL*Loader, 3-5
conventional path Export
compared to direct path Export, 1-32
conventional path loads
basics, 8-2
bind array
SQL*Loader, 5-70
compared to direct path loads, 8-7
using, 8-3
CREATE SESSION privilege
Export, 1-4
Import, 2-10
CREATE USER command
Import, 2-12
CTIME column
SYS.INCEXP table, 1-42
cumulative exports, 1-36, 1-37
recording, 1-18
restrictions, 1-36
specifying, 1-17
SYS.INCFIL table, 1-43
SYS.INCVID table, 1-43

D

DATA
SQL*Loader command-line parameter, 6-4
data
binary versus character format
SQL*Loader, 3-10
delimiter marks in data
SQL*Loader, 5-66
distinguishing different input formats
SQL*Loader, 5-47
enclosed
SQL*Loader, 3-11
exporting, 1-19
formatted data
SQL*Loader, 4-22
generating unique values
SQL*Loader, 5-52
including in control files
SQL*Loader, 5-17
loading in sections
SQL*Loader, 8-14
loading into more than one table
SQL*Loader, 5-47
loading LONG
SQL*Loader, 5-62
loading without files
SQL*Loader, 5-50
mapping to Oracle format
SQL*Loader, 3-4
maximum length of delimited data
SQL*Loader, 5-67
methods of loading into tables
SQL*Loader, 5-27
moving between operating systems
SQL*Loader, 5-68
saving in a direct path load, 8-12
saving rows
SQL*Loader, 8-18
terminated
SQL*Loader, 3-11
unsorted
SQL*Loader, 8-17
values optimized for performance
SQL*Loader, 5-50
data conversion
description
SQL*Loader, 3-11
data definition language
APPEND keyword, 5-28
basics
SQL*Loader, 3-4
BEGINDATA keyword, 5-17
BLANKS keyword
SQL*Loader, 5-42
CHARACTERSET keyword, 5-27
column_name
SQL*Loader, 5-9
CONCATENATE keyword, 5-32
CONSTANT keyword, 5-43, 5-50
CONTINUEIF keyword, 5-32
datatype_spec
SQL*Loader, 5-10
date mask
SQL*Loader, 5-11
DEFAULTIF keyword
SQL*Loader, 5-74
delimiter_spec
SQL*Loader, 5-11
description
SQL*Loader, 3-6
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-21
DISCARDDN keyword, 5-24
DISCARDMAX keyword
SQL*Loader, 5-25
example definition
SQL*Loader, 3-6
EXCEPTIONS keyword
SQL*Loader, 8-21
EXTERNAL keyword, 5-64
field_condition
SQL*Loader, 5-9
FILE keyword
SQL*Loader, 8-28
FLOAT keyword, 5-64
INDDN keyword, 5-17
INFILE keyword, 5-17
INSERT keyword, 5-28
length
SQL*Loader, 5-11
loading data in sections
SQL*Loader, 8-14
NULLIF keyword
SQL*Loader, 5-75
parallel keyword
SQL*Loader, 8-27
pos_spec
SQL*Loader, 5-8
POSITION keyword, 5-44
precision
SQL*Loader, 5-11
RECNUM keyword, 5-43
REENABLE keyword
SQL*Loader, 8-21
reference
keywords and parameters
SQL*Loader, 5-1
REPLACE keyword, 5-28
SEQUENCE keyword, 5-52
syntax diagrams
expanded
SQL*Loader, 5-8
high-level
SQL*Loader, 5-5
syntax reference
SQL*Loader, 5-1
SYSDATE keyword, 5-51
TERMINATED keyword, 5-64
TRUNCATE keyword, 5-28
UNRECOVERABLE keyword
SQL*Loader, 8-19
WHITESPACE keyword, 5-64
data definition language (DDL), 3-4
data field
specifying the datatype
SQL*Loader, 5-43
data mapping
concepts
SQL*Loader, 3-4
data path loads
direct and conventional, 8-2
data recovery
direct path load
SQL*Loader, 8-13
database administrator (DBA)
privileges for export, 1-4
database objects
export privileges, 1-4
exporting all, 1-5
exporting LONG columns, 1-47
transferring across a network
Import, 2-48
databases
data structure changes
incremental export and, 1-40
full export, 1-16
full import, 2-20
importing into secondary
Import, 2-18
incremental export, 1-36
preparing for Export, 1-7
preparing for Import, 2-7
privileges for exporting, 1-4
privileges for importing, 2-10
reducing fragmentation via full export/import, 2-44
reusing existing data files
Import, 2-18
datafiles
preventing overwrite during import, 2-18
reusing during import, 2-18
specifying
SQL*Loader, 5-17, 6-4
specifying buffering
SQL*Loader, 5-20
specifying format
SQL*Loader, 5-20
storage
SQL*Loader, 3-7
datatypes
BFILE
Export, 1-48
BYTEINT, 5-56
SQL*Loader, 5-10
CHAR, 5-62
Import, 2-62
SQL*Loader, 5-10
conflicting character datatype fields, 5-67
converting
SQL*Loader, 3-11, 5-54
DATE, 5-62
determining length, 5-68
SQL*Loader, 5-10
DECIMAL, 5-57
SQL*Loader, 5-10
default
SQL*Loader, 5-43
determining character field lengths
SQL*Loader, 5-67
DOUBLE, 5-56
SQL*Loader, 5-10
FLOAT, 5-56
SQL*Loader, 5-10
GRAPHIC, 5-58
SQL*Loader, 5-10
GRAPHIC EXTERNAL, 5-58
INTEGER, 5-55
SQL*Loader, 5-10
LONG
Export, 1-47
Import, 2-60, 2-63
MLSLABEL
Trusted Oracle7 Server, 5-63
native
conflicting length specifications
SQL*Loader, 5-61
inter-operating system transfer issues, 5-69
SQL*Loader, 3-10, 5-55
NUMBER
SQL*Loader, 5-54
numeric EXTERNAL, 5-63
trimming
SQL*Loader, 5-76
RAW, 5-58
SQL*Loader, 5-10
SMALLINT, 5-55
SQL*Loader, 5-10
specifications
SQL*Loader, 5-10
specifying
SQL*Loader, 5-54
specifying the datatype of a data field
SQL*Loader, 5-43
VARCHAR, 5-60
SQL*Loader, 5-10
VARCHAR2
Import, 2-62
SQL*Loader, 5-54
VARGRAPHIC, 5-59
SQL*Loader, 5-10
ZONED, 5-56
SQL*Loader, 5-10
DATE datatype
delimited form
SQL*Loader, 5-64
determining length
SQL*Loader, 5-68
mask
SQL*Loader, 5-68
specification
SQL*Loader, 5-10
SQL*Loader, 5-62
trimming whitespace
SQL*Loader, 5-76
date mask
SQL*Loader, 5-11
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-5
RESUME keyword
SQL*Loader equivalents, 5-28
SQL*Loader compatibility
ignored statements, B-4
DBA role
EXP_FULL_DATABASE role, 1-7
DBCS (DB2 double-byte character set)
not supported by Oracle, B-5
DDL, 3-6
SQL*Loader data definition language, 3-4
DECIMAL datatype
(packed), 5-55
EXTERNAL format
SQL*Loader, 5-63
trimming whitespace
SQL*Loader, 5-76
length and precision
SQL*Loader, 5-11
specification
SQL*Loader, 5-10
SQL*Loader, 5-57
DEFAULT column values
Oracle Version 6 export files, 2-63
DEFAULTIF keyword
field condition
SQL*Loader, 5-40
SQL*Loader, 5-74
DELETE ANY TABLE privilege
SQL*Loader, 5-29
DELETE CASCADE
SQL*Loader, 5-29
DELETE privilege
SQL*Loader, 5-28
delimited data
maximum length
SQL*Loader, 5-67
delimited fields
field length
SQL*Loader, 5-68
delimited files
exporting, 1-3
delimiter_spec
SQL*Loader, 5-11
delimiters
and SQL*Loader, 3-11
control files
SQL*Loader, 5-11
enclosure
SQL*Loader, 5-77
field specifications
SQL*Loader, 5-77
initial and trailing
case study, 4-22
loading trailing blanks
SQL*Loader, 5-67
marks in data
SQL*Loader, 5-66
optional enclosure
SQL*Loader, 5-77
specifying
SQL*Loader, 5-38, 5-64
termination
SQL*Loader, 5-77
DESTROY
Import parameter, 2-18
DIRECT
Export parameter, 1-15, 1-33
SQL*Loader command-line parameter, 6-4
direct path export, 1-32
BUFFER parameter, 1-35
character set and, 1-45
invoking, 1-33
performance, 1-35
RECORDLENGTH parameter, 1-35
direct path load
, 8-10
advantages, 8-6
case study, 4-20
choosing sort order
SQL*Loader, 8-17
compared to convetional path load, 8-7
conditions for use, 8-8
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-20
to continue an interrupted load
SQL*Loader, 5-30
EXCEPTIONS keyword, 8-22
field defaults, 8-9
improper sorting
SQL*Loader, 8-17
indexes, 8-10
instance recovery, 8-13
loading into synonyms, 8-9
LONG data, 8-14
media recovery, 8-14
partitioned load
SQL*Loader, 8-25
performance, 8-15
performance issues, 8-10
preallocating storage, 8-16
presorting data, 8-16
recovery, 8-13
REENABLE keyword, 8-21
referential integrity constraints, 8-21
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-17
table insert triggers, 8-22
temporary segment storage requirements, 8-10
triggers, 8-21
using, 8-7, 8-9
version requirements, 8-9
directory aliases
exporting, 1-47
importing, 2-59
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-21
DISCARD
SQL*Loader command-line parameter, 6-4
discard file
basics
SQL*Loader, 3-14
DISCARDDN keyword
different placement from DB2, B-4
SQL*Loader, 5-24
DISCARDFILE keyword
example, 4-12
DISCARDMAX keyword
example, 4-12
SQL*Loader, 5-25
DISCARDS control file clause
different placement from DB2, B-4
DISCARDS keyword
SQL*Loader, 5-25
DISCRDMAX keyword
SQL*Loader, 5-25
SQL*Loader, 5-23
discarded records
causes
SQL*Loader, 5-25
discard file
SQL*Loader, 5-23
limiting the number
SQL*Loader, 5-25
SQL*Loader, 3-14
DISCARDMAX
SQL*Loader command-line parameter, 6-5
DISCARDMAX keyword
discarded records
SQL*Loader, 5-25
discontinued loads
continuing
SQL*Loader, 5-30
DOUBLE datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-56
dropped snapshots
Import, 2-50
dropping
indexes
to continue a direct path load
SQL*LOader, 5-30

E

EBCDIC character set
Import, 2-54
eight-bit character set support, 1-46, 2-54
enclosed fields
and SQL*Loader, 3-11
ENCLOSED BY control file clause
SQL*Loader, 5-11
specified with enclosure delimiters
SQL*Loader, 5-65
whitespace in
SQL*Loader, 5-80
enclosure delimiters
and SQL*Loader, 3-11
initial
SQL*Loader, 5-66
SQL*Loader, 5-77
trailing
SQL*Loader, 5-66
ending column of a field
SQL*Loader, 5-44
error handling
Export, 1-31
Import, 2-45
error messages
caused by tab characters in data
SQL*Loader, 5-45
Export, 1-31
export log file, 1-18
fatal errors
Export, 1-31
generated by DB2 load utility, B-5
row errors during import, 2-45
warning errors
Export, 1-31
ERRORS
SQL*Loader command-line parameter, 6-5
errors
fatal
Export, 1-31
Import, 2-47
Import resource errors, 2-47
LONG data, 2-46
object creation
Import parameter IGNORE, 2-21
object creation errors, 2-46
warning
Export, 1-31
escape character
Export, 1-21
Import, 2-26
quoted strings
SQL*Loader, 5-14
ESTIMATE option
STATISTICS Export parameter, 1-20
EXCEPTIONS keyword
SQL*Loader, 8-21
EXP_FULL_DATABASE role, 1-16
assigning, 1-7
Export, 1-4
full database mode, 1-5
Import, 2-10
EXPDAT.DMP
Export output file, 1-16
EXPDATE column
SYS.INCFIL table, 1-43
EXPFILE column
SYS.INCFIL table, 1-43
EXPID column
SYS.INCEXP table, 1-42
SYS.INCFIL table, 1-43
Export
base backup, 1-36
BUFFER parameter, 1-13
CATALOG.SQL
preparing database for Export, 1-7
CATEXP.SQL
preparing database for Export, 1-7
CATEXP7.SQL
preparing the database for Version 7 export, 1-51
command line, 1-8
complete, 1-17, 1-36, 1-38
privileges, 1-36
restrictions, 1-36
COMPRESS parameter, 1-13
concept, 1-3
CONSISTENT parameter, 1-14
CONSTRAINTS parameter, 1-15
creating necessary privileges, 1-7
creating Version 7 export files, 1-50
cumulative, 1-17, 1-36, 1-37
privileges required, 1-36
restrictions, 1-36
data structures, 1-40
database optimizer statistics, 1-20
DIRECT parameter, 1-15
direct path, 1-32
displaying help message, 1-17
eight-bit vs. seven-bit character sets, 1-46
establishing export views, 1-7
examples, 1-22
full database mode, 1-22
partition-level, 1-27
table mode, 1-25
user mode, 1-24
exporting all schema objects, 1-4
exporting an entire database, 1-16
exporting indexes, 1-17
exporting objects owned by SYS, 1-5
exporting sequence numbers, 1-47
exporting to another operating system
RECORDLENGTH parameter, 1-19
FEEDBACK parameter, 1-16
FILE parameter, 1-16
full database mode, 1-4
example, 1-22
FULL parameter, 1-16
GRANTS parameter, 1-16
HELP parameter, 1-17
incremental, 1-17, 1-36
command syntax, 1-17
example, 1-41
privileges, 1-36
restrictions, 1-36
system tables, 1-42
INCTYPE parameter, 1-17
INDEXES parameter, 1-17
interactive method, 1-8, 1-29
invoking, 1-8
kinds of data exported, 1-40
last valid export
SYS.INCVID table, 1-43
log files
specifying, 1-18
LOG parameter, 1-18
logging error messages, 1-18
LONG columns, 1-47
message log file, 1-31
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-5
objects owned by SYS, 1-5
online help, 1-9
OWNER parameter, 1-18
parameter conflicts, 1-22
parameter file, 1-8, 1-10, 1-18
maximum size, 1-10
parameters, 1-11
PARFILE parameter, 1-8, 1-10, 1-18
POINT_IN_TIME_RECOVER, 1-18
preparing database, 1-7
previous versions, 1-50
RECORD parameter, 1-18
RECORDLENGTH parameter, 1-19
RECOVERY_TABLESPACES parameter, 1-19
redirecting output to a log file, 1-31
remote operation, 1-44
restrictions, 1-4
rollback segments, 1-41
ROWS parameter, 1-19
sequence numbers, 1-47
STATISTICS parameter, 1-20
storage requirements, 1-8
SYS.INCEXP table, 1-42
SYS.INCFIL table, 1-43
SYS.INCVID table, 1-43
table mode, 1-4
example, 1-25
table name restrictions, 1-21
TABLES parameter, 1-20
tracking exported objects, 1-42
tracking table for incremental export, 1-17
transferring export files across a network, 1-44
unclustered tables and, 1-4
user access privileges, 1-4
user mode, 1-4
examples, 1-24
specifying, 1-18
USER_SEGMENTS view, 1-8
USERID parameter, 1-22
using, 1-7
warning messages, 1-31
export file
displaying contents, 1-3
format, 1-3
importing the entire file, 2-20
listing contents before importing, 2-24
reading, 1-3
specifying, 1-16
EXPTYPE column
SYS.INCFIL table, 1-43
EXPUSER column
SYS.INCFIL table, 1-43
extent allocation
FILE
SQL*Loader command line parameter, 6-5
extents
consolidating into one extent
Export, 1-13
importing consolidated, 2-51
EXTERNAL datatypes
DECIMAL
SQL*Loader, 5-63
FLOAT
SQL*Loader, 5-63
GRAPHIC
SQL*Loader, 5-58
INTEGER, 5-63
numeric
determining length
SQL*Loader, 5-67
SQL*Loader, 5-63
trimming
SQL*Loader, 5-76
SQL*Loader, 3-10
ZONED
SQL*Loader, 5-63
external files
exporting, 1-48
EXTERNAL keyword
SQL*Loader, 5-64

F

fatal errors
Export, 1-31
Import, 2-46, 2-47
FEEDBACK
Export parameter, 1-16
Import parameter, 2-19
field conditions
specifying
SQL*Loader, 5-40
field length
specifications
SQL*Loader, 5-77
fields
and SQL*Loader, 3-11
character
data length
SQL*Loader, 5-67
comparing
SQL*Loader, 5-9
comparing to literals
SQL*Loader, 5-42
continuation
SQL*Loader, 3-10
DECIMAL EXTERNAL
trimming whitespace
SQL*Loader, 5-76
delimited
determining length
SQL*Loader, 5-68
specifications
SQL*Loader, 5-77
SQL*Loader, 5-64
enclosed
SQL*Loader, 5-65
FLOAT EXTERNAL
trimming whitespace
SQL*Loader, 5-76
INTEGER EXTERNAL
trimming whitespace
SQL*Loader, 5-76
length of
SQL*Loader, 5-11, 5-44
loading all blanks
SQL*Loader, 5-76
location
SQL*Loader, 5-44
numeric and precision versus length
SQL*Loader, 5-11
numeric EXTERNAL
trimming whitespace
SQL*Loader, 5-76
precision
SQL*Loader, 5-11
predetermined size
length
SQL*Loader, 5-67
SQL*Loader, 5-77
relative positioning
SQL*Loader, 5-78
specification of position
SQL*Loader, 5-8
specified with a termination delimiter
SQL*Loader, 5-64
specified with enclosure delimiters
SQL*Loader, 3-11, 5-65
specifying
SQL*Loader, 5-43
specifying default delimiters
SQL*Loader, 5-38
terminated
SQL*Loader, 5-64
VARCHAR
never trimmed
SQL*Loader, 5-77
ZONED EXTERNAL
trimming whitespace
SQL*Loader, 5-76
FIELDS clause
SQL*Loader, 5-38
terminated by whitespace
SQL*Loader, 5-79
FILE
Export parameter, 1-16
Import parameter, 2-19
keyword
SQL*Loader, 8-28
SQL*Loader command-line parameter, 6-5
FILE columns
Import, 2-59
filenames
bad file
SQL*Loader, 5-21
datafile
SQL*Loader, 5-18
quotation marks
SQL*Loader, 5-14
specifying more than one
SQL*Loader, 5-18
SQL*Loader, 5-13
files
Export file format, 1-3
file processing options string
SQL*Loader, 5-20
logfile
SQL*Loader, 3-16
SQL*Loader
bad file, 3-14
discard file, 3-14
storage
SQL*Loader, 3-7
fixed format records
SQL*Loader, 3-7
fixed-format records
vs. variable
SQL*Loader, 3-7, 3-8
FLOAT datatype, 5-55
EXTERNAL format
SQL*Loader, 5-63
trimming whitespace
SQL*Loader, 5-76
specification
SQL*Loader, 5-10
SQL*Loader, 5-56
FLOAT EXTERNAL data values
SQL*Loader, 5-64
FLOAT keyword
SQL*Loader, 5-64
foreign function libraries
exporting, 1-47
importing, 2-59
FORMAT statement in DB2
not allowed by SQL*Loader, B-5
formats
and input records
SQL*Loader, 5-48
formatting errors
SQL*Loader, 5-21
fragmentation
reducing database fragmentation via full export/import, 2-44
FROMUSER
Import parameter, 2-19
FTP
Export files, 1-44
FULL
Export parameter, 1-16
Import parameter, 2-20
full database mode
Export, 1-4
Import, 2-5, 2-20

G

GRANTS
Export parameter, 1-16
Import parameter, 2-20
grants
exporting, 1-16
importing, 2-12, 2-20
GRAPHIC datatype, 5-55
EXTERNAL format
SQL*Loader, 5-58
specification
SQL*Loader, 5-10
SQL*Loader, 5-58
GRAPHIC EXTERNAL datatype, 5-55

H

HELP
Export parameter, 1-17
Import parameter, 2-20
help
Export, 1-9
Import, 2-8
hexadecimal strings
as part of a field comparison
SQL*Loader, 5-9
padded
when shorter than field
SQL*Loader, 5-42

I

IGNORE
Import parameter, 2-21
existing objects, 2-46
object identifiers and, 2-56
IMP_FULL_DATABASE role, 2-20
created by CATEXP.SQL, 2-7
Import, 2-10, 2-27
Import, 2-1
ANALYZE parameter, 2-16
backup files, 2-50
basics, 2-3
BUFFER parameter, 2-16
CATALOG.SQL
preparing the database, 2-7
CATEXP.SQL
preparing the database, 2-7
character set conversion, 1-45, 2-54
character sets, 2-54
CHARSET parameter, 2-17
COMMIT parameter, 2-17
committing after array insert, 2-17
compatibility, 2-4
complete export file, 2-40
consolidated extents, 2-51
controlling size of rollback segments, 2-18
conversion of Version 6 CHAR columns to VARCHAR2, 2-62
creating an index-creation SQL script, 2-23
cumulative, 2-40
data files
reusing, 2-18
database
reusing existing data files, 2-18
DESTROY parameter, 2-18
disabling referential constraints, 2-13
displaying online help, 2-20
dropping a tablespace, 2-52
error handling, 2-45
errors importing database objects, 2-46
example session, 2-31
export COMPRESS parameter, 2-51
export file
importing the entire file, 2-20
listing contents before import, 2-24
failed integrity constraints, 2-46
fatal errors, 2-46, 2-47
FEEDBACK parameter, 2-19
FILE parameter, 2-19
FROMUSER parameter, 2-19
full database mode, 2-5
specifying, 2-20
FULL parameter, 2-20
grants
specifying for import, 2-20
GRANTS parameter, 2-20
HELP parameter, 2-8, 2-20
IGNORE parameter, 2-21, 2-46
IMP_FULL_DATABASE role, 2-10
importing grants, 2-12, 2-20
importing objects into other schemas, 2-12
importing rows, 2-24
importing tables, 2-25
incremental, 2-40
RESTORE option, 2-22
specifying, 2-22
SYSTEM option, 2-22
INCTYPE parameter, 2-22
INDEXES parameter, 2-22
INDEXFILE parameter, 2-22
INSERT errors, 2-46
interactive method, 2-39
into a secondary database, 2-18
invalid data, 2-46
invoking, 2-7
length of Oracle Version 6 export file DEFAULT columns, 2-63
log files
LOG parameter, 2-23
LONG columns, 2-60
manually ordering tables, 2-14
modes, 2-5
NLS considerations, 2-54
NLS_LANG environment variable, 2-54
object creation errors, 2-21
objects imported, 1-5
OPTIMAL storage parameter, 2-51
Oracle Version 6 integrity constraints, 2-63
Oracle Version 6 LONG columns, 2-63
parameter file, 2-9, 2-23
parameters, 2-14
PARFILE parameter, 2-23
partition-level, 2-5
POINT_IN_TIME_RECOVER parameter, 2-24
preparing the database, 2-7
privileges required, 2-10
read-only tablespaces, 2-51
recompiling stored procedures, 2-60
RECORDLENGTH parameter, 2-24
records
specifying length, 2-24
reducing database fragmentation, 2-44
refresh error, 2-49
reorganizing tablespace during, 2-53
resource errors, 2-47
restrictions, 2-52
rows
specifying for import, 2-24
ROWS parameter, 2-24
schema objects, 2-11, 2-12
schemas
specifying for import, 2-19
sequences, 2-47
SHOW parameter, 1-3, 2-24
single-byte character sets, 2-54
SKIP_UNUSABLE_INDEXES parameter, 2-25
snapshot log, 2-49
snapshot master table, 2-49
snapshots, 2-49
restoring dropped, 2-50
specifying by table, 2-5
specifying by user, 2-5, 2-19
specifying index creation commands, 2-22
specifying the export file, 2-19
SQL*Net See Net8
statistics on imported data, 2-61
storage parameters
overriding, 2-51
stored functions, 2-60
stored packages, 2-60
stored procedures, 2-60
system objects, 2-12, 2-20
table mode, 2-5
table objects
import order, 2-3
tables created before import, 2-13
TABLES parameter, 2-25
tablespaces, 2-19
TOUSER parameter, 2-27
transferring files across networks, 2-48
Trusted Oracle and, 2-2
unique indexes, 2-21
uniqueness constraints
preventing import errors, 2-18
user definitions, 2-12
user mode, 2-5
specifying, 2-27
USERID parameter, 2-27
using Oracle Version 6 files, 2-62
incremental export, 1-36
backing up data, 1-41
command syntax, 1-17
data selected, 1-40
recording, 1-18
restrictions, 1-36
session example, 1-41
specifying, 1-17
SYS.INCFIL table, 1-43
SYS.INCVID table, 1-43
incremental import
parameter, 2-22
specifying, 2-22
INCTYPE
Export parameter, 1-17
Import parameter, 2-22
INDDN keyword
SQL*Loader, 5-17, 5-18
index options
SINGLEROW keyword
SQL*Loader, 5-40
SORTED INDEXES
SQL*Loader, 5-39
Index Unusable state
indexes left in Index Unusable state, 8-11
INDEXES
Export parameter, 1-17
Import parameter, 2-22
indexes
creating manually, 2-23
direct path load
left in direct load state, 8-11
dropping
before continuing a direct path load
SQL*Loader, 5-30
SQL*Loader, 8-20
exporting, 1-17
importing, 2-22
index-creation commands
Import, 2-22
left direct load state
SQL*Loader, 8-17
multiple column
SQL*Loader, 8-17
presorting data
case study, 4-21
SQL*Loader, 8-16
skipping unusable, 2-25
SQL*Loader, 5-39
state after discontinued load
SQL*Loader, 5-30
unique, 2-21
INDEXFILE
Import parameter, 2-22
INFILE keyword
SQL*Loader, 5-17
INIT.ORA file
Export, 1-35
insert errors
Import, 2-46
specifying allowed number before termination
SQL*Loader, 6-5
INSERT into table
SQL*Loader, 5-28
INSERT keyword
SQL*Loader, 5-28
INTEGER datatype, 5-55
EXTERNAL format, 5-63
trimming whitespace
SQL*Loader, 5-76
specification
SQL*Loader, 5-10
integrity constraints
failed on Import, 2-46
load method
SQL*Loader, 8-8
Oracle Version 6 export files, 2-63
interactive method
Export, 1-29
Import, 2-39
interrupted loads
continuing
SQL*Loader, 5-30
INTO TABLE clause
effect on bind array size
SQL*Loader, 5-74
INTO TABLE statement
column names
SQL*Loader, 5-43
discards
SQL*Loader, 5-25
multiple
SQL*Loader, 5-47
SQL*Loader, 5-36
invalid data
Import, 2-46
invalid objects
warning messages
during export, 1-31
invoking Export, 1-8
direct path, 1-33
invoking Import, 2-7
ITIME column
SYS.INCEXP table, 1-42

K

key values
generating
SQL*Loader, 5-52
key words, A-1

L

language support
Export, 1-45
Import, 2-54
leading whitespace
definition
SQL*Loader, 5-76
trimming
SQL*Loader, 5-79
length
specifying record length for export, 1-19
length indicator
determining size
SQL*loader, 5-72
length of a numeric field
SQL*Loader, 5-11
length subfield
VARCHAR DATA
SQL*Loader, 5-60
libraries
foreign function
exporting, 1-47
importing, 2-59
LOAD
SQL*Loader command-line parameter, 6-5
loading
combined physical records
SQL*Loader, 4-12
datafiles containing TABs
SQL*Loader, 5-45
delimited, free-format files, 4-9, 4-27
fixed-length data, 4-7
negative numbers
SQL*Loader, 4-12
variable-length data, 4-5
LOB data, 1-8
compression, 1-13
Export, 1-47
LOG
Export parameter, 1-18, 1-31
Import parameter, 2-23
SQL*Loader command-line parameter, 6-5
log file
specifying
SQL*Loader, 6-5
log files
after a discontinued load
SQL*Loader, 5-30
datafile information
SQL*Loader, 7-4
example, 4-21, 4-25
Export, 1-18, 1-31
global information
SQL*Loader, 7-2
header Information
SQL*Loader, 7-2
Import, 2-23
SQL*Loader, 3-16
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-32
versus physical records
SQL*Loader, 3-9
LONG data
exporting, 1-47
importing, 2-60
loading
SQL*Loader, 5-62
loading with direct path load, 8-14
LONG FLOAT
C language datatype, 5-56
Version 6 export files, 2-63
LXBCNF executable, 9-9
LXEGEN executable, 9-12
LXINST executable, 9-3

M

master table
snapshots
Import, 2-49
media protection
disabling for direct path loads
SQL*Loader, 8-18
media recovery
direct path load, 8-14
SQL*Loader, 8-13
memory
controlling usage
SQL*Loader, 5-19
merging partitions in a table, 2-6, 2-29
messages
Export, 1-31
Import, 2-45
migrating data across partitions, 2-29
missing data columns
SQL*Loader, 5-38
MLSLABEL datatype
SQL*Loader
Trusted Oracle7 Server, 5-63
mode
full database
Export, 1-4, 1-16, 1-22
Import, 2-5, 2-20
objects exported by each, 1-5
table
Export, 1-4, 1-20, 1-25
Import, 2-5, 2-25
user
Export, 1-4, 1-18, 1-24
Import, 2-5
multi-byte character sets
blanks
SQL*Loader, 5-42
Export and Import issues, 1-46, 2-55
SQL*Loader, 5-26
multiple CPUs
SQL*Loader, 8-25
multiple table load
control file specification
SQL*Loader, 5-47
discontinued
SQL*Loader, 5-31
generating unique sequence numbers for
SQL*Loader, 5-53
multiple-column indexes
SQL*Loader, 8-17

N

NAME column
SYS.INCEXP table, 1-42
National Language Support
SQL*Loader, 5-26
National Language Support (NLS)
data object files, 9-4
Export, 1-45
Import, 2-17, 2-54
NLS Configuration Utility, 9-8
NLS Data Installation Utility, 9-2
native datatypes
and SQL*Loader, 5-55
binary versus character data
SQL*Loader, 3-10
conflicting length specifications
SQL*Loader, 5-61
delimiters
SQL*Loader, 5-55
inter-operating system transfer issues
SQL*Loader, 5-69
NCHAR data
Export, 1-46
Import, 2-55
negative numbers
loading
SQL*Loader, 4-12
nested tables
exporting, 1-50
consistency and, 1-14
importing, 2-57
networks
Export, 1-44
Import and, 2-48
transporting Export files across a network, 1-44
NLS
See National Language Support (NLS)
NLS Calendar Utility, 9-12
NLS Data Installation Utility, 9-2
NLS_LANG
environment variable
SQL*Loader, 5-26
NLS_LANG environment variable
Export, 1-46
Import, 2-54
NONE option
STATISTICS Export parameter, 1-20
non-fatal errors
warning messages, 1-31
normalizing data during a load
SQL*Loader, 4-15
NOT NULL constraint
Import, 2-46
load method
SQL*Loader, 8-8
null columns
at end of record
SQL*Loader, 5-75
setting
SQL*Loader, 5-75
null data
missing columns at end of record
SQL*Loader, 5-38
unspecified columns
SQL*Loader, 5-43
NULLIF keyword
field condition
SQL*Loader, 5-40
SQL*Loader, 5-75, 5-76
NULLIF...BLANKS
case study, 4-21
NULLIF...BLANKS keyword
SQL*Loader, 5-42
NUMBER datatype
SQL*Loader, 5-54
numeric EXTERNAL datatypes
binary versus character data
SQL*Loader, 3-10
delimited form
SQL*Loader, 5-64
determining length
SQL*Loader, 5-67
SQL*Loader, 5-63
trimming
SQL*Loader, 5-76
trimming whitespace
SQL*Loader, 5-76
numeric fields
precision versus length
SQL*Loader, 5-11

O

object identifiers
Export, 1-48
Import, 2-56
object names
SQL*Loader, 5-13
object tables
Import, 2-57
object type definitions
exporting, 1-48
importing, 2-57
objects
considerations for Importing, 2-56
creation errors, 2-46
identifiers, 2-56
ignoring existing objects during import, 2-21
import creation errors, 2-21
privileges, 2-11
restoring
Import, 2-22
restoring sets
Import, 2-41
online help
Export, 1-9
Import, 2-8
operating systems
moving data to different systems
SQL*Loader, 5-68
OPTIMAL storage parameter, 2-51
optimizing
direct path loads, 8-15
input file processing
SQL*Loader, 5-20
OPTIONALLY ENCLOSED BY
SQL*Loader, 5-11, 5-77
OPTIONS keyword
for parallel loads
SQL*Loader, 5-37
SQL*Loader, 5-12
ORA_NLS environment variable, 9-3, 9-9
Oracle Version 6
exporting database objects, 2-62
Oracle7
creating export files with, 1-51
ORANLS option, 9-3, 9-9
output file
specifying for Export, 1-16
OWNER
Export parameter, 1-18
OWNER# column
SYS.INCEXP table, 1-42

P

packed decimal data
SQL*Loader, 5-11
padding of literal strings
SQL*Loader, 5-42
PARALLEL
SQL*Loader command-line parameter, 6-6
PARALLEL keyword
SQL*Loader, 8-27
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-26
Export, 1-10, 1-18
Import, 2-9, 2-23
maximum size
Export, 1-10
parameters
ANALYZE
Import, 2-16
BUFFER
Export, 1-13
Import, 2-16
CHARSET
Import, 2-17
COMMIT
Import, 2-17
COMPRESS, 1-13
conflicts between export parameters, 1-22
CONSTRAINTS
Export, 1-15
DESTROY
Import, 2-18
DIRECT
Export, 1-15
Export, 1-11
FEEDBACK
Export, 1-16
Import, 2-19
FILE
Export, 1-16
Import, 2-19
FROMUSER
Import, 2-19
FULL
Export, 1-16
Import, 2-20
GRANTS
Export, 1-16
Import, 2-20
HELP
Export, 1-17
Import, 2-20
IGNORE
Import, 2-21
INCTYPE
Export, 1-17
Import, 2-22
INDEXES
Export, 1-17
Import, 2-22
INDEXFILE
Import, 2-22
LOG, 1-31
Export, 1-18
Import, 2-23
OWNER
Export, 1-18
PARFILE
Export, 1-8, 1-18
Import, 2-23
POINT_IN_TIME_RECOVER
Export, 1-18
Import, 2-24
RECORD
Export, 1-18
RECORDLENGTH
Export, 1-19
Import, 2-24
RECOVERY_TABLESPACES
Export, 1-19
ROWS
Export, 1-19
Import, 2-24
SHOW
Import, 2-24
SKIP_UNUSABLE_INDEXES
Import, 2-25
STATISTICS
Export, 1-20
TABLES
Export, 1-20
Import, 2-25
TOUSER
Import, 2-27
USERID
Export, 1-22
Import, 2-27
PARFILE
Export command-line option, 1-8, 1-10, 1-18
Import command-line option, 2-9, 2-23
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-25
SQL*Loader, 8-25
partitioned table
export consistency and, 1-14
exporting, 1-7
importing, 2-5, 2-6, 2-29, 2-31
partitioned tables in DB2
no Oracle equivalent, B-5
partition-level Export, 1-7
examples, 1-27
partition-level Import, 2-5, 2-28
guidelines, 2-28
merging partitions, 2-29
reconfiguring partitions, 2-30
specifying, 1-20
passwords
hiding, 2-8
performance
direct path Export, 1-32, 1-35
direct path loads, 8-15
Import, 2-18
optimizing reading of data files
SQL*Loader, 5-20
partitioned load
SQL*Loader, 8-25
performance improvement
conventional path for small loads, 8-22
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-24
POSITION keyword
specification of field position
SQL*Loader, 5-8
SQL*Loader, 5-44
tabs, 5-45
with multiple INTO TABLE clauses
SQL*Loader, 5-45, 5-49
precision of a numeric field versus length
SQL*Loader, 5-11
predetermined size fields
SQL*Loader, 5-77
prerequisites
SQL*Loader, 3-16
PRESERVE BLANKS keyword
SQL*Loader, 5-81
presorting data for a direct path load
case study, 4-20
primary keys
Import, 2-46
privileges
complete export, 1-36
creating for Export, 1-7
cumulative export, 1-36
DELETE
SQL*Loader, 5-28
DELETE ANY TABLE
SQL*Loader, 5-29
Export and, 1-4
granted to others, 2-12
Import, 2-10
incremental export, 1-36
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-14
in filenames
SQL*Loader, 5-15
filenames
SQL*Loader, 5-14
SQL string
SQL*Loader, 5-14
table names and, 1-21, 2-26
use with database object names
SQL*Loader, 5-13

R

RAW datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-58
READBUFFERS keyword
SQL*Loader, 5-19, 8-15
read-consistent export, 1-14
read-only tablespaces
Import, 2-51
RECNUM keyword
no space used in bind array
SQL*Loader, 5-74
SQL*Loader, 5-43
use with SKIP
SQL*Loader, 5-51
recompiling
stored functions, procedures, and packages, 2-60
reconfiguring partitions, 2-30
RECORD
Export parameter, 1-18
RECORDLENGTH
Export parameter, 1-19
direct path export, 1-33, 1-35
Import parameter, 2-24
records
consolidating into a single logical record
SQL*Loader, 5-32
discarded
DISCARD SQL*Loader command-line parameter, 6-4
DISCARDMAX SQL*Loader command-line parameter, 6-5
SQL*Loader, 5-23
discarded by SQL*Loader, 3-14, 5-25
distinguishing different formats
SQL*Loader, 5-48
extracting multiple logical records
SQL*Loader, 5-47
fixed format
SQL*Loader, 3-7
null columns at end
SQL*Loader, 5-75
physical versus logical
SQL*Loader, 3-9
rejected
SQL*Loader, 5-21
rejected by Oracle
SQL*Loader, 3-14
rejected by SQL*Loader, 3-14
setting column to record number
SQL*Loader, 5-51
short
missing data columns
SQL*Loader, 5-38
skipping
SQL*Loader, 6-7
specifying how to load
LOAD
SQL*Loader command-line parameter, 6-5
specifying length for export, 1-19
specifying length for import, 2-24
stream format
SQL Loader, 3-8
SQL*Loader, 3-7
variable format
SQL*Loader, 3-8, 3-9
RECOVERABLE keyword
SQL*Loader, 5-13
recovery
direct path load
SQL*Loader, 8-13
replacing rows, 5-28
RECOVERY_TABLESPACES parameter
Export, 1-19
redo log files
direct path load, 8-14
instance and media recovery
SQL*Loader, 8-14
saving space
direct path load, 8-19
REENABLE keyword
SQL*Loader, 8-21
REF data
exporting, 1-13
importing, 2-58
referential integrity constraints
disabling for import, 2-13
Import, 2-46
SQL*Loader, 8-21
refresh error
snapshots
Import, 2-49
reject file
specifying
SQL*Loader, 5-21
rejected records
SQL*Loader, 3-14, 5-21
relative field positioning
where a field starts
SQL*Loader, 5-78
with multiple INTO TABLE clauses
SQL*Loader, 5-48
remote operation
Export/Import, 1-44
REPLACE keyword
SQL*Loader, 5-28
REPLACE table
example, 4-12
to replace table during a load
SQL*LOader, 5-28
reserved words, A-1
SQL*Loader, A-1
resource errors
Import, 2-47
RESOURCE role, 2-11
restrictions
DB2 load utility, B-5
Export, 1-4
Import, 2-52
importing grants, 2-12
importing into another user's schema, 2-12
importing into own schema, 2-11
table names in Export parameter file, 1-21
table names in Import parameter file, 2-26
RESUME
DB2 keyword
SQL*Loader equivalents, 5-28
roles
EXP_FULL_DATABASE, 1-4, 1-5, 1-7
IMP_FULL_DATABASE, 2-7, 2-10, 2-20, 2-27
RESOURCE, 2-11
rollback segments
CONSISTENT Export parameter, 1-14
controlling size during import, 2-18
during loads
SQL*Loader, 5-22
Export, 1-41
Import, 2-52
row errors
Import, 2-46
ROWID
Import, 2-49
ROWS
command line parameter
SQL*Loader, 8-12
Export parameter, 1-19
Import parameter, 2-24
performance issues
SQL*Loader, 8-18
SQL*Loader command-line parameter, 6-6
rows
choosing which to load
SQL*Loader, 5-37
exporting, 1-19
specifying for import, 2-24
specifying number to insert before save
SQL*Loader, 8-12
updates to existing
SQL*Loader, 5-29

S

schemas
export privileges, 1-4
specifying for Export, 1-20
specifying for import, 2-19
scientific notation for FLOAT EXTERNAL, 5-64
script files
preparing database for Import, 2-7
running before Export, 1-7, 1-51
secondary database
importing, 2-18
segments
temporary
FILE keyword
SQL*Loader, 8-28
SEQUENCE keyword
SQL*Loader, 5-52
sequence numbers
cached, 1-47
exporting, 1-47
for multiple tables
SQL*Loader, 5-53
generated by SEQUENCE clause
example, 4-9
SQL*Loader, 5-52
generated, not read
SQL*Loader, 5-43
no space used in bind array
SQL*Loader, 5-74
setting column to a unique number
SQL*Loader, 5-52
sequences, 2-47
exporting, 1-47
short records with missing data
SQL*Loader, 5-38
SHORTINT
C Language datatype, 5-56
SHOW
Import parameter, 1-3, 2-24
SILENT
SQL*Loader command-line parameter, 6-6
single table load
discontinued
SQL*Loader, 5-30
single-byte character sets
Import, 2-54
SINGLEROW
SQL*Loader, 5-40
SKIP
control file keyword
SQL*Loader, 5-70
effect on RECNUM specification
SQL*Loader, 5-51
SQL*Loader, 5-31
SQL*Loader command-line parameter, 6-7
SKIP_UNUSABLE_INDEXES parameter
Import, 2-25
SMALLINT datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-55
snapshot log
Import, 2-49
snapshots
importing, 2-49
log
Import, 2-49
master table
Import, 2-49
restoring dropped
Import, 2-50
SORTED INDEXES
case study, 4-21
direct path loads
SQL*Loader, 5-39
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-1
SQL
key words, A-1
reserved words, A-1
special characters, A-1
SQL operators
applying to fields
SQL*Loader, 5-82
SQL string
applying SQL operators to fields
SQL*Loader, 5-82
example of, 4-22
quotation marks
SQL*Loader, 5-14
SQL*Loader
appending rows to tables, 5-28
BAD
command-line parameter, 6-3
bad file, 3-14
BADDN keyword, 5-21
BADFILE keyword, 5-21
basics, 3-2
bind arrays and performance, 5-70
BINDSIZE
command-line parameter, 6-4
BINDSIZE command-line parameter, 5-70
case studies, 4-1
associated files, 4-3
direct path load, 4-20
extracting data from a formatted report, 4-22
loading combined physical records, 4-12
loading data into multiple tables, 4-15
loading delimited, free-format files, 4-9, 4-27
loading fixed-length data, 4-7
loading variable-length data, 4-5
preparing tables, 4-4
choosing which rows to load, 5-37
command-line arguments, 6-3
command-line parameters, 6-2
summary, 6-2
CONCATENATE keyword, 5-32
concepts, 3-1
concurrent sessions, 8-27
CONTINUE_LOAD keyword, 5-31
CONTINUEIF keyword, 5-32
CONTROL
command-line parameter, 6-4
control file
creating, 3-4
controlling memory usage, 5-19
conventional path loads, 8-2
DATA
command-line parameter, 6-4
data conversion, 3-11
data definition language
expanded syntax diagrams, 5-8
high-level syntax diagrams, 5-5
data definition language (DDL), 3-6
data definition language syntax, 5-4
data mapping concepts, 3-4
datafiles
specifying, 5-17
datatype specifications, 3-11
DB2 load utility, B-1
DDL syntax reference, 5-1
delimiters, 3-11
DIRECT
command-line parameter, 6-4
DIRECT command line parameter, 8-9
DISCARD
command-line parameter, 6-4
discard file, 3-14
discarded records, 3-14
DISCARDFILE keyword, 5-24
DISCARDMAX
command-line parameter, 6-5
DISCARDMAX keyword, 5-25
DISCARDS keyword, 5-25
enclosed data, 3-11
ERRORS
command-line parameter, 6-5
errors caused by tabs, 5-45
example sessions, 4-1
exclusive access, 8-25
fields, 3-11
FILE
command-line parameter, 6-5
filenames, 5-13
index options, 5-39
INTO TABLE statement, 5-36
keywords and parameters
reference, 5-1
LOAD
command-line parameter, 6-5
load methods, 8-2
loading data
direct path method, 3-17
loading data without files, 5-50
loading LONG data, 5-62
LOG
command-line parameter, 6-5
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-16
mapping data, 3-4
methods for loading data into tables, 5-27
methods of loading data, 3-16
multiple INTO TABLE statements, 5-47
National Language Support, 5-26
native datatype handling, 3-10
NULLIF...BLANKS clause
case study, 4-21
object names, 5-13
PARALLEL
command-line parameter, 6-6
parallel data loading, 8-26, 8-30
parallel loading, 8-27
PARFILE
command-line parameter, 6-6
READBUFFERS keyword, 5-19
rejected records, 3-14
replacing rows in tables, 5-28
required privileges, 3-16
reserved words, A-1
ROWS
command-line parameter, 6-6
rows
inserting into tables, 5-28
SILENT
command-line parameter, 6-6
SINGLEROW index keyword, 5-40
SKIP
command-line parameter, 6-7
SKIP keyword, 5-31
SORTED INDEXES
case study, 4-21
direct path loads, 5-39
specifying a single load method for all tables, 5-29
specifying columns, 5-43
specifying data format, 3-6
specifying data location, 3-6
specifying datatypes, 5-54
specifying field conditions, 5-40
specifying fields, 5-43
specifying more than one data file, 5-18
suppressing messages
SILENT, 6-6
terminated data, 3-11
updating rows, 5-29
USERID
command-line parameter, 6-8
SQL*Net See Net8
SQL/DS option (DB2 file format)
not supported by SQL*Loader, B-5
starting column of a field
SQL*Loader, 5-44
STATISTICS
Export parameter, 1-20
statistics
generating on imported data, 2-61
specifying for Export, 1-20
storage parameters, 2-50
estimating export requirements, 1-8
exporting tables, 1-13
OPTIMAL parameter, 2-51
overriding
Import, 2-51
preallocating
direct path load, 8-16
temporary for a direct path load, 8-10
stored functions
importing, 2-60
stored packages
importing, 2-60
stored procedures
direct path load, 8-24
importing, 2-60
stream format records, 3-8
SQL*Loader, 3-7
string comparisons
SQL*Loader, 5-9, 5-42
synonyms
direct path load, 8-9
Export, 1-41
syntax
data definition language
SQL*Loader, 5-1
Export command, 1-8
Import command, 2-7
syntax diagrams
SQL*Loader
expanded, 5-8
high-level, 5-5
SYS
exporting objects owned by, 1-5
SYS.INCEXP table
Export, 1-42
incremental export tracking table, 1-17
SYS.INCFIL table
Export, 1-43
SYS.INCVID table
Export, 1-17, 1-43
SYSDATE datatype
case study, 4-22
no space used in bind array
SQL*Loader, 5-74
SYSDATE keyword
SQL*Loader, 5-51
system objects
importing, 2-12, 2-20
system tables
incremental export, 1-42

T

table-level Export, 1-7
table-level Import, 2-28
table-mode Export, 1-4
specifying, 1-20
table-mode Import, 2-5
examples, 2-31
tables
advanced queue (AQ)
exporting, 1-49
advanced queue (AQ) importing, 2-60
appending rows to
SQL*Loader, 5-28
continuing a multiple table load
SQL*Loader, 5-31
continuing a single table load
SQL*Loader, 5-30
defining before Import, 2-13
definitions
creating before import, 2-13
exclusive access during direct path loads
SQL*Loader, 8-25
exporting
specifying, 1-20
importing, 2-25
insert triggers
direct path load
SQL*Loader, 8-22
inserting rows
SQL*Loader, 5-28
loading data into more than one table
SQL*Loader, 5-47
loading data into tables
SQL*Loader, 5-27
loading method
for individual tables
SQL*Loader, 5-37
maintaining consistency, 1-14
manually ordering for import, 2-14
master table
Import, 2-49
name restrictions
Export, 1-21
Import, 2-25
nested
exporting, 1-50
importing, 2-57
object import order, 2-3
partitioned, 1-7, 2-5, 2-28
partitioned in DB2
no Oracle equivalent, B-5
replacing rows in
SQL*Loader, 5-28
size
USER_SEGMENTS view, 1-8
specifying a single load method for all tables
SQL*Loader, 5-29
specifying table-mode Export, 1-20
system
incremental export, 1-42
truncating
SQL*Loader, 5-29
updating existing rows
SQL*Loader, 5-29
TABLES parameter
Export, 1-20
Import, 2-25
tablespaces
dropping during import, 2-52
Export, 1-41
pre-created, 2-19
read-only
Import, 2-51
reorganizing
Import, 2-53
tabs
loading data files and
SQL*Loader, 5-45
trimming
SQL*Loader, 5-76
whitespace
SQL*Loader, 5-76
temporary segments
FILE keyword
SQL*Loader, 8-28
not exported during backup, 1-41
temporary storage in a direct path load, 8-10
TERMINATED BY
SQL*Loader, 5-11, 5-64
WHITESPACE
SQL*Loader, 5-64, 5-79
with OPTIONALLY ENCLOSED BY
SQL*Loader, 5-77
terminated fields
specified with a delimiter
SQL*Loader, 5-64, 5-77
TOUSER
Import parameter, 2-27
trailing
whitespace
trimming
SQL*Loader, 5-80
trailing blanks
loading with delimiters
SQL*Loader, 5-67
TRAILING NULLCOLS
case study, 4-22
control file keyword
SQL*LOader, 5-39
triggers
, 8-22
database insert triggers
, 8-22
permanently disabled
, 8-25
update triggers
SQL*Loader, 8-23
trimming
summary
SQL*Loader, 5-80
trailing whitespace
SQL*Loader, 5-80
VARCHAR fields
SQL*Loader, 5-77
TRUNCATE keyword
SQL*Loader, 5-28
Trusted Oracle
migrating with export/import, 2-2
Trusted Oracle7 Server
privileges for SQL*Loader, 3-16
TYPE# column
SYS.INCEXP table, 1-42

U

unclustered table
exporting, 1-4
unique indexes
Import, 2-21
unique values
generating
SQL*Loader, 5-52
uniqueness constraints
Import, 2-46
preventing errors during import, 2-18
UNLOAD (DB2 file format)
not supported by SQL*Loader, B-5
UNRECOVERABLE keyword
SQL*Loader, 5-13, 8-19
unsorted data
direct path load
SQL*Loader, 8-17
updating rows in a table
SQL*Loader, 5-29
user definitions
importing, 2-12
USER_SEGMENTS view
Export and, 1-8
USERID
Export parameter, 1-22
Import parameter, 2-27
SQL*Loader command-line parameter, 6-8
user-mode Export, 1-4
specifying, 1-18
user-mode Import, 2-5
specifying, 2-27

V

VARCHAR datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-60
trimming whitespace
SQL*Loader, 5-77
VARCHAR2 datatype, 2-62
SQL*Loader, 5-54
VARGRAPHIC datatype, 5-55
specification
SQL*Loader, 5-10
SQL*Loader, 5-59
variable format records
vs. fixed
SQL*Loader, 3-7
views
creating views necessary for Export, 1-7
Export, 1-41

W

warning messages, 1-31
WHEN clause
discards resulting from
SQL*Loader, 5-25
example, 4-15
field condition
SQL*Loader, 5-40
SQL*Loader, 5-37
whitespace
included in a field, or not
SQL*Loader, 5-79
leading
SQL*Loader, 5-76
preserving
SQL*Loader, 5-81
terminating a field with
SQL*Loader, 5-79
trailing, 5-76
trimming
SQL*Loader, 5-76
WHITESPACE
SQL*Loader, 5-11
WHITESPACE keyword
SQL*Loader, 5-64

Z

ZONED datatype, 5-55
EXTERNAL format
SQL*LOader, 5-63
trimming whitespace
SQL*Loader, 5-76
length versus precision
SQL*Loader, 5-11
specification
SQL*Loader, 5-10
SQL*Loader, 5-56


Prev
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents