Oracle8i Utilities
Release 8.1.5

A67792-01

Library

Product

Contents

Prev

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, 2-11
Export, 1-4
advanced queue (AQ) tables
exporting, 1-57
importing, 2-61
aliases
directory
exporting, 1-56
importing, 2-60
ANALYZE
Import parameter, 2-19
analyzer statistics, 2-63
APPEND keyword
SQL*Loader, 5-43
APPEND to table
example, 4-11
SQL*Loader, 5-32
AQ (advanced queue) tables
exporting, 1-57
importing, 2-61
arrays
committing after insert
Import, 2-20
ASCII
fixed-format files
exporting, 1-4
ASCII character set
Import, 2-56
atomic nulls, 5-93
attribute nulls, 5-92

B

backslash escape character, 5-20
backups
restoring dropped snapshots
Import, 2-51
BAD
SQL*Loader command-line parameter, 6-3
bad file
rejected records in SQL*Loader, 3-12
specifying bad records, 6-3
specifying for SQL*Loader, 5-25
BADDN keyword
SQL*Loader, 5-25
BADFILE keyword
SQL*Loader, 5-25
base backup
Export, 1-44
base tables
incremental export and, 1-48
BEGINDATA
control file keyword, 5-21
BFILE columns
exporting, 1-56
BFILE datatype, 5-106
BFILEs
loading, 5-98
bind array
determining size, 5-74
determining size of for SQL*Loader, 5-76
minimizing SQL*Loader memory requirements, 5-79
minimum requirements, 5-74
size with multiple SQL*Loader INTO TABLE clauses, 5-79
specifying, 6-4
specifying number of rows, 6-7
SQL*Loader performance implications, 5-75
BINDSIZE
SQL*Loader command-line parameter, 6-4
BINDSIZE command-line parameter
SQL*Loader, 5-75
blanks
BLANKS keyword for field comparison, 5-15
loading fields consisting of blanks, 5-81
preserving, 5-86
SQL*Loader BLANKS keyword for field comparison, 5-45
trailing, 5-72
trimming, 5-81
whitespace, 5-81
BLANKS keyword
SQL*Loader, 5-45
BLOBs"loading, 5-98
BUFFER
Export parameter, 1-16
direct path export, 1-43
Import parameter, 2-19
buffers
calculating for export, 1-16
space required by
LONG DATA, 5-63
VARCHAR data, 5-62
specifying with SQL*Loader BINDSIZE parameter, 5-76
BYTEINT datatype, 5-58, 5-59

C

cached sequence numbers
Export, 1-55
case studies
preparing tables for SQL*Loader, 4-4
SQL*Loader, 4-1
SQL*Loader associated files, 4-3
SQL*Loader file names, 4-3
CATALOG.SQL
preparing database for Export, 1-9
preparing database for Import, 2-7
CATEXP7.SQL
preparing database for Export, 1-60
CATEXP.SQL
preparing database for Export, 1-9
preparing database for Import, 2-7
CATLDR.SQL
setup script
SQL*Loader, 8-10
CHAR columns
Version 6 export files, 2-65
CHAR datatype
delimited form and SQL*Loader, 5-69
reference
SQL*Loader, 5-63
trimming whitespace, 5-82
character datatypes
conflicting fields, 5-72
character fields
datatypes
SQL*Loader, 5-63
delimiters and SQL*Loader, 5-69
determining length for SQL*Loader, 5-72
specified with delimiters
SQL*Loader, 5-63
character set conversions, 2-55
character sets
conversion between
during Export/Import, 1-53
direct path export, 1-43, 1-53
eight-bit to seven-bit conversions
Export/Import, 1-53, 2-56
multi-byte
Export/Import, 1-54, 2-56
multi-byte and SQL*Loader, 5-30
NCHAR data
Export, 1-54
single-byte
Export/Import, 1-53, 2-56
SQL*Loader conversion between, 5-30
Version 6 conversions
Import/Export, 2-56
character strings
as part of a field comparison, 5-15
SQL*Loader, 5-46
CHARACTERSET keyword
SQL*Loader, 5-31
check constraints
Import, 2-48
CLOBs
example, 4-39
loading, 5-98
clusters
Export, 1-49
Collections, 3-16
collections, 3-20
column naming
SQL*Loader, 5-46
column objects
loading, 5-90
loading nested column objects, 5-92
stream record format, 5-90
variable record format, 5-91
columns
exporting LONG datatypes, 1-55
loading REF columns, 5-96
null columns at the end of a record, 5-81
reordering before Import, 2-14
setting to a constant value with
SQL*Loader, 5-54
setting to a unique sequence number using SQL*Loader, 5-55
setting to datafile record number with SQL*Loader, 5-54
setting to null, 5-80
setting to null value with SQL*Loader, 5-54
setting to the current date using
SQL*Loader, 5-55
setting value to zero, 5-80
specifiying as PIECED
SQL*Loader, 8-15
specifying
SQL*Loader, 5-46
command-line parameters
description, 6-2
Export, 1-14
specifying defaults, 5-18
Comments
in Export parameter file, 1-13
in Import parameter file, 2-10
in SQL*Loader control file, 4-12
COMMIT
Import parameter, 2-20
complete exports, 1-44, 1-46
restrictions, 1-44
specifying, 1-20
completion messages
Export, 1-40
COMPRESS
Export parameter, 1-16, 2-53
COMPUTE option
STATISTICS Export parameter, 1-23
CONCATENATE keyword
SQL*Loader, 5-36
concurrent conventional path loads, 8-25
connect string
Net8, 1-52
CONSISTENT
Export parameter, 1-17
nested table and, 1-17
partitioned table and, 1-17
consolidating extents
Export parameter COMPRESS, 1-16
CONSTANT keyword
SQL*Loader, 5-46, 5-54
CONSTRAINTS
Export parameter, 1-18, 2-21
constraints
automatic
SQL*Loader, 8-23
check
Import, 2-48
direct path load, 8-21
disabling during a direct load, 8-21
disabling referential constraints, 2-14
enabling after a direct load, 8-21
enforced on a direct load, 8-21
failed
Import, 2-48
load method, 8-9
not null
Import, 2-48
preventing Import errors due to uniqueness constraints, 2-20
referential integrity
Import, 2-48
uniqueness
Import, 2-48
CONTINUE_LOAD keyword
SQL*Loader, 5-35
CONTINUEIF keyword
example, 4-15
SQL*Loader, 5-36
continuing interrupted loads
SQL*Loader, 5-34
CONTROL
SQL*Loader command-line parameter, 6-4
control files
data definition language syntax, 5-3
field delimiters, 5-16
guidelines for creating, 3-3
specifying data, 5-21
specifying SQL*Loader discard file, 5-27
conventional path Export
compared to direct path Export, 1-41
conventional path loads
basics, 8-2
compared to direct path loads, 8-7
SQL*Loader bind array, 5-75
using, 8-3
CREATE SESSION privilege, 2-11
Export, 1-4
CREATE USER command
Import, 2-14
CTIME column
SYS.INCEXP table, 1-51
cumulative exports, 1-44, 1-46
recording, 1-23
restrictions, 1-44
specifying, 1-20
SYS.INCFIL table, 1-51
SYS.INCVID table, 1-52
custom record separator, 3-18

