Oracle9i Database Utilities -- Index

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

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

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

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

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

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

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

HELP parameter

for Export utility, 1-12, 1-21

for Import utility, 2-23

hexadecimal strings

SQL*Loader, 6-31

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

key values

generating with SQL*Loader, 6-56

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

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

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

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

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

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

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

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

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

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

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

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

XML columns

loading, 7-13

treatment by SQL*Loader, 7-13

ZONED datatype, 6-10

EXTERNAL format

SQL*Loader, 6-19