Oracle9i Database Utilities
Release 1 (9.0.1)

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

Master Index

Feedback

Go to previous page

Index

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


A

access privileges
Export, 1-5
Import, 2-5
Advanced Queuing
exporting advanced queue tables, 1-55
importing advanced queue tables, 2-60
aliases
directory
exporting, 1-54
importing, 2-58
analyzer statistics, 2-67
APPEND parameter
for SQL*Loader utility, 5-37
append to table
example, 10-11
SQL*Loader, 5-32
archiving
disabling
effect on direct path loads, 9-18
arrays
committing after insert, 2-19
atomic null, 7-7
attributes
null, 7-6

B

backslash escape character, 5-6
backups
restoring dropped snapshots
Import, 2-63
bad files
specifying for SQL*Loader, 5-11
BAD parameter
for SQL*Loader command line, 4-3
BADDN parameter
for SQL*Loader utility, 5-11
BADFILE parameter
for SQL*Loader utility, 5-11
BEGINDATA parameter
for SQL*Loader control file, 5-10
BFILE columns
exporting, 1-54
importing, 2-58
BFILE datatype, 7-17
big endian data
external tables, 12-6
bind arrays
determining size of for SQL*Loader, 5-44
minimizing SQL*Loader memory requirements, 5-47
minimum requirements, 5-43
size with multiple SQL*Loader INTO TABLE statements, 5-48
specifying maximum size, 4-4
specifying number of rows, 4-10
SQL*Loader performance implications, 5-43
BINDSIZE parameter
for SQL*Loader command line, 4-4, 5-43
blanks
loading fields consisting of blanks, 6-41
SQL*Loader BLANKS parameter for field comparison, 6-30
trailing, 6-27
trimming, 6-41
external tables, 12-15
whitespace, 6-41
BLANKS parameter
for SQL*Loader utility, 6-30
bound fillers, 6-6
BUFFER parameter
for Export utility, 1-15
for Import utility, 2-18
buffers
calculating for export, 1-15
space required by
VARCHAR data in SQL*Loader, 6-13
specifying with SQL*Loader BINDSIZE parameter, 5-44
byte order, 6-36
big endian, 6-36
little endian, 6-36
specifying in SQL*Loader control file, 6-37
byte order marks, 6-38
precedence
for first primary datafile, 6-38
for LOBFILEs and SDFs, 6-40
suppressing checks for, 6-40
BYTEINT datatype, 6-8 to 6-10
BYTEORDER parameter
for SQL*Loader utility, 6-38
BYTEORDERMARK parameter
for SQL*Loader utility, 6-40

C

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

D

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

E

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

F

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

G

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

H

HELP parameter
for Export utility, 1-12, 1-21
for Import utility, 2-23
hexadecimal strings
SQL*Loader, 6-31

I

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

K

key values
generating with SQL*Loader, 6-56

L

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

M

master table
snapshots
Import, 2-62
materialized views, 2-62
media recovery
direct path load, 9-13
messages
Export
completion, 1-46
nonrecoverable, 1-46
warning, 1-46
Import
completion, 2-46
nonrecoverable, 2-45
warning, 2-45
missing data columns
SQL*Loader, 5-35
multibyte character sets
blanks with SQL*Loader, 6-31
Export and Import issues, 1-52, 2-55
SQL*Loader, 5-17
multiple-column indexes
SQL*Loader, 9-17
multiple-CPU systems
optimizing direct path loads, 9-20
multiple-table load
discontinued, 5-24
generating unique sequence numbers using SQL*Loader, 6-57
SQL*Loader control file specification, 5-37
multithreading
on multiple-CPU systems, 9-20
MULTITHREADING parameter
for SQL*Loader command line, 4-8

N

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

O

object identifiers, 7-8
importing, 2-55
object names
SQL*Loader, 5-5
object support, 3-15
object tables
loading, 7-8
with a subtype
loading, 7-10
object type definitions
exporting, 1-54
objects, 3-13
considerations for importing, 2-55
creation errors, 2-48
ignoring existing objects during import, 2-23
import creation errors, 2-23
loading nested column objects, 7-4
NULL values, 7-6
stream record format, 7-2
variable record format, 7-3
offline bitmapped tablespaces
exporting, 1-54
OID. See object identifiers
online help
Export, 1-12
Import, 2-14
operating systems
moving data to different systems using SQL*Loader, 6-35
OPTIMAL storage parameter
for Import utility, 2-65
optimizer statistics, 2-67
optimizing
direct path loads, 9-15
SQL*Loader input file processing, 5-11
OPTIONALLY ENCLOSED BY clause
SQL*Loader, 6-45
OPTIONS parameter
for parallel loads, 5-33
for SQL*Loader utility, 5-4
Oracle Advanced Queuing. See Advanced Queuing
Oracle Net
using to export over a network, 1-50
Oracle Version 6
exporting database objects, 2-70
OWNER parameter
for Export utility, 1-22

P

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

Q

QUERY parameter
for Export utility, 1-22
restrictions, 1-23
quotation marks
escaping, 5-6
filenames, 5-6
SQL string, 5-5
table names and, 1-27, 2-30
use with database object names, 5-5

R

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

S

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

T

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

U

UNIQUE KEY constraints
effect on direct path load, 9-32
unique values
generating with SQL*Loader, 6-56
uniqueness constraints
preventing errors during import, 2-19
UNLOAD statement (DB2 file format)
not supported by SQL*Loader, B-3
UNRECOVERABLE parameter
SQL*Loader, 9-19
unsorted data
direct path load
SQL*Loader, 9-17
updating
rows in a table
SQL*Loader, 5-32
user definitions
importing, 2-70
user mode export, 1-8
specifying, 1-22
USER_SEGMENTS view
Export and, 1-4
USERID parameter
for Export utility, 1-29
for Import utility, 2-33
for SQL*Loader command line, 4-13

V

VARCHAR datatype, 6-8
SQL*Loader, 6-13
VARCHAR2 datatype, 2-70
SQL*Loader, 6-22
VARCHARC datatype
SQL*Loader, 6-20
VARGRAPHIC datatype
SQL*Loader, 6-11
variable records, 3-5
format, 7-3
variable-length records
external tables, 12-4
VARRAW datatype, 6-14
VARRAWC datatype, 6-21
VARRAY columns
memory issues when loading, 7-29
VOLSIZE parameter
for Export utility, 1-30
for Import utility, 2-33

W

WHEN clause
example, 10-19
SQL*Loader, 5-33, 6-28
SQL*Loader discards resulting from, 5-15
whitespace
included in a field, 6-46
leading, 6-43
preserving, 6-48
terminating a field, 6-24, 6-46
trimming, 6-41
WHITESPACE parameter
SQL*Loader, 6-24

X

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

Z

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

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

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

Master Index

Feedback