D

DATA
SQL*Loader command-line parameter, 6-4
data
delimiter marks in data and SQL*Loader, 5-71
distinguishing different input formats for SQL*Loader, 5-50
exporting, 1-23
formatted data and SQL*Loader, 4-28
generating unique values with
SQL*Loader, 5-55
including in control files, 5-21
loading data contained in the SQL*Loader control file, 5-53
loading in sections
SQL*Loader, 8-14
loading into more than one table
SQL*Loader, 5-50
loading LONG
SQL*Loader, 5-63
maximum length of delimited data for SQL*Loader, 5-72
moving between operating systems using SQL*Loader, 5-73
saving in a direct path load, 8-12
saving rows
SQL*Loader, 8-18
SQL*Loader methods of loading into
tables, 5-32
unsorted
SQL*Loader, 8-17
values optimized for SQL*Loader performance, 5-53
data conversion
SQL*Loader, 3-9
data definition language
BEGINDATA keyword, 5-21
BLANKS keyword, 5-45
column_name, 5-16
CONCATENATE keyword, 5-36
CONSTANT keyword, 5-46, 5-54
CONTINUEIF keyword, 5-36
date mask, 5-16
DEFAULTIF keyword, 5-80
delimiter_spec, 5-16
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-22
DISCARDDN keyword, 5-28
EXCEPTIONS keyword
SQL*Loader, 8-22
expanded syntax diagrams, 5-15
EXTERNAL keyword, 5-66
field_condition, 5-15
FILE keyword
SQL*Loader, 8-29
FLOAT keyword, 5-66
INFILE keyword, 5-22
length, 5-16
loading data in sections
SQL*Loader, 8-14
NULLIF keyword, 5-80
parallel keyword
SQL*Loader, 8-27
pos_spec, 5-15
POSITION keyword, 5-48
precision, 5-16
RECNUM keyword, 5-46
REENABLE keyword
SQL*Loader, 8-22
SEQUENCE keyword, 5-55
SQL*Loader CHARACTERSET keyword, 5-31
SQL*Loader DISCARDMAX keyword, 5-30
syntax diagrams
high-level, 5-4
SYSDATE keyword, 5-55
TERMINATED keyword, 5-69
UNRECOVERABLE keyword
SQL*Loader, 8-19
WHITESPACE keyword, 5-69
data field
specifying the SQL*Loader datatype, 5-47
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 LONG columns, 1-55
transferring across a network
Import, 2-50
databases
data structure changes
incremental export and, 1-48
full export, 1-20
full import, 2-23
incremental export, 1-44
preparing for Export, 1-9
privileges for exporting, 1-4
reducing fragmentation via full export/import, 2-46
reusing existing data files
Import, 2-21
datafiles
preventing overwrite during import, 2-21
reusing during import, 2-21
specifying, 6-4
specifying buffering for SQL*Loader, 5-24
specifying for SQL*Loader, 5-22
specifying format for SQL*Loader, 5-24
datatypes
BFILE
Export, 1-56
BYTEINT, 5-59
CHAR, 5-63
conflicting character datatype fields, 5-72
converting
SQL*Loader, 5-68
converting SQL*Loader, 3-9
DATE, 5-64
DECIMAL, 5-60
default in SQL*Loader, 5-47
determining character field lengths for SQL*Loader, 5-72
determining DATE length, 5-73
DOUBLE, 5-59
FLOAT, 5-58
GRAPHIC, 5-65
GRAPHIC EXTERNAL, 5-65
INTEGER, 5-58
LONG
Export, 1-55
Import, 2-61
native
conflicting length specifications, 5-68
SQL*Loader, 5-58
non-scalar, 5-92
NUMBER
SQL*Loader, 5-69
numeric EXTERNAL, 5-66, 5-82
RAW, 5-67
SMALLINT, 5-58
specifying the SQL*Loader datatype of a data field, 5-47
VARCHAR, 5-61
VARCHAR2
SQL*Loader, 5-69
VARGRAPHIC, 5-60
ZONED, 5-59
DATE datatype
delimited form and SQL*Loader, 5-69
determining length, 5-73
mask
SQL*Loader, 5-73
SQL*Loader, 5-64
trimming whitespace, 5-82
date mask, 5-16
DB2 load utility, B-1
different placement of statements
DISCARDDDN, B-3
DISCARDS, B-3
restricted capabilities of SQL*Loader, B-3
RESUME keyword, 5-32
SQL*Loader compatibility
ignored statements, B-2
DBA role
EXP_FULL_DATABASE role, 1-9
DBCS (DB2 double-byte character set)
not supported by Oracle, B-4
DBVERIFY, 9-1
DBVERIFY output, 9-3
DBVERIFY restrictions, 9-2
DECIMAL datatype, 5-60
(packed), 5-58
EXTERNAL format
SQL*Loader, 5-66
length and precision, 5-16
DEFAULT column values
Oracle Version 6 export files, 2-65
DEFAULTIF keyword
SQL*Loader, 5-44, 5-80
DELETE ANY TABLE privilege
SQL*Loader, 5-33
DELETE CASCADE
SQL*Loader, 5-33
DELETE privilege
SQL*Loader, 5-33
delimited data
maximum length for SQL*Loader, 5-72
delimited fields
field length, 5-73
delimited files
exporting, 1-4
delimited LOBs, 5-103
delimiter_spec, 5-16
delimiters
control files, 5-16
initial and trailing example, 4-28
loading trailing blanks, 5-72
marks in data and SQL*Loader, 5-71
optional SQL*Loader enclosure, 5-82
specifying
SQL*Loader, 5-41
specifying for SQL*Loader, 5-69
SQL*Loader enclosure, 5-82
SQL*Loader field specifications, 5-82
termination, 5-83
DESTROY
Import parameter, 2-21
DIRECT
Export parameter, 1-18, 1-43
SQL*Loader command-line parameter, 6-5
direct path export, 1-41
BUFFER parameter, 1-43
character set and, 1-53
invoking, 1-43
RECORDLENGTH parameter, 1-43
direct path load
, 8-11
advantages, 8-6
choosing sort order
SQL*Loader, 8-18
compared to convetional path load, 8-7
conditions for use, 8-8
data saves, 8-12, 8-18
DIRECT command line parameter
SQL*Loader, 8-10
DIRECT command-line parameter, 6-5
DISABLED_CONSTRAINTS keyword, 8-22
disabling media protection
SQL*Loader, 8-19
dropping indexes, 8-20
dropping indexes to continue an interrupted load, 5-34
example, 4-25
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-26
performance, 8-16
performance issues, 8-10
preallocating storage, 8-16
presorting data, 8-16
recovery, 8-13
REENABLE keyword, 8-22
referential integrity constraints, 8-21
ROWS command line parameter, 8-13
setting up, 8-10
specifying, 8-10
specifying number of rows to be read, 6-7
SQL*Loader data loading method, 3-15
table insert triggers, 8-22
temporary segment storage requirements, 8-11
triggers, 8-21
using, 8-7, 8-10
version requirements, 8-9
directory aliases
exporting, 1-56
importing, 2-60
DISABLED_CONSTRAINTS keyword
SQL*Loader, 8-22
DISCARD
SQL*Loader command-line parameter, 6-5
discard file
basics, 3-14
DISCARDDN keyword
different placement from DB2, B-3
DISCARDS control file clause
different placement from DB2, B-3
example, 4-15
SQL*Loader, 5-27
SQL*Loader DISCARDDN keyword, 5-28
SQL*Loader DISCARDMAX keyword, 5-29
SQL*Loader DISCARDS keyword, 5-29
SQL*Loader DISCRDMAX keyword, 5-30
discarded records
causes, 5-29
limiting, 5-29
SQL*Loader, 3-12
discarded SQL*Loader records
discard file, 5-27
DISCARDMAX
SQL*Loader command-line parameter, 6-5
DISCARDMAX keyword
SQL*Loader discarded records, 5-30
discontinued loads
continuing with SQL*Loader, 5-34
DOUBLE datatype, 5-58, 5-59
dropped snapshots
Import, 2-51
dropping
indexes
to continue a direct path load, 5-34

