Index

backslash escape character, 5-20

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

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

determining size of for SQL*Loader, 5-76

BFILE datatype, 5-106

BFILEs

loading, 5-98

bind array

determining size, 5-74

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

BLANKS keyword

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

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 Import, 2-7

CATEXP7.SQL

preparing database for Export, 1-60

CATEXP.SQL

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

trimming whitespace, 5-82

character datatypes

conflicting fields, 5-72

character fields

datatypes

delimiters and SQL*Loader, 5-69

determining length for SQL*Loader, 5-72

specified with delimiters

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

CHARACTERSET keyword

check constraints

CLOBs

clusters

column naming

column objects

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

specifying defaults, 5-18

command-line parameters

description, 6-2

Export, 1-14

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

specifying, 1-20

completion messages

Export parameter, 1-16, 2-53

COMPRESS

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

disabling during a direct load, 8-21

direct path load, 8-21

disabling referential constraints, 2-14

enabling after a direct load, 8-21

enforced on a direct load, 8-21

failed

load method, 8-9

not null

preventing Import errors due to uniqueness constraints, 2-20

referential integrity

uniqueness

SQL*Loader command-line parameter, 6-4

CONTINUE_LOAD keyword

SQL*Loader, 5-35

CONTINUEIF keyword

example, 4-15

SQL*Loader, 5-36

continuing interrupted loads

SQL*Loader, 5-34

CONTROL

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

cumulative exports, 1-44, 1-46

recording, 1-23

specifying, 1-20

SYS.INCFIL table, 1-51

custom record separator, 3-18

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

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

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

DISCARDDN keyword, 5-28

EXCEPTIONS keyword

expanded syntax diagrams, 5-15

EXTERNAL keyword, 5-66

field_condition, 5-15

FILE keyword

loading data in sections

parallel keyword

POSITION keyword, 5-48

precision, 5-16

RECNUM keyword, 5-46

REENABLE keyword

SQL*Loader CHARACTERSET keyword, 5-31

SEQUENCE keyword, 5-55

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

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

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

RECORDLENGTH parameter, 1-43

direct path export, 1-41

BUFFER parameter, 1-43

character set and, 1-53

invoking, 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

loading into synonyms, 8-9

indexes, 8-10

instance recovery, 8-13

partitioned load

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

DISABLED_CONSTRAINTS keyword

DISCARD

different placement from DB2, B-3

discard file

basics, 3-14

DISCARDDN keyword

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 discarded records, 5-30

DISCARDMAX keyword

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

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

enclosure delimiters

error handling

error messages

caused by tab characters in SQL*Loader data, 5-49

Export, 1-39

export log file, 1-21

fatal errors

generated by DB2 load utility, B-3

row errors during import, 2-47

warning errors

Export, 1-39

ERRORS

errors

fatal

Import resource errors, 2-49

Import, 2-49

LONG data, 2-48

object creation

Import parameter IGNORE, 2-24

object creation errors, 2-48

warning

escape character

ESTIMATE option

STATISTICS Export parameter, 1-23

EXCEPTIONS keyword

EXP_FULL_DATABASE role, 1-20, 2-11

assigning, 1-9

Export, 1-4

EXPDAT.DMP

Export output file, 1-19

EXPID column

Export

base backup, 1-44

BUFFER parameter, 1-16

CATALOG.SQL

preparing the database for Version 7 export, 1-60

CATEXP7.SQL

CATEXP.SQL

complete, 1-20, 1-44, 1-46

command line, 1-10

privileges, 1-44

CONSISTENT parameter, 1-17

COMPRESS parameter, 1-16

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

database optimizer statistics, 1-23, 2-27

data structures, 1-48

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

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

logging error messages, 1-21

log files

specifying, 1-21

LOG parameter, 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.INCFIL table, 1-51

table name restrictions, 1-25

table mode

example, 1-31

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

FLOAT

GRAPHIC

numeric

determining length, 5-72

ZONED

external files

EXTERNAL keyword

external LOBS

external LOBs (BFILE), 5-106

fatal errors

specifying for SQL*Loader, 5-44

Import, 2-48, 2-49

FEEDBACK

Export parameter, 1-19

Import parameter, 2-22

field conditions

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

specifying multiple SQL*Loader, 5-23

FILE columns

Import, 2-60

FILE keyword, 8-29

filenames

quotation marks, 5-19

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

FLOAT EXTERNAL data values

FLOAT keyword

foreign function libraries

exporting, 1-55

not allowed by SQL*Loader, B-4

FORMAT statement in DB2

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

full database mode

Import, 2-23

full field names, 3-22

GRANTS

GRAPHIC EXTERNAL datatype, 5-58

Import parameter, 2-23

grants

exporting, 1-20

importing, 2-13, 2-23

GRAPHIC datatype, 5-58

EXTERNAL format

SQL*Loader, 5-65

HELP

as part of a field comparison, 5-15

Import parameter, 2-24

help

Export, 1-11

Import, 2-9

hexadecimal strings

Import parameter, 2-24, 2-57

IGNORE

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

session example, 1-49

specifying, 1-20

SYS.INCFIL table, 1-51

incremental import

parameter, 2-25

specifying, 2-25

INCTYPE

SORTED INDEXES with SQL*Loader, 5-43

Import parameter, 2-25

index options

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

multiple column

state after discontinued load, 5-34

presorting data, 4-25

SQL*Loader, 8-16

skipping unusable, 2-28

SQL*Loader, 5-43

unique, 2-25

INDEXFILE

Import parameter, 2-26

INFILE keyword

insert errors

INSERT into table

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

multiple statements with SQL*Loader, 5-50

discards

SQL*Loader, 5-29

SQL*Loader, 5-39

invalid data

invalid objects

warning messages

during export, 1-39

invoking Export, 1-10

direct path, 1-43

ITIME column

generating with SQL*Loader, 5-55

key values

key words, A-2

keywords, STORAGE, 8-29

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

LOAD

variable-length data, 4-5

loading

datafiles containing tabs

SQL*Loader, 5-49

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

specifying for SQL*Loader, 6-6

log file

log files

after a discontinued load, 5-34

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

loading with direct path load, 8-14

LONG VARRAW, 5-62

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

NAME column

transporting Export files across a network, 1-52

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

NCHAR data

NCLOBs

negative numbers

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

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

missing columns at end of record during load, 5-42

load method, 8-9

null columns

at end of record, 5-81

null data

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

nulls

NUMBER datatype

numeric EXTERNAL datatypes

delimited form and SQL*Loader, 5-69

determining length, 5-72

trimming whitespace, 5-82

trimming, 5-82

numeric fields

precision versus length, 5-16

object identifiers, 2-57

object names

object tables

object type definitions

object type identifiers, 2-30

importing, 2-58

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

packed decimal data, 5-16

padding of literal strings

PARALLEL

PARALLEL command-line parameter, 6-6

PARALLEL keyword

SQL*Loader, 8-27

parallel loads

allocating extents, 6-6

parameter file

maximum size

parameteres

parameters

BUFFER

COMMIT

conflicts between export parameters, 1-27

CONSTRAINTS

DESTROY

DIRECT

FEEDBACK

FILE

FROMUSER

FULL

GRANTS

HELP

IGNORE

INCTYPE

INDEXES

INDEXFILE

LOG, 1-39

OWNER

PARFILE

RECORD

RECORDLENGTH

ROWS

SHOW

SKIP_UNUSABLE_INDEXES

STATISTICS

TABLES

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

not allowed by SQL*Loader, B-4

PART statement in DB2

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