E

EBCDIC character set
Import, 2-56
eight-bit character set support, 1-53, 2-56
enclosed fields
ENCLOSED BY control file clause, 5-16
specified with enclosure delimiters and SQL*Loader, 5-70
whitespace, 5-86
enclosure delimiters
SQL*Loader, 5-82
error handling
Export, 1-39
Import, 2-47
error messages
caused by tab characters in SQL*Loader data, 5-49
Export, 1-39
export log file, 1-21
fatal errors
Export, 1-40
generated by DB2 load utility, B-3
row errors during import, 2-47
warning errors
Export, 1-39
ERRORS
SQL*Loader command-line parameter, 6-5
errors
fatal
Export, 1-40
Import, 2-49
Import resource errors, 2-49
LONG data, 2-48
object creation
Import parameter IGNORE, 2-24
object creation errors, 2-48
warning
Export, 1-39
escape character
Export, 1-25
Import, 2-29
quoted strings, 5-20
ESTIMATE option
STATISTICS Export parameter, 1-23
EXCEPTIONS keyword
SQL*Loader, 8-22
EXP_FULL_DATABASE role, 1-20, 2-11
assigning, 1-9
Export, 1-4
EXPDAT.DMP
Export output file, 1-19
EXPID column
SYS.INCEXP table, 1-51
Export
base backup, 1-44
BUFFER parameter, 1-16
CATALOG.SQL
preparing database for Export, 1-9
CATEXP7.SQL
preparing the database for Version 7 export, 1-60
CATEXP.SQL
preparing database for Export, 1-9
command line, 1-10
complete, 1-20, 1-44, 1-46
privileges, 1-44
restrictions, 1-44
COMPRESS parameter, 1-16
CONSISTENT parameter, 1-17
CONSTRAINTS parameter, 1-18
creating necessary privileges, 1-9
creating Version 7 export files, 1-58
cumulative, 1-20, 1-44, 1-46
privileges required, 1-44
restrictions, 1-44
data structures, 1-48
database optimizer statistics, 1-23, 2-27
DIRECT parameter, 1-18
direct path, 1-41
displaying help message, 1-20
eight-bit vs. seven-bit character sets, 1-53
establishing export views, 1-9
examples, 1-27
full database mode, 1-27
partition-level, 1-33
table mode, 1-31
user mode, 1-30
exporting an entire database, 1-20
exporting indexes, 1-21
exporting sequence numbers, 1-55
exporting to another operating system, 2-27
RECORDLENGTH parameter, 1-23
FEEDBACK parameter, 1-19
FILE parameter, 1-19
full database mode
example, 1-27
FULL parameter, 1-20
GRANTS parameter, 1-20
HELP parameter, 1-20
incremental, 1-20, 1-44
command syntax, 1-20
example, 1-49
privileges, 1-44
restrictions, 1-44
system tables, 1-50
INCTYPE parameter, 1-20
INDEXES parameter, 1-21
interactive method, 1-10, 1-36
invoking, 1-10
kinds of data exported, 1-48
last valid export
SYS.INCVID table, 1-52
log files
specifying, 1-21
LOG parameter, 1-21
logging error messages, 1-21
LONG columns, 1-55
message log file, 1-39
modes, 1-5
multi-byte character sets, 1-54
network issues, 1-52
NLS support, 1-53
objects exported, 1-5
online help, 1-11
OWNER parameter, 1-21
parameter conflicts, 1-27
parameter file, 1-10, 1-13, 1-21
maximum size, 1-13
parameters, 1-14
PARFILE parameter, 1-10, 1-13, 1-21
preparing database, 1-9
previous versions, 1-58
RECORD parameter, 1-23
RECORDLENGTH parameter, 1-23
redirecting output to a log file, 1-39
remote operation, 1-52
restrictions, 1-4
rollback segments, 1-49
ROWS parameter, 1-23
sequence numbers, 1-55
STATISTICS parameter, 1-23
storage requirements, 1-9
SYS.INCEXP table, 1-51
SYS.INCFIL table, 1-51
SYS.INCVID table, 1-52
table mode
example, 1-31
table name restrictions, 1-25
TABLES parameter, 1-24
tracking exported objects, 1-51
transferring export files across a network, 1-52
user access privileges, 1-4
user mode
examples, 1-30
specifying, 1-21
USER_SEGMENTS view, 1-9
USERID parameter, 1-26
using, 1-9
warning messages, 1-39
export file
displaying contents, 1-4
importing the entire file, 2-23
listing contents before importing, 2-28
reading, 1-4
specifying, 1-19
extent allocation
FILE command line parameter, 6-6
extents
consolidating into one extent
Export, 1-16
importing consolidated, 2-53
EXTERNAL datatypes
DECIMAL
SQL*Loader, 5-66
FLOAT
SQL*Loader, 5-66
GRAPHIC
SQL*Loader, 5-65
INTEGER, 5-66
numeric
determining length, 5-72
SQL*Loader, 5-66
trimming, 5-82
ZONED
SQL*Loader, 5-66
external files
exporting, 1-56
EXTERNAL keyword
SQL*Loader, 5-66
external LOBS
loading, 5-98
external LOBs (BFILE), 5-106

F

fatal errors
Export, 1-40
Import, 2-48, 2-49
FEEDBACK
Export parameter, 1-19
Import parameter, 2-22
field conditions
specifying for SQL*Loader, 5-44
field delimiters, 3-19
field length
SQL*Loader specifications, 5-82
field location
SQL*Loader, 5-48
fields
character data length and SQL*Loader, 5-72
comparing, 5-15
comparing to literals with SQL*Loader, 5-46
DECIMAL EXTERNAL and trimming whitespace, 5-82
delimited
determining length, 5-73
delimited and SQL*Loader, 5-69
enclosed and SQL*Loader, 5-70
FLOAT EXTERNAL and trimming whitespace, 5-82
INTEGER EXTERNAL and trimming whitespace, 5-82
length, 5-16
loading all blanks, 5-81
numeric and precision versus length, 5-16
numeric EXTERNAL and trimming whitespace, 5-82
precision, 5-16
predetermined size
length, 5-72
predetermined size and SQL*Loader, 5-82
relative positioning and SQL*Loader, 5-83
specification of position, 5-15
specified with a termination delimiter and SQL*Loader, 5-69
specified with enclosure delimiters and SQL*Loader, 5-70
specifying default delimiters for SQL*Loader, 5-41
specifying for SQL*Loader, 5-46
SQL*Loader delimited
specifications, 5-82
terminated and SQL*Loader, 5-69
VARCHAR
never trimmed, 5-82
ZONED EXTERNAL and trimming whitespace, 5-82
FIELDS clause
SQL*Loader, 5-41
terminated by whitespace, 5-85
FILE
Export parameter, 1-19
Import parameter, 2-22
keyword
SQL*Loader, 8-29
SQL*Loader command-line parameter, 6-6
FILE columns
Import, 2-60
FILE keyword, 8-29
filenames
quotation marks, 5-19
specifying multiple SQL*Loader, 5-23
SQL*Loader, 5-18
SQL*Loader bad file, 5-25
files
SQL*Loader bad file, 3-12
SQL*Loader discard file, 3-14
SQL*Loader file processing options string, 5-24
FILESIZE, 1-19
FILLER field
example, 4-39
Fine-Grained Access Support, 2-52
fixed record length
example, 4-34
fixed-format records, 3-5
FLOAT datatype, 5-58
EXTERNAL format
SQL*Loader, 5-66
FLOAT EXTERNAL data values
SQL*Loader, 5-66
FLOAT keyword
SQL*Loader, 5-66
foreign function libraries
exporting, 1-55
importing, 2-60
FORMAT statement in DB2
not allowed by SQL*Loader, B-4
formats
and SQL*Loader input records, 5-51
formatting errors
SQL*Loader, 5-25
fragmentation
reducing database fragmentation via full export/import, 2-46
FROMUSER
Import parameter, 2-23
FTP
Export files, 1-52
FULL
Export parameter, 1-20
full database mode
Import, 2-23
full field names, 3-22

G

GRANTS
Export parameter, 1-20
Import parameter, 2-23
grants
exporting, 1-20
importing, 2-13, 2-23
GRAPHIC datatype, 5-58
EXTERNAL format
SQL*Loader, 5-65
SQL*Loader, 5-65
GRAPHIC EXTERNAL datatype, 5-58

H

HELP
Export parameter, 1-20
Import parameter, 2-24
help
Export, 1-11
Import, 2-9
hexadecimal strings
as part of a field comparison, 5-15
SQL*Loader, 5-46

I

IGNORE
Import parameter, 2-24, 2-57
existing objects, 2-48
IMP_FULL_DATABASE role, 2-7, 2-11, 2-23
Import, 2-31
Import, 2-1
ANALYZE parameter, 2-19
backup files, 2-51
BUFFER parameter, 2-19
CATEXP.SQL
preparing the database, 2-7
character set conversion, 1-53, 2-56
character sets, 2-55
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-20
conversion of Version 6 CHAR columns to VARCHAR2, 2-65
creating an index-creation SQL script, 2-26
cumulative, 2-43
data files
reusing, 2-21
database
reusing existing data files, 2-21
DESTROY parameter, 2-21
disabling referential constraints, 2-14
displaying online help, 2-24
dropping a tablespace, 2-54
error handling, 2-47
errors importing database objects, 2-48
example session, 2-34
export COMPRESS parameter, 2-53
export file
importing the entire file, 2-23
listing contents before import, 2-28
failed integrity constraints, 2-48
fatal errors, 2-48, 2-49
FEEDBACK parameter, 2-22
FILE parameter, 2-22
FROMUSER parameter, 2-23
grants
specifying for import, 2-23
GRANTS parameter, 2-23
HELP parameter, 2-9, 2-24
IGNORE parameter, 2-24, 2-48
importing grants, 2-13, 2-23
importing objects into other schemas, 2-13
importing rows, 2-27
importing tables, 2-28
incremental, 2-43
specifying, 2-25
INCTYPE parameter, 2-25
INDEXES parameter, 2-25
INDEXFILE parameter, 2-26
INSERT errors, 2-48
interactive method, 2-41
invalid data, 2-48
invoking, 2-7
length of Oracle Version 6 export file DEFAULT columns, 2-65
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-24
objects imported, 1-5
OPTIMAL storage parameter, 2-53
Oracle Version 6 integrity constraints, 2-65
parameter file, 2-10, 2-27
parameters, 2-16
preparing the database, 2-7
read-only tablespaces, 2-54
recompiling stored procedures, 2-61
RECORDLENGTH parameter, 2-27
records
specifying length, 2-27
reducing database fragmentation, 2-46
refresh error, 2-51
reorganizing tablespace during, 2-54
resource errors, 2-49
rows
specifying for import, 2-27
ROWS parameter, 2-27
schema objects, 2-11, 2-13
sequences, 2-49
SHOW parameter, 1-4, 2-28
single-byte character sets, 2-56
snapshot log, 2-50
snapshot master table, 2-51
snapshots, 2-50
restoring dropped, 2-51
specifying by user, 2-23
specifying index creation commands, 2-26
specifying the export file, 2-22
storage parameters
overriding, 2-53
stored functions, 2-61
stored packages, 2-61
stored procedures, 2-61
system objects, 2-13
table objects
import order, 2-4
tables created before import, 2-14
TABLES parameter, 2-28
TOUSER parameter, 2-31
transferring files across networks, 2-50
unique indexes, 2-25
uniqueness constraints
preventing import errors, 2-20
user definitions, 2-14
USERID parameter, 2-32
using Oracle Version 6 files, 2-65
incremental export, 1-44
backing up data, 1-49
command syntax, 1-20
data selected, 1-48
recording, 1-23
restrictions, 1-44
session example, 1-49
specifying, 1-20
SYS.INCFIL table, 1-51
SYS.INCVID table, 1-52
incremental import
parameter, 2-25
specifying, 2-25
INCTYPE
Export parameter, 1-20
Import parameter, 2-25
index options
SORTED INDEXES with SQL*Loader, 5-43
SQL*Loader SINGLEROW keyword, 5-43
Index Unusable state
indexes left in Index Unusable state, 8-11
INDEXES
Export parameter, 1-21
Import parameter, 2-25
indexes
creating manually, 2-26
direct path load
left in direct load state, 8-11
dropping
SQL*Loader, 8-20
dropping before continuing a direct path load, 5-34
exporting, 1-21
importing, 2-25
index-creation commands
Import, 2-26
left direct load state
SQL*Loader, 8-17
multiple column
SQL*Loader, 8-17
presorting data, 4-25
SQL*Loader, 8-16
skipping unusable, 2-28
SQL*Loader, 5-43
state after discontinued load, 5-34
unique, 2-25
INDEXFILE
Import parameter, 2-26
INFILE keyword
SQL*Loader, 5-22
insert errors
Import, 2-48
specifying, 6-5
INSERT into table
SQL*Loader, 5-33
INTEGER datatype, 5-58
EXTERNAL format, 5-66
integrity constraints
failed on Import, 2-48
load method, 8-9
Oracle Version 6 export files, 2-65
interactive method
Export, 1-36
Internal LOBs
loading, 5-98
interrupted loads
continuing with SQL*Loader, 5-34
INTO TABLE clause
effect on bind array size, 5-79
INTO TABLE statement
column names
SQL*Loader, 5-46
discards
SQL*Loader, 5-29
multiple statements with SQL*Loader, 5-50
SQL*Loader, 5-39
invalid data
Import, 2-48
invalid objects
warning messages
during export, 1-39
invoking Export, 1-10
direct path, 1-43
ITIME column
SYS.INCEXP table, 1-51

K

key values
generating with SQL*Loader, 5-55
key words, A-2
keywords, STORAGE, 8-29

L

language support
Export, 1-53
Import, 2-55
leading whitespace
definition, 5-81
trimming and SQL*Loader, 5-84
length
specifying record length for export, 1-23, 2-27
length indicator
determining size, 5-77
length of a numeric field, 5-16
length subfield
VARCHAR DATA
SQL*Loader, 5-61
length-value pair specified LOBs, 5-104
libraries
foreign function
exporting, 1-55
importing, 2-60
LOAD
SQL*Loader command-line parameter, 6-6
loading
datafiles containing tabs
SQL*Loader, 5-49
variable-length data, 4-5
loading combined physical records, 4-15
loading delimited, free-format files, 4-11
loading fixed-length data, 4-8
loading negative numbers, 4-15
LOB data, 1-9
compression, 1-16
Export, 1-55
LOB data in delimited fields, 5-99
LOB data in length-value pair fields, 5-100
LOB data in predetermined size fields, 5-98
LOBFILEs, 3-22, 5-98, 5-101
example, 4-39
LOBs, 3-20
loading, 5-98
loading external, 5-98
loading internal LOBs, 5-98
LOG
Export parameter, 1-21, 1-39
Import parameter, 2-26
SQL*Loader command-line parameter, 6-6
log file
specifying for SQL*Loader, 6-6
log files
after a discontinued load, 5-34
example, 4-26, 4-31
Export, 1-21, 1-39
Import, 2-26
SQL*Loader, 3-14
SQL*Loader datafile information, 7-3
SQL*Loader global information, 7-2
SQL*Loader header Information, 7-2
SQL*Loader summary statistics, 7-4
SQL*Loader table information, 7-3
SQL*Loader table load information, 7-4
logical records
consolidating multiple physical records using SQL*Loader, 5-36
LONG data
C language datatype LONG FLOAT, 5-59
exporting, 1-55
importing, 2-61
loading
SQL*Loader, 5-63
loading with direct path load, 8-14
LONG VARRAW, 5-62

M

master table
snapshots
Import, 2-51
materialized views, 2-50, 2-51
media protection
disabling for direct path loads
SQL*Loader, 8-19
media recovery
direct path load, 8-14
SQL*Loader, 8-14
memory
controlling SQL*Loader use, 5-24
messages
Export, 1-39
Import, 2-47
migrating data across partitions, 2-34
missing data columns
SQL*Loader, 5-42
mode
full database
Export, 1-20, 1-27
objects exported by each, 1-5
table
Export, 1-24, 1-31
user
Export, 1-21, 1-30
multi-byte character sets
blanks with SQL*Loader, 5-46
Export and Import issues, 1-54, 2-56
SQL*Loader, 5-30
multiple CPUs
SQL*Loader, 8-26
multiple table load
discontinued, 5-34
generating unique sequence numbers using SQL*Loader, 5-56
SQL*Loader control file specification, 5-50
multiple-column indexes
SQL*Loader, 8-17

N

NAME column
SYS.INCEXP table, 1-51
National Language Support
SQL*Loader, 5-30
National Language Support (NLS)
Export, 1-53
Import, 2-55
native datatypes
and SQL*Loader, 5-58
conflicting length specifications
SQL*Loader, 5-68
NCHAR data
Export, 1-54
NCLOBs
loading, 5-98
negative numbers
loading, 4-15
nested column objects
loading, 5-92
nested tables
exporting, 1-57
consistency and, 1-17
importing, 2-59
networks
Export, 1-52
Import and, 2-50
transporting Export files across a network, 1-52
NLS
See National Language Support (NLS)
NLS_LANG, 2-55
environment variable and SQL*Loader, 5-30
NLS_LANG environment variable
Export, 1-53
Import, 2-56
NONE option
STATISTICS Export parameter, 1-23
non-fatal errors
warning messages, 1-39
non-scalar datatypes, 5-92
normalizing data during a load
SQL*Loader, 4-19
NOT NULL constraint
Import, 2-48
load method, 8-9
null columns
at end of record, 5-81
null data
missing columns at end of record during load, 5-42
unspecified columns and SQL*Loader, 5-46
NULL values
objects, 5-92
NULLIF keyword
SQL*Loader, 5-44, 5-80, 5-81
NULLIF...BLANKS
example, 4-26
NULLIF...BLANKS clause
example, 4-26
NULLIF...BLANKS keyword
SQL*Loader, 5-45
nulls
atomic, 5-93
attribute, 5-92
NUMBER datatype
SQL*Loader, 5-69
numeric EXTERNAL datatypes
delimited form and SQL*Loader, 5-69
determining length, 5-72
SQL*Loader, 5-66
trimming, 5-82
trimming whitespace, 5-82
numeric fields
precision versus length, 5-16

O

object identifiers, 2-57
Export, 1-56
object names
SQL*Loader, 5-18
object support, 3-23
object tables
Import, 2-58
loading, 5-95
object type definitions
exporting, 1-56
importing, 2-58
object type identifiers, 2-30
Objects, 3-16
objects, 3-20
considerations for Importing, 2-57
creation errors, 2-48
ignoring existing objects during import, 2-24
import creation errors, 2-24
loading column objects, 5-90
loading nested column objects, 5-92
NULL values, 5-92
privileges, 2-11
restoring sets
Import, 2-43
stream record format, 5-90
variable record format, 5-91
Offline Bitmapped Tablespaces, 1-55
OIDs, 5-95
online help
Export, 1-11
Import, 2-9
operating systems
moving data to different systems using SQL*Loader, 5-73
OPTIMAL storage parameter, 2-53
optimizer statistics, 2-63
optimizing
direct path loads, 8-16
SQL*Loader input file processing, 5-24
OPTIONALLY ENCLOSED BY, 5-16
SQL*Loader, 5-83
OPTIONS keyword, 5-18
for parallel loads, 5-40
Oracle Version 6
exporting database objects, 2-65
Oracle7
creating export files with, 1-60
output file
specifying for Export, 1-19
OWNER
Export parameter, 1-21
OWNER# column
SYS.INCEXP table, 1-51

P

packed decimal data, 5-16
padding of literal strings
SQL*Loader, 5-46
PARALLEL
SQL*Loader command-line parameter, 6-6
PARALLEL keyword
SQL*Loader, 8-27
parallel loads
allocating extents, 6-6
PARALLEL command-line parameter, 6-6
parameter file
comments, 1-13, 2-29
Export, 1-13, 1-21
Import, 2-10, 2-27
maximum size
Export, 1-13
parameteres
TABLESPACES, 2-29
parameters
ANALYZE, 2-19
BUFFER
Export, 1-16
COMMIT
Import, 2-20
COMPRESS, 1-16
conflicts between export parameters, 1-27
CONSTRAINTS
Export, 1-18
DESTROY
Import, 2-21
DIRECT
Export, 1-18
Export, 1-14
FEEDBACK
Export, 1-19
Import, 2-22
FILE
Export, 1-19
Import, 2-22
FROMUSER
Import, 2-23
FULL
Export, 1-20
GRANTS
Export, 1-20
Import, 2-23
HELP
Export, 1-20
Import, 2-24
IGNORE
Import, 2-24
INCTYPE
Export, 1-20
Import, 2-25
INDEXES
Export, 1-21
Import, 2-25
INDEXFILE
Import, 2-26
LOG, 1-39
Export, 1-21
Import, 2-26
OWNER
Export, 1-21
PARFILE
Export, 1-10, 1-21
RECORD
Export, 1-23
RECORDLENGTH
Export, 1-23
Import, 2-27
ROWS
Export, 1-23
Import, 2-27
SHOW
Import, 2-28
SKIP_UNUSABLE_INDEXES
Import, 2-28
STATISTICS
Export, 1-23
TABLES
Export, 1-24
Import, 2-28
TOID_NOVALIDATE, 2-30
TOUSER
Import, 2-31
USERID
Export, 1-26
Import, 2-32
PARFILE
Export command-line option, 1-10, 1-13, 1-21
Import command-line option, 2-10, 2-27
SQL*Loader command-line parameter, 6-6
PART statement in DB2
not allowed by SQL*Loader, B-4
partitioned load
concurrent conventional path loads, 8-25
SQL*Loader, 8-26
partitioned or subpartitioned table
loading, 8-6
partitioned table
export consistency and, 1-17
exporting, 1-8
importing, 2-6, 2-35
partitioned tables
example, 4-34
partitioned tables in DB2
no Oracle equivalent, B-4
partition-level Export, 1-8
examples, 1-33
partition-level Import, 2-33
guidelines, 2-33
specifying, 1-24
passwords
hiding, 2-8
performance
direct path Export, 1-41, 1-43
direct path loads, 8-16
Import, 2-20
optimizing reading of SQL*Loader data files, 5-24
partitioned load
SQL*Loader, 8-26
performance improvement
conventional path for small loads, 8-22
PIECED keyword
SQL*Loader, 8-14
POSITION keyword
specification of field position, 5-15
SQL*Loader, 5-48
SQL*Loader and multiple INTO TABLE clauses, 5-49
tabs, 5-49
with multiple SQL*Loader INTO TABLE clauses, 5-52
precision of a numeric field versus length, 5-16
predetermined size fields
SQL*Loader, 5-82
predetermined size LOBs, 5-102
preface
Send Us Your Comments, xix
prerequisites
SQL*Loader, 3-15
PRESERVE BLANKS keyword
SQL*Loader, 5-86
presorting data for a direct path load
example, 4-25
primary key OID
example, 4-44
primary key OIDs, 5-95
Primary Key REF Columns, 5-97
primary key REF columns, 5-97
primary keys
Import, 2-48
privileges, 2-11
complete export, 1-44
creating for Export, 1-9
cumulative export, 1-44
Export and, 1-4
incremental export, 1-44
required for SQL*Loader, 3-15
See also grants, roles

Q

quotation marks
escaping, 5-20
filenames, 5-19
SQL string, 5-19
table names and, 1-25, 2-29
use with database object names, 5-19

R

RAW datatype, 5-58, 5-63
SQL*Loader, 5-67
READBUFFERS keyword
SQL*Loader, 5-24, 8-15
read-consistent export, 1-17
read-only tablespaces
Import, 2-54
Real REF Columns, 5-96
RECALCULATE_STATISTICS parameter, 2-27
RECNUM keyword
SQL*Loader, 5-46
use with SQL*Loader keyword SKIP, 5-54
recompiling
stored functions, procedures, and packages, 2-61
RECORD
Export parameter, 1-23
RECORDLENGTH
Export parameter, 1-23
direct path export, 1-43
Import parameter, 2-27
records
consolidating into a single logical record
SQL*Loader, 5-36
DISCARD command-line parameter, 6-5
discarded by SQL*Loader, 3-12, 5-27
DISCARDMAX command-line parameter, 6-5
distinguishing different formats for SQL*Loader, 5-51
extracting multiple logical records using SQL*Loader, 5-50
fixed format, 3-5
missing data columns during load, 5-42
null columns at end, 5-81
rejected, 3-14
rejected by SQL*Loader, 3-12
rejected SQL*Loader records, 5-25
setting column to record number with SQL*Loader, 5-54
skipping during load, 6-9
specifying how to load, 6-6
specifying length for export, 1-23, 2-27
specifying length for import, 2-27
stream record format, 3-6
variable format, 3-6
recovery
direct path load
SQL*Loader, 8-13
replacing rows, 5-32
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-22
REF Columns, 5-96
REF columns
primary key, 5-97
real, 5-96
REF data
exporting, 1-16
importing, 2-60
REF Fields
example, 4-44
referential integrity constraints
disabling for import, 2-14
Import, 2-48
SQL*Loader, 8-21
refresh error
snapshots
Import, 2-51
reject file
specifying for SQL*Loader, 5-25
rejected records
SQL*Loader, 3-12, 5-25
relative field positioning
where a field starts and SQL*Loader, 5-83
with multiple SQL*Loader INTO TABLE clauses, 5-51
remote operation
Export/Import, 1-52
REPLACE table
example, 4-15
replacing a table using SQL*Loader, 5-33
reserved words, A-2
SQL*Loader, A-2
resource errors
Import, 2-49
RESOURCE role, 2-11
restrictions
DB2 load utility, B-3
Export, 1-4
importing grants, 2-13
importing into another user's schema, 2-13
importing into own schema, 2-11
table names in Export parameter file, 1-25
table names in Import parameter file, 2-29
RESUME
DB2 keyword, 5-32
roles
EXP_FULL_DATABASE, 1-4, 1-9
IMP_FULL_DATABASE, 2-7, 2-23, 2-31
RESOURCE, 2-11
rollback segments
CONSISTENT Export parameter, 1-17
controlling size during import, 2-20
during SQL*Loader loads, 5-26
Export, 1-49
row errors
Import, 2-48
ROWID
Import, 2-51
ROWS
command line parameter
SQL*Loader, 8-13
Export parameter, 1-23
Import parameter, 2-27
performance issues
SQL*Loader, 8-18
SQL*Loader command-line parameter, 6-7
rows
choosing which to load using SQL*Loader, 5-40
exporting, 1-23
specifying for import, 2-27
specifying number to insert before save
SQL*Loader, 8-13
updates to existing rows with SQL*Loader, 5-33

S

schemas
export privileges, 1-4
specifying for Export, 1-24
scientific notation for FLOAT EXTERNAL, 5-66
script files
running before Export, 1-9, 1-60
SDFs, 3-22
segments
temporary
FILE keyword, 8-29
Send Us Your Comments
boilerplate, xix
SEQUENCE keyword
SQL*Loader, 5-55
sequence numbers
cached, 1-55
exporting, 1-55
for multiple tables and SQL*Loader, 5-56
generated by SEQUENCE clause, 4-11
generated by SQL*Loader SEQUENCE clause, 5-55
generated, not read and SQL*Loader, 5-46
setting column to a unique number with SQL*Loader, 5-55
sequences, 2-49
exporting, 1-55
short records with missing data
SQL*Loader, 5-42
SHORTINT
C Language datatype, 5-58
SHOW
Import parameter, 1-4, 2-28
SILENT
SQL*Loader command-line parameter, 6-8
single table load
discontinued, 5-34
single-byte character sets
Import, 2-56
SINGLEROW
SQL*Loader, 5-43
SKIP
effect on SQL*Loader RECNUM specification, 5-54
SQL*Loader, 5-35
SQL*Loader command-line parameter, 6-9
SQL*Loader control file keyword, 5-75
SKIP_UNUSABLE_INDEXES parameter, 2-28
SMALLINT datatype, 5-58
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
direct path loads, 5-43
example, 4-25
SQL*Loader, 8-17
sorting
multiple column indexes
SQL*Loader, 8-17
optimum sort order
SQL*Loader, 8-18
presorting in direct path load, 8-16
SORTED INDEXES statement
SQL*Loader, 8-17
special characters, A-2
SQL
key words, A-2
reserved words, A-2
special characters, A-2
SQL operators
applying to fields, 5-87
SQL string
applying SQL operators to fields, 5-87
example, 4-28
quotation marks, 5-19
SQL*Loader
appending rows to tables, 5-32
bad file, 3-12
BADDN keyword, 5-25
BADFILE keyword, 5-25
basics, 3-2
bind arrays and performance, 5-75
BINDSIZE
command-line parameter, 6-4
BINDSIZE command-line parameter, 5-75
case studies, 4-1
case studies (direct path load), 4-25
case studies (extracting data from a formatted report), 4-28
case studies (loading combined physical records), 4-15
case studies (loading data into multiple tables), 4-19
case studies (loading delimited, free-format files), 4-11
case studies (loading fixed-length data), 4-8
case studies (loading variable-length data), 4-5
case studies associated files, 4-3
choosing which rows to load, 5-40
command-line parameters, 6-2
CONCATENATE keyword, 5-36
concepts, 3-1
concurrent sessions, 8-27
CONTINUE_LOAD keyword, 5-35
CONTINUEIF keyword, 5-36
CONTROL command-line parameter, 6-4
controlling memory use, 5-24
conventional path loads, 8-2
DATA command-line parameter, 6-4
data conversion, 3-9
data definition language
expanded syntax diagrams, 5-15
high-level syntax diagrams, 5-4
data definition language syntax, 5-3
datatype specifications, 3-9
DB2 load utility, B-1
DIRECT command line parameter, 8-10
DIRECT command-line parameter, 6-5
direct path method, 3-15
DISCARD command-line parameter, 6-5
discard file, 3-14
discarded records, 3-12
DISCARDFILE keyword, 5-28
DISCARDMAX command-line parameter, 6-5
DISCARDMAX keyword, 5-29
DISCARDS keyword, 5-29
errors caused by tabs, 5-49
ERRORS command-line parameter, 6-5
example sessions, 4-1
exclusive access, 8-25
FILE command-line parameter, 6-6
filenames, 5-18
index options, 5-43
inserting rows into tables, 5-33
INTO TABLE statement, 5-39
LOAD command-line parameter, 6-6
load methods, 8-2
loading data contained in the control file, 5-53
loading LONG data, 5-63
LOG command-line parameter, 6-6
log file datafile information, 7-3
log file entries, 7-1
log file header information, 7-2
log file summary statistics, 7-4
log file table information, 7-3
log file table load information, 7-4
log files, 3-14
methods for loading data into tables, 5-32
methods of loading data, 3-15
multiple INTO TABLE statements, 5-50
National Language Support, 5-30
object names, 5-18
PARALLEL command-line parameter, 6-6
parallel data loading, 8-26, 8-30
parallel loading, 8-27
PARFILE command-line parameter, 6-6
preparing tables for case studies, 4-4
READBUFFERS keyword, 5-24
rejected records, 3-12
replacing rows in tables, 5-33
required privileges, 3-15
reserved words, A-2
ROWS command-line parameter, 6-7
SILENT command-line parameter, 6-8
SINGLEROW index keyword, 5-43
SKIP command-line parameter, 6-9
SKIP keyword, 5-35
SORTED INDEXES during direct path loads, 5-43
specifying columns, 5-46
specifying datafiles, 5-22
specifying field conditions, 5-44
specifying fields, 5-46
specifying more than one data file, 5-23
suppressing messages, 6-8
updating rows, 5-33
USERID command-line parameter, 6-9
SQL*Loader log file
global information, 7-2
SQL*Net See Net8
SQL/DS option (DB2 file format)
not supported by SQL*Loader, B-4
STATISTICS
Export parameter, 1-23
statistics, 2-63
specifying for Export, 1-23, 2-27
STORAGE keyword, 8-29
storage parameters, 2-52
estimating export requirements, 1-9
exporting tables, 1-16
OPTIMAL parameter, 2-53
overriding
Import, 2-53
preallocating
direct path load, 8-16
temporary for a direct path load, 8-11
stored functions
importing, 2-61
stored packages
importing, 2-61
stored procedures
direct path load, 8-24
importing, 2-61
stream record format, 5-90
stream record format records, 3-6
string comparisons, 5-15
SQL*Loader, 5-46
synonyms
direct path load, 8-9
Export, 1-49
syntax
Export command, 1-10
Import command, 2-7
syntax diagrams
SQL*Loader, 5-4
SYSDATE datatype
example, 4-28
SYSDATE keyword
SQL*Loader, 5-55
SYSDBA, 1-36
SYS.INCEXP table
Export, 1-51
SYS.INCFIL table
Export, 1-51
SYS.INCVID table
Export, 1-52
system objects
importing, 2-13
system tables
incremental export, 1-50

T

table-level Export, 1-8
table-level Import, 2-33
table-mode Export
specifying, 1-24
table-mode Import
examples, 2-35
Tables, 2-63
tables
advanced queue (AQ)
exporting, 1-57
advanced queue (AQ) importing, 2-61
appending rows with SQL*Loader, 5-32
continuing a multiple table load, 5-34
continuing a single table load, 5-34
defining before Import, 2-14
definitions
creating before import, 2-14
exclusive access during direct path loads
SQL*Loader, 8-25
exporting
specifying, 1-24
importing, 2-28
insert triggers
direct path load, 8-22
inserting rows using SQL*Loader, 5-33
loading data into more than one table using SQL*Loader, 5-50
loading data into tables, 5-32
loading object tables, 5-95
maintaining consistency, 1-17
manually ordering for import, 2-15
master table
Import, 2-51
name restrictions
Export, 1-25
Import, 2-28
nested
exporting, 1-57
importing, 2-59
object import order, 2-4
partitioned, 1-8, 2-5
partitioned in DB2
no Oracle equivalent, B-4
replacing rows using SQL*Loader, 5-33
size
USER_SEGMENTS view, 1-9
specifying table-mode Export, 1-24
SQL*Loader method for individual tables, 5-40
system
incremental export, 1-50
truncating
SQL*Loader, 5-33
updating existing rows using SQL*Loader, 5-33
TABLES parameter
Export, 1-24
Import, 2-28
tablespace metadata
transporting, 2-31
tablespaces
dropping during import, 2-54
Export, 1-49
read-only
Import, 2-54
reorganizing
Import, 2-54
TABLESPACES parameter, 2-29
tabs
loading data files containing tabs, 5-49
trimming, 5-81
whitespace, 5-81
temporary segments, 8-28
FILE keyword
SQL*Loader, 8-29
not exported during backup, 1-49
temporary storage in a direct path load, 8-11
TERMINATED BY, 5-16
SQL*Loader, 5-69
WHITESPACE
SQL*Loader, 5-69
with OPTIONALLY ENCLOSED BY, 5-83
terminated fields
specified with a delimiter, 5-83
specified with delimiters and SQL*Loader, 5-69
TOID_NOVALIDATE parameter, 2-30
TOUSER
Import parameter, 2-31
trailing blanks
loading with delimiters, 5-72
TRAILING NULLCOLS
example, 4-28
SQL*Loader keyword, 5-42
trailing whitespace
trimmingr, 5-85
TRANSPORT_TABLESPACE parameter, 2-31
transportable tablespaces, 2-63
triggers
, 8-23
database insert triggers
, 8-22
permanently disabled
, 8-25
update triggers
SQL*Loader, 8-23
trimming
summary, 5-86
VARCHAR fields, 5-82
trimming trailing whitespace
SQL*Loader, 5-85
TTS_OWNERS parameter, 2-31
TYPE# column
SYS.INCEXP table, 1-51

U

unique indexes
Import, 2-25
unique values
generating with SQL*Loader, 5-55
uniqueness constraints
Import, 2-48
preventing errors during import, 2-20
UNLOAD (DB2 file format)
not supported by SQL*Loader, B-4
UNRECOVERABLE keyword
SQL*Loader, 8-19
unsorted data
direct path load
SQL*Loader, 8-17
updating rows in a table
SQL*Loader, 5-33
user definitions
importing, 2-14
USER_SEGMENTS view
Export and, 1-9
USERID
Export parameter, 1-26
Import parameter, 2-32
SQL*Loader command-line parameter, 6-9
user-mode Export
specifying, 1-21

V

VARCHAR datatype, 5-58
SQL*Loader, 5-61
trimming whitespace, 5-82
VARCHAR2 datatype, 2-65
SQL*Loader, 5-69
VARCHARC, 5-67
VARGRAPHIC datatype
SQL*Loader, 5-60
variable record format, 5-91
variable records, 3-6
VARRAW, 5-62
VARRAWC, 5-67
VARRAYs
example, 4-44
views
creating views necessary for Export, 1-9
Export, 1-49
VOLSIZE, 1-27
VOLSIZE parameter, 2-32

W

warning messages, 1-39
WHEN clause
example, 4-19
SQL*Loader, 5-40, 5-44
SQL*Loader discards resulting from, 5-29
WHITESPACE, 5-16
whitespace
included in a field, 5-84
leading, 5-81
terminating a field, 5-84
trailing, 5-81
trimming, 5-81
WHITESPACE keyword
SQL*Loader, 5-69

Z

ZONED datatype, 5-59
EXTERNAL format
SQL*LOader, 5-66
length versus precision, 5-16


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents