Oracle8(TM) Server -- Index

advanced queue (AQ) tables

exporting, 1-49

aliases

directory

ANALYZE

Import parameter, 2-16

APPEND keyword

SQL*Loader, 5-28, 5-40

APPEND to table

example, 4-9

AQ (advanced queue) tables

exporting, 1-49

arrays

committing after insert

Import, 2-17

exporting, 1-48

ASCII

fixed-format files

exporting, 1-3

ASCII character set

SQL*Loader command-line parameter, 6-3

backslash (\)

escape character in quoted strings

SQL*Loader, 5-14

quoted filenames and

SQL*Loader, 5-15

backups

restoring dropped snapshots

Import, 2-50

BAD

bad file

rejected records

specifying

BADDN keyword

BADFILE keyword

base backup

base tables

incremental export and, 1-40

BEGINDATA

control file keyword

BFILE columns

exporting, 1-48

bind array

determining size

SQL*Loader, 5-69

determining size of

SQL*Loader, 5-71

minimizing memory requirements

SQL*Loader, 5-73

minimum requirements

SQL*Loader, 5-69

no space required for generated data

performance implications

size with multiple INTO TABLE clauses

specifying number of rows

conventional path load

SQL*Loader, 6-6

specifying size

SQL*Loader, 6-4

BINDSIZE

BINDSIZE command-line parameter

blanks

BLANKS keyword for field comparison

SQL*Loader, 5-9, 5-42

loading fields consisting of blanks

calculating for export, 1-13

preserving

SQL*Loader, 5-81

trailing

loading with delimiters

trimming

whitespace

BLANKS keyword

BUFFER

Export parameter, 1-13

direct path export, 1-33, 1-35

Import parameter, 2-16

buffers

calculating for import, 2-16

space required by

LONG DATA

SQL*Loader, 5-62

VARCHAR data

SQL*Loader, 5-60

specifying with BINDSIZE parameter

SQL*Loader, 5-71

BYTEINT datatype, 5-55

specification

SQL*Loader, 5-56

cached sequence numbers

Export, 1-47

case studies

SQL*Loader, 4-1

associated files, 4-3

file names, 4-3

preparing tables, 4-4

CATALOG.SQL

preparing database for Import, 2-7

CATEXP.SQL

preparing database for Import, 2-7

CATEXP7.SQL

preparing database for Export, 1-51

CATLDR.SQL

setup script

SQL*Loader, 8-9

CHAR columns

Version 6 export files, 2-62

CHAR datatype

delimited form

reference

specification

trimming whitespace

character datatypes

conflicting fields

character fields

datatypes

delimiters

determining length

specified with delimiters

character sets

conversion between

during Export/Import, 1-45, 2-54

direct path export, 1-34, 1-45

eight-bit to seven-bit conversions

Export/Import, 1-46, 2-54

multi-byte

Export/Import, 1-46, 2-55

NCHAR data

Export, 1-46

single-byte

Export/Import, 1-46, 2-54

Version 6 conversions

Import/Export, 2-55

character strings

as part of a field comparison

SQL*LOader, 5-9

padded

when shorter than field

CHARACTERSET keyword

SQL*Loader, 5-27

CHARSET

Import parameter, 2-17

check constraints

clusters

Export, 1-41

columns

end of a field

exporting LONG datatypes, 1-47

naming

SQL*Loader, 5-41, 5-43

null columns at the end of a record

reordering before Import, 2-13

setting to a constant value

SQL*Loader, 5-50

setting to a unique sequence number

setting to datafile record number

setting to null

setting to null value

setting to the current date

setting value to zero

specifiying as PIECED

specifying

starting position of a field

in Export parameter file, 1-10

combining partitions, 2-29

command-line parameters

description

specifying defaults

Comments

in Import parameter file, 2-10

in SQL*Loader control file, 4-10

COMMIT

Import parameter, 2-17

complete exports, 1-36, 1-38

STATISTICS Export parameter, 1-20

specifying, 1-17

completion messages

Export, 1-32

COMPRESS

Export parameter, 1-13, 2-51

COMPUTE option

CONCATENATE keyword

concurrent conventional path loads, 8-25

connect string

Net8, 1-44

CONSISTENT

Export parameter, 1-14

nested table and, 1-14

partitioned table and, 1-14

consolidating extents

Export parameter COMPRESS, 1-13

CONSTANT keyword

no space used in bind array

SQL*Loader, 5-43, 5-50

CONSTRAINTS

Export parameter, 1-15

constraints

automatic

SQL*Loader, 8-23

check

disabling during a direct load, 8-21

direct path load, 8-21

disabling referential constraints

Import, 2-13

enabling after a direct load, 8-21

enforced on a direct load, 8-21

failed

load method

SQL*Loader, 8-8

not null

preventing Import errors due to uniqueness constraints, 2-18

referential integrity

uniqueness

continuation fields

CONTINUE_LOAD keyword

CONTINUEIF keyword

example

continuing interrupted loads

CONTROL

control files

CONTROL

creating

data definition language syntax

SQL*Loader, 5-4

data definitions

basics

definition

editing

field delimiters

guidelines for creating

SQL*Loader, 3-5

location

SQL*Loader, 3-5

specifying data

compared to direct path Export, 1-32

specifying discard file

SQL*Loader, 5-23

storing

SQL*Loader, 3-5

conventional path Export

conventional path loads

basics, 8-2

bind array

compared to direct path loads, 8-7

using, 8-3

CREATE SESSION privilege

CREATE USER command

Import, 2-12

CTIME column

cumulative exports, 1-36, 1-37

recording, 1-18

specifying, 1-17

DATA

data

binary versus character format

delimiter marks in data

SQL*Loader, 5-66

distinguishing different input formats

enclosed

formatted data

generating unique values

including in control files

loading in sections

loading into more than one table

loading LONG

SQL*Loader, 5-62

loading without files

SQL*Loader, 5-50

mapping to Oracle format

maximum length of delimited data

saving in a direct path load, 8-12

methods of loading into tables

SQL*Loader, 5-27

moving between operating systems

SQL*Loader, 5-68

saving rows

terminated

SQL*Loader, 3-11

unsorted

values optimized for performance

SQL*Loader, 5-50

data conversion

description

SQL*Loader, 3-11

data definition language

APPEND keyword, 5-28

basics

BEGINDATA keyword, 5-17

BLANKS keyword

CHARACTERSET keyword, 5-27

column_name

SQL*Loader, 5-9

CONCATENATE keyword, 5-32

CONSTANT keyword, 5-43, 5-50

CONTINUEIF keyword, 5-32

datatype_spec

date mask

DEFAULTIF keyword

delimiter_spec

description

DISABLED_CONSTRAINTS keyword

DISCARDDN keyword, 5-24

DISCARDMAX keyword

example definition

SQL*Loader, 3-6

EXCEPTIONS keyword

EXTERNAL keyword, 5-64

field_condition

FILE keyword

length

loading data in sections

NULLIF keyword

parallel keyword

pos_spec

POSITION keyword, 5-44

precision

RECNUM keyword, 5-43

REENABLE keyword

data definition language (DDL), 3-4

reference

keywords and parameters

SQL*Loader, 5-1

REPLACE keyword, 5-28

SEQUENCE keyword, 5-52

syntax diagrams

expanded

SQL*Loader, 5-8

high-level

SQL*Loader, 5-5

syntax reference

SQL*Loader, 5-1

SYSDATE keyword, 5-51

TERMINATED keyword, 5-64

TRUNCATE keyword, 5-28

UNRECOVERABLE keyword

SQL*Loader, 8-19

WHITESPACE keyword, 5-64

data field

specifying the datatype

data mapping

concepts

direct and conventional, 8-2

data path loads

data recovery

direct path load

SQL*Loader, 8-13

database administrator (DBA)

privileges for export, 1-4

database objects

export privileges, 1-4

exporting all, 1-5

exporting LONG columns, 1-47

transferring across a network

Import, 2-48

databases

data structure changes

incremental export and, 1-40

full export, 1-16

full import, 2-20

importing into secondary

Import, 2-18

incremental export, 1-36

preparing for Export, 1-7

preparing for Import, 2-7

privileges for exporting, 1-4

privileges for importing, 2-10

reducing fragmentation via full export/import, 2-44

reusing existing data files

Import, 2-18

datafiles

preventing overwrite during import, 2-18

reusing during import, 2-18

specifying

SQL*Loader, 5-17, 6-4

specifying buffering

specifying format

storage

conflicting character datatype fields, 5-67

datatypes

BFILE

CHAR, 5-62

converting

SQL*Loader, 3-11, 5-54

DATE, 5-62

determining length, 5-68

default

determining character field lengths

FLOAT, 5-56

GRAPHIC EXTERNAL, 5-58

LONG

MLSLABEL

Trusted Oracle7 Server, 5-63

native

conflicting length specifications

inter-operating system transfer issues, 5-69

SQL*Loader, 3-10, 5-55

NUMBER

SQL*Loader, 5-54

numeric EXTERNAL, 5-63

trimming

RAW, 5-58

specifications

specifying

specifying the datatype of a data field

VARCHAR2

ZONED, 5-56

DATE datatype

delimited form

determining length

mask

specification

trimming whitespace

date mask

DB2 Load utility

use with SQL*Loader, 3-4

DB2 load utility, B-1

different placement of statements

DISCARDDDN, B-4

DISCARDS, B-4

restricted capabilities of SQL*Loader, B-5

RESUME keyword

SQL*Loader equivalents, 5-28

SQL*Loader compatibility

ignored statements, B-4

DBA role

EXP_FULL_DATABASE role, 1-7

DBCS (DB2 double-byte character set)

not supported by Oracle, B-5

DDL, 3-6

SQL*Loader data definition language, 3-4

DECIMAL datatype

EXTERNAL format

trimming whitespace

length and precision

specification

DEFAULT column values

Oracle Version 6 export files, 2-63

DEFAULTIF keyword

field condition

DELETE ANY TABLE privilege

DELETE CASCADE

DELETE privilege

delimited data

maximum length

delimited fields

field length

delimited files

delimiter_spec

delimiters

control files

enclosure

field specifications

initial and trailing

loading trailing blanks

marks in data

SQL*Loader, 5-66

optional enclosure

specifying

SQL*Loader, 5-38, 5-64

termination

DESTROY

Import parameter, 2-18

DIRECT

Export parameter, 1-15, 1-33

RECORDLENGTH parameter, 1-35

direct path export, 1-32

BUFFER parameter, 1-35

character set and, 1-45

invoking, 1-33

performance, 1-35

direct path load

, 8-10

advantages, 8-6

case study, 4-20

choosing sort order

compared to convetional path load, 8-7

conditions for use, 8-8

data saves, 8-12, 8-18

DIRECT

DISABLED_CONSTRAINTS keyword, 8-21

DIRECT command line parameter

SQL*Loader, 8-9

disabling media protection

dropping indexes, 8-20

to continue an interrupted load

EXCEPTIONS keyword, 8-22

field defaults, 8-9

improper sorting

preallocating storage, 8-16

indexes, 8-10

instance recovery, 8-13

loading into synonyms, 8-9

partitioned load

performance issues, 8-10

presorting data, 8-16

recovery, 8-13

REENABLE keyword, 8-21

referential integrity constraints, 8-21

ROWS command line parameter, 8-12

setting up, 8-9

specifying, 8-9

specifying number of rows to be read

SQL*Loader, 6-6

SQL*Loader data loading method, 3-17

table insert triggers, 8-22

temporary segment storage requirements, 8-10

triggers, 8-21

using, 8-7, 8-9

version requirements, 8-9

directory aliases

DISABLED_CONSTRAINTS keyword

DISCARD

different placement from DB2, B-4

discard file

basics

SQL*Loader, 3-14

DISCARDDN keyword

DISCARDFILE keyword

DISCARDMAX keyword

DISCARDS control file clause

different placement from DB2, B-4

DISCARDS keyword

DISCRDMAX keyword

SQL*Loader, 5-23

discarded records

causes

discard file

limiting the number

DISCARDMAX

DISCARDMAX keyword

discarded records

discontinued loads

continuing

DOUBLE datatype, 5-55

specification

SQL*Loader, 5-56

dropped snapshots

Import, 2-50

dropping

indexes

to continue a direct path load

SQL*LOader, 5-30

EBCDIC character set

eight-bit character set support, 1-46, 2-54

enclosed fields

and SQL*Loader, 3-11

ENCLOSED BY control file clause

specified with enclosure delimiters

whitespace in

enclosure delimiters

initial

trailing

ending column of a field

error handling

Import, 2-45

error messages

caused by tab characters in data

SQL*Loader, 5-45

export log file, 1-18

fatal errors

generated by DB2 load utility, B-5

row errors during import, 2-45

warning errors

ERRORS

errors

fatal

Import resource errors, 2-47

Import, 2-47

LONG data, 2-46

object creation

Import parameter IGNORE, 2-21

object creation errors, 2-46

warning

escape character

quoted strings

ESTIMATE option

STATISTICS Export parameter, 1-20

EXCEPTIONS keyword

EXP_FULL_DATABASE role, 1-16

assigning, 1-7

full database mode, 1-5

EXPDAT.DMP

Export output file, 1-16

EXPDATE column

EXPFILE column

EXPID column

Export

base backup, 1-36

BUFFER parameter, 1-13

CATALOG.SQL

CATEXP.SQL

preparing the database for Version 7 export, 1-51

CATEXP7.SQL

command line, 1-8

complete, 1-17, 1-36, 1-38

privileges, 1-36

CONSTRAINTS parameter, 1-15

COMPRESS parameter, 1-13

concept, 1-3

CONSISTENT parameter, 1-14

creating necessary privileges, 1-7

creating Version 7 export files, 1-50

cumulative, 1-17, 1-36, 1-37

privileges required, 1-36

database optimizer statistics, 1-20

data structures, 1-40

DIRECT parameter, 1-15

direct path, 1-32

displaying help message, 1-17

eight-bit vs. seven-bit character sets, 1-46

establishing export views, 1-7

examples, 1-22

full database mode, 1-22

partition-level, 1-27

table mode, 1-25

user mode, 1-24

exporting all schema objects, 1-4

exporting an entire database, 1-16

exporting indexes, 1-17

exporting objects owned by SYS, 1-5

exporting sequence numbers, 1-47

exporting to another operating system

RECORDLENGTH parameter, 1-19

FEEDBACK parameter, 1-16

FILE parameter, 1-16

full database mode, 1-4

example, 1-22

FULL parameter, 1-16

GRANTS parameter, 1-16

HELP parameter, 1-17

incremental, 1-17, 1-36

INCTYPE parameter, 1-17

INDEXES parameter, 1-17

interactive method, 1-8, 1-29

invoking, 1-8

kinds of data exported, 1-40

last valid export

logging error messages, 1-18

log files

specifying, 1-18

LOG parameter, 1-18

LONG columns, 1-47

message log file, 1-31

modes, 1-4

multi-byte character sets, 1-46

network issues, 1-44

NLS support, 1-46

NLS_LANG environment variable, 1-46

objects exported, 1-5

objects owned by SYS, 1-5

online help, 1-9

OWNER parameter, 1-18

parameter conflicts, 1-22

parameter file, 1-8, 1-10, 1-18

maximum size, 1-10

parameters, 1-11

PARFILE parameter, 1-8, 1-10, 1-18

POINT_IN_TIME_RECOVER, 1-18

preparing database, 1-7

previous versions, 1-50

RECORD parameter, 1-18

RECORDLENGTH parameter, 1-19

RECOVERY_TABLESPACES parameter, 1-19

redirecting output to a log file, 1-31

remote operation, 1-44

restrictions, 1-4

rollback segments, 1-41

ROWS parameter, 1-19

sequence numbers, 1-47

STATISTICS parameter, 1-20

storage requirements, 1-8

table name restrictions, 1-21

table mode, 1-4

example, 1-25

TABLES parameter, 1-20

tracking exported objects, 1-42

tracking table for incremental export, 1-17

transferring export files across a network, 1-44

unclustered tables and, 1-4

user access privileges, 1-4

user mode, 1-4

examples, 1-24

specifying, 1-18

USER_SEGMENTS view, 1-8

USERID parameter, 1-22

using, 1-7

warning messages, 1-31

export file

displaying contents, 1-3

format, 1-3

importing the entire file, 2-20

listing contents before importing, 2-24

reading, 1-3

specifying, 1-16

EXPTYPE column

EXPUSER column

SQL*Loader command line parameter, 6-5

extent allocation

FILE

extents

consolidating into one extent

Export, 1-13

importing consolidated, 2-51

EXTERNAL datatypes

DECIMAL

FLOAT

GRAPHIC

numeric

determining length

trimming

ZONED

external files

EXTERNAL keyword

fatal errors

FEEDBACK

Import parameter, 2-19

field conditions

specifying

field length

specifications

fields

and SQL*Loader, 3-11

character

data length

comparing

SQL*Loader, 5-9

comparing to literals

continuation

DECIMAL EXTERNAL

trimming whitespace

delimited

determining length

specifications

enclosed

FLOAT EXTERNAL

trimming whitespace

INTEGER EXTERNAL

trimming whitespace

length of

SQL*Loader, 5-11, 5-44

loading all blanks

location

numeric and precision versus length

numeric EXTERNAL

trimming whitespace

precision

predetermined size

length

relative positioning

SQL*Loader, 5-78

specification of position

SQL*Loader, 5-8

specified with a termination delimiter

specified with enclosure delimiters

SQL*Loader, 3-11, 5-65

specifying

specifying default delimiters

terminated

VARCHAR

never trimmed

ZONED EXTERNAL

trimming whitespace

FIELDS clause

terminated by whitespace

SQL*Loader, 5-79

FILE

Import parameter, 2-19

keyword

SQL*Loader, 8-28

FILE columns

Import, 2-59

filenames

bad file

datafile

SQL*Loader, 5-18

quotation marks

SQL*Loader, 5-14

specifying more than one

SQL*Loader, 5-18

SQL*Loader, 5-13

files

Export file format, 1-3

file processing options string

logfile

SQL*Loader

storage

fixed format records

fixed-format records

vs. variable

EXTERNAL format

trimming whitespace

specification

FLOAT EXTERNAL data values

FLOAT keyword

foreign function libraries

not allowed by SQL*Loader, B-5

FORMAT statement in DB2

formats

and input records

SQL*Loader, 5-48

formatting errors

reducing database fragmentation via full export/import, 2-44

fragmentation

FROMUSER

Import parameter, 2-19

FTP

Export files, 1-44

FULL

Import parameter, 2-20

full database mode

Import, 2-5, 2-20

GRANTS

Import parameter, 2-20

grants

exporting, 1-16

importing, 2-12, 2-20

GRAPHIC datatype, 5-55

EXTERNAL format

SQL*Loader, 5-58

specification

GRAPHIC EXTERNAL datatype, 5-55

SQL*Loader, 5-58

HELP

Export parameter, 1-17

Import parameter, 2-20

help

Export, 1-9

Import, 2-8

hexadecimal strings

as part of a field comparison

SQL*Loader, 5-9

padded

when shorter than field

object identifiers and, 2-56

IGNORE

Import parameter, 2-21

existing objects, 2-46

IMP_FULL_DATABASE role, 2-20

created by CATEXP.SQL, 2-7

Import, 2-10, 2-27

Import, 2-1

ANALYZE parameter, 2-16

backup files, 2-50

basics, 2-3

BUFFER parameter, 2-16

CATALOG.SQL

preparing the database, 2-7

CATEXP.SQL

preparing the database, 2-7

character set conversion, 1-45, 2-54

character sets, 2-54

CHARSET parameter, 2-17

COMMIT parameter, 2-17

committing after array insert, 2-17

compatibility, 2-4

complete export file, 2-40

consolidated extents, 2-51

controlling size of rollback segments, 2-18

conversion of Version 6 CHAR columns to VARCHAR2, 2-62

creating an index-creation SQL script, 2-23

cumulative, 2-40

data files

reusing, 2-18

database

reusing existing data files, 2-18

DESTROY parameter, 2-18

disabling referential constraints, 2-13

displaying online help, 2-20

dropping a tablespace, 2-52

error handling, 2-45

errors importing database objects, 2-46

example session, 2-31

export COMPRESS parameter, 2-51

export file

importing the entire file, 2-20

listing contents before import, 2-24

failed integrity constraints, 2-46

fatal errors, 2-46, 2-47

FEEDBACK parameter, 2-19

FILE parameter, 2-19

FROMUSER parameter, 2-19

full database mode, 2-5

specifying, 2-20

FULL parameter, 2-20

grants

specifying for import, 2-20

GRANTS parameter, 2-20

HELP parameter, 2-8, 2-20

IGNORE parameter, 2-21, 2-46

IMP_FULL_DATABASE role, 2-10

importing grants, 2-12, 2-20

importing objects into other schemas, 2-12

importing rows, 2-24

importing tables, 2-25

INCTYPE parameter, 2-22

INDEXES parameter, 2-22

INDEXFILE parameter, 2-22

INSERT errors, 2-46

interactive method, 2-39

into a secondary database, 2-18

invalid data, 2-46

invoking, 2-7

length of Oracle Version 6 export file DEFAULT columns, 2-63

log files

LOG parameter, 2-23

LONG columns, 2-60

manually ordering tables, 2-14

modes, 2-5

NLS considerations, 2-54

NLS_LANG environment variable, 2-54

object creation errors, 2-21

objects imported, 1-5

OPTIMAL storage parameter, 2-51

Oracle Version 6 integrity constraints, 2-63

Oracle Version 6 LONG columns, 2-63

parameter file, 2-9, 2-23

parameters, 2-14

PARFILE parameter, 2-23

partition-level, 2-5

POINT_IN_TIME_RECOVER parameter, 2-24

preparing the database, 2-7

privileges required, 2-10

read-only tablespaces, 2-51

recompiling stored procedures, 2-60

RECORDLENGTH parameter, 2-24

records

specifying length, 2-24

reducing database fragmentation, 2-44

refresh error, 2-49

reorganizing tablespace during, 2-53

resource errors, 2-47

restrictions, 2-52

rows

specifying for import, 2-24

ROWS parameter, 2-24

schema objects, 2-11, 2-12

schemas

specifying for import, 2-19

sequences, 2-47

SHOW parameter, 1-3, 2-24

single-byte character sets, 2-54

SKIP_UNUSABLE_INDEXES parameter, 2-25

snapshot log, 2-49

snapshot master table, 2-49

snapshots, 2-49

restoring dropped, 2-50

specifying by table, 2-5

specifying by user, 2-5, 2-19

specifying index creation commands, 2-22

specifying the export file, 2-19

SQL*Net See Net8

statistics on imported data, 2-61

storage parameters

overriding, 2-51

stored functions, 2-60

stored packages, 2-60

stored procedures, 2-60

system objects, 2-12, 2-20

table mode, 2-5

table objects

import order, 2-3

tables created before import, 2-13

TABLES parameter, 2-25

tablespaces, 2-19

TOUSER parameter, 2-27

transferring files across networks, 2-48

Trusted Oracle and, 2-2

unique indexes, 2-21

uniqueness constraints

preventing import errors, 2-18

user definitions, 2-12

user mode, 2-5

specifying, 2-27

USERID parameter, 2-27

using Oracle Version 6 files, 2-62

incremental export, 1-36

backing up data, 1-41

session example, 1-41

specifying, 1-17

incremental import

parameter, 2-22

specifying, 2-22

INCTYPE

Export parameter, 1-17

Import parameter, 2-22

INDDN keyword

SQL*Loader, 5-17, 5-18

index options

SINGLEROW keyword

indexes left in Index Unusable state, 8-11

SORTED INDEXES

SQL*Loader, 5-39

Index Unusable state

INDEXES

Export parameter, 1-17

Import parameter, 2-22

indexes

creating manually, 2-23

direct path load

left in direct load state, 8-11

dropping

before continuing a direct path load

index-creation commands

Import, 2-22

left direct load state

multiple column

presorting data

skipping unusable, 2-25

SQL*Loader, 5-39

state after discontinued load

unique, 2-21

INDEXFILE

Import parameter, 2-22

INFILE keyword

INIT.ORA file

Export, 1-35

insert errors

specifying allowed number before termination

SQL*Loader, 6-5

INSERT into table

INSERT keyword

INTEGER datatype, 5-55

EXTERNAL format, 5-63

trimming whitespace

specification

Oracle Version 6 export files, 2-63

integrity constraints

failed on Import, 2-46

load method

SQL*Loader, 8-8

interactive method

Export, 1-29

Import, 2-39

interrupted loads

continuing

INTO TABLE clause

effect on bind array size

INTO TABLE statement

column names

discards

multiple

invalid data

invalid objects

warning messages

ITIME column

key values

generating

language support

leading whitespace

definition

specifying record length for export, 1-19

trimming

SQL*Loader, 5-79

length

length indicator

determining size

SQL*loader, 5-72

length of a numeric field

length subfield

VARCHAR DATA

SQL*Loader, 5-60

libraries

foreign function

LOAD

loading

combined physical records

datafiles containing TABs

SQL*Loader, 5-45

delimited, free-format files, 4-9, 4-27

fixed-length data, 4-7

negative numbers

variable-length data, 4-5

LOB data, 1-8

compression, 1-13

Export, 1-47

LOG

Export parameter, 1-18, 1-31

Import parameter, 2-23

log file

specifying

SQL*Loader, 6-5

log files

after a discontinued load

datafile information

SQL*Loader, 7-4

example, 4-21, 4-25

Export, 1-18, 1-31

global information

header Information

summary statistics

table information

table load information

SQL*Loader, 7-4

logical records

consolidating multiple physical records into

loading with direct path load, 8-14

versus physical records

LONG data

loading

LONG FLOAT

C language datatype, 5-56

Version 6 export files, 2-63

LXBCNF executable, 9-9

LXEGEN executable, 9-12

LXINST executable, 9-3

master table

snapshots

Import, 2-49

media protection

disabling for direct path loads

media recovery

direct path load, 8-14

SQL*Loader, 8-13

memory

controlling usage

SQL*Loader, 5-19

merging partitions in a table, 2-6, 2-29

messages

migrating data across partitions, 2-29

Import, 2-45

missing data columns

Trusted Oracle7 Server, 5-63

MLSLABEL datatype

SQL*Loader

mode

full database

Export, 1-4, 1-16, 1-22

Import, 2-5, 2-20

objects exported by each, 1-5

table

Export, 1-4, 1-20, 1-25

Import, 2-5, 2-25

user

Export, 1-4, 1-18, 1-24

Import, 2-5

multi-byte character sets

blanks

Export and Import issues, 1-46, 2-55

multiple CPUs

multiple table load

control file specification

discontinued

generating unique sequence numbers for

SQL*Loader, 5-53

multiple-column indexes

NAME column

National Language Support

NLS Configuration Utility, 9-8

National Language Support (NLS)

data object files, 9-4

Export, 1-45

Import, 2-17, 2-54

NLS Data Installation Utility, 9-2

native datatypes

and SQL*Loader, 5-55

binary versus character data

conflicting length specifications

delimiters

SQL*Loader, 5-55

inter-operating system transfer issues

SQL*Loader, 5-69

NCHAR data

Export, 1-46

Import, 2-55

negative numbers

loading

transporting Export files across a network, 1-44

nested tables

exporting, 1-50

consistency and, 1-14

importing, 2-57

networks

Export, 1-44

Import and, 2-48

NLS

See National Language Support (NLS)

NLS Calendar Utility, 9-12

NLS Data Installation Utility, 9-2

NLS_LANG

environment variable

NLS_LANG environment variable

Export, 1-46

STATISTICS Export parameter, 1-20

NONE option

non-fatal errors

warning messages, 1-31

normalizing data during a load

SQL*Loader, 4-15

NOT NULL constraint

load method

SQL*Loader, 8-8

null columns

at end of record

setting

null data

missing columns at end of record

unspecified columns

NULLIF keyword

field condition

SQL*Loader, 5-75, 5-76

NULLIF...BLANKS

case study, 4-21

NULLIF...BLANKS keyword

considerations for Importing, 2-56

NUMBER datatype

SQL*Loader, 5-54

numeric EXTERNAL datatypes

binary versus character data

delimited form

determining length

trimming

trimming whitespace

numeric fields

precision versus length

object identifiers

object names

object tables

object type definitions

exporting, 1-48

importing, 2-57

objects

creation errors, 2-46

identifiers, 2-56

ignoring existing objects during import, 2-21

import creation errors, 2-21

privileges, 2-11

restoring

Import, 2-22

restoring sets

Import, 2-41

online help

Export, 1-9

Import, 2-8

operating systems

moving data to different systems

SQL*Loader, 5-68

OPTIMAL storage parameter, 2-51

optimizing

direct path loads, 8-15

input file processing

exporting database objects, 2-62

OPTIONALLY ENCLOSED BY

SQL*Loader, 5-11, 5-77

OPTIONS keyword

for parallel loads

SQL*Loader, 5-37

SQL*Loader, 5-12

ORA_NLS environment variable, 9-3, 9-9

Oracle Version 6

Oracle7

creating export files with, 1-51

ORANLS option, 9-3, 9-9

output file

specifying for Export, 1-16

OWNER

Export parameter, 1-18

OWNER# column

packed decimal data

padding of literal strings

PARALLEL

PARALLEL keyword

SQL*Loader, 8-27

parallel loads

allocating extents

FILE

PARALLEL

conflicts between export parameters, 1-22

parameter file

comments, 1-10, 2-26

Export, 1-10, 1-18

Import, 2-9, 2-23

maximum size

Export, 1-10

parameters

ANALYZE

BUFFER

CHARSET

COMMIT

CONSTRAINTS

DESTROY

DIRECT

FEEDBACK

FILE

FROMUSER

FULL

GRANTS

HELP

IGNORE

INCTYPE

INDEXES

INDEXFILE

LOG, 1-31

OWNER

PARFILE

Export, 1-8, 1-18

Import, 2-23

POINT_IN_TIME_RECOVER

RECORD

RECORDLENGTH

RECOVERY_TABLESPACES

ROWS

SHOW

SKIP_UNUSABLE_INDEXES

STATISTICS

TABLES

TOUSER

USERID

PARFILE

Export command-line option, 1-8, 1-10, 1-18

Import command-line option, 2-9, 2-23

not allowed by SQL*Loader, B-5

PART statement in DB2

partitioned load

concurrent conventional path loads, 8-25

export consistency and, 1-14

partitioned table

exporting, 1-7

importing, 2-5, 2-6, 2-29, 2-31

partitioned tables in DB2

no Oracle equivalent, B-5

partition-level Export, 1-7

examples, 1-27

partition-level Import, 2-5, 2-28

guidelines, 2-28

merging partitions, 2-29

reconfiguring partitions, 2-30

specifying, 1-20

passwords

hiding, 2-8

performance

direct path Export, 1-32, 1-35

direct path loads, 8-15

Import, 2-18

optimizing reading of data files

partitioned load

conventional path for small loads, 8-22

performance improvement

physical versus logical records

SQL*Loader, 3-9

PIECED keyword

POINT_IN_TIME_RECOVER

Export parameter, 1-18

Import parameter, 2-24

POSITION keyword

specification of field position

SQL*Loader, 5-8

tabs, 5-45

with multiple INTO TABLE clauses

SQL*Loader, 5-45, 5-49

precision of a numeric field versus length

predetermined size fields

prerequisites

SQL*Loader, 3-16

PRESERVE BLANKS keyword

SQL*Loader, 5-81

presorting data for a direct path load

case study, 4-20

primary keys

privileges

complete export, 1-36

creating for Export, 1-7

cumulative export, 1-36

DELETE

DELETE ANY TABLE

Export and, 1-4

granted to others, 2-12

required for SQL*Loader, 3-16

incremental export, 1-36

See also grants, roles

SQL*Loader and Trusted Oracle7 Server, 3-16

quotation marks

backslash

escape character

in filenames

filenames

SQL string

table names and, 1-21, 2-26

use with database object names

specification

READBUFFERS keyword

SQL*Loader, 5-19, 8-15

read-consistent export, 1-14

read-only tablespaces

Import, 2-51

RECNUM keyword

no space used in bind array

use with SKIP

stored functions, procedures, and packages, 2-60

recompiling

reconfiguring partitions, 2-30

RECORD

Export parameter, 1-18

RECORDLENGTH

Export parameter, 1-19

direct path export, 1-33, 1-35

Import parameter, 2-24

records

consolidating into a single logical record

DISCARD SQL*Loader command-line parameter, 6-4

discarded

DISCARDMAX SQL*Loader command-line parameter, 6-5

SQL*Loader, 5-23

discarded by SQL*Loader, 3-14, 5-25

distinguishing different formats

SQL*Loader, 5-48

extracting multiple logical records

fixed format

null columns at end

physical versus logical

SQL*Loader, 3-9

rejected

rejected by SQL*Loader, 3-14

rejected by Oracle

SQL*Loader, 3-14

setting column to record number

short

missing data columns

skipping

SQL*Loader, 6-7

specifying how to load

LOAD

specifying length for export, 1-19

specifying length for import, 2-24

stream format

variable format

RECOVERABLE keyword

recovery

direct path load

SQL*Loader, 8-13

replacing rows, 5-28

RECOVERY_TABLESPACES parameter

Export, 1-19

redo log files

direct path load, 8-14

instance and media recovery

saving space

direct path load, 8-19

REENABLE keyword

REF data

exporting, 1-13

importing, 2-58

referential integrity constraints

disabling for import, 2-13

refresh error

snapshots

Import, 2-49

reject file

specifying

rejected records

SQL*Loader, 3-14, 5-21

relative field positioning

where a field starts

SQL*Loader, 5-78

with multiple INTO TABLE clauses

remote operation

REPLACE keyword

REPLACE table

to replace table during a load

resource errors

restrictions

DB2 load utility, B-5

importing into another user's schema, 2-12

Import, 2-52

importing grants, 2-12

importing into own schema, 2-11

table names in Export parameter file, 1-21

table names in Import parameter file, 2-26

RESUME

DB2 keyword

SQL*Loader equivalents, 5-28

roles

EXP_FULL_DATABASE, 1-4, 1-5, 1-7

IMP_FULL_DATABASE, 2-7, 2-10, 2-20, 2-27

RESOURCE, 2-11

rollback segments

CONSISTENT Export parameter, 1-14

controlling size during import, 2-18

during loads

row errors

ROWID

ROWS

command line parameter

SQL*Loader, 8-12

Export parameter, 1-19

Import parameter, 2-24

performance issues

specifying for import, 2-24

rows

choosing which to load

SQL*Loader, 5-37

exporting, 1-19

specifying number to insert before save

SQL*Loader, 8-12

updates to existing

specifying for Export, 1-20

schemas

export privileges, 1-4

specifying for import, 2-19

scientific notation for FLOAT EXTERNAL, 5-64

script files

preparing database for Import, 2-7

running before Export, 1-7, 1-51

secondary database

importing, 2-18

segments

temporary

FILE keyword

SEQUENCE keyword

sequence numbers

for multiple tables

generated by SEQUENCE clause

example, 4-9

generated, not read

no space used in bind array

setting column to a unique number

sequences, 2-47

short records with missing data

C Language datatype, 5-56

SHORTINT

SHOW

Import parameter, 1-3, 2-24

SILENT

single table load

discontinued

single-byte character sets

SINGLEROW

SKIP

control file keyword

effect on RECNUM specification

SQL*Loader command-line parameter, 6-7

SKIP_UNUSABLE_INDEXES parameter

Import, 2-25

SMALLINT datatype, 5-55

specification

snapshot log

snapshots

log

master table

restoring dropped

SORTED INDEXES

direct path loads

sorting

multiple column indexes

optimum sort order

presorting in direct path load, 8-16

SORTED INDEXES statement

SQL*Loader, 8-16

special characters, A-1

SQL

key words, A-1

reserved words, A-1

special characters, A-1

SQL operators

applying to fields

SQL*Loader, 5-82

SQL string

applying SQL operators to fields

SQL*Loader, 5-82

example of, 4-22

quotation marks

SQL*Loader, 5-14

SQL*Loader

appending rows to tables, 5-28

BAD

command-line parameter, 6-3

bad file, 3-14

BADDN keyword, 5-21

BADFILE keyword, 5-21

basics, 3-2

bind arrays and performance, 5-70

BINDSIZE

BINDSIZE command-line parameter, 5-70

case studies, 4-1

associated files, 4-3

direct path load, 4-20

extracting data from a formatted report, 4-22

loading combined physical records, 4-12

loading data into multiple tables, 4-15

loading delimited, free-format files, 4-9, 4-27

loading fixed-length data, 4-7

loading variable-length data, 4-5

preparing tables, 4-4

choosing which rows to load, 5-37

command-line arguments, 6-3

command-line parameters, 6-2

summary, 6-2

CONCATENATE keyword, 5-32

concepts, 3-1

concurrent sessions, 8-27

CONTINUE_LOAD keyword, 5-31

CONTINUEIF keyword, 5-32

CONTROL

controlling memory usage, 5-19

control file

creating, 3-4

conventional path loads, 8-2

DATA

expanded syntax diagrams, 5-8

data conversion, 3-11

data definition language

high-level syntax diagrams, 5-5

data definition language (DDL), 3-6

data definition language syntax, 5-4

data mapping concepts, 3-4

datafiles

specifying, 5-17

datatype specifications, 3-11

DB2 load utility, B-1

DDL syntax reference, 5-1

delimiters, 3-11

DIRECT

DIRECT command line parameter, 8-9

DISCARD

discard file, 3-14

discarded records, 3-14

DISCARDFILE keyword, 5-24

DISCARDMAX

DISCARDMAX keyword, 5-25

DISCARDS keyword, 5-25

enclosed data, 3-11

ERRORS

errors caused by tabs, 5-45

example sessions, 4-1

exclusive access, 8-25

fields, 3-11

FILE

filenames, 5-13

index options, 5-39

INTO TABLE statement, 5-36

keywords and parameters

reference, 5-1

LOAD

loading data without files, 5-50

load methods, 8-2

loading data

direct path method, 3-17

loading LONG data, 5-62

LOG

table load information, 7-4

log file

datafile information, 7-4

global information, 7-2

header information, 7-2

summary statistics, 7-5

table information, 7-3

log file entries, 7-1

log files, 3-16

mapping data, 3-4

methods for loading data into tables, 5-27

methods of loading data, 3-16

multiple INTO TABLE statements, 5-47

National Language Support, 5-26

native datatype handling, 3-10

NULLIF...BLANKS clause

case study, 4-21

object names, 5-13

PARALLEL

parallel data loading, 8-26, 8-30

parallel loading, 8-27

PARFILE

replacing rows in tables, 5-28

READBUFFERS keyword, 5-19

rejected records, 3-14

required privileges, 3-16

reserved words, A-1

ROWS

inserting into tables, 5-28

rows

SILENT

SINGLEROW index keyword, 5-40

SKIP

command-line parameter, 6-7

SKIP keyword, 5-31

SORTED INDEXES

case study, 4-21

direct path loads, 5-39

specifying a single load method for all tables, 5-29

specifying columns, 5-43

specifying data format, 3-6

specifying data location, 3-6

specifying datatypes, 5-54

specifying field conditions, 5-40

specifying fields, 5-43

specifying more than one data file, 5-18

suppressing messages

SILENT, 6-6

terminated data, 3-11

updating rows, 5-29

USERID

command-line parameter, 6-8

SQL*Net See Net8

SQL/DS option (DB2 file format)

not supported by SQL*Loader, B-5

starting column of a field

generating on imported data, 2-61

STATISTICS

Export parameter, 1-20

statistics

specifying for Export, 1-20

storage parameters, 2-50

estimating export requirements, 1-8

exporting tables, 1-13

OPTIMAL parameter, 2-51

overriding

Import, 2-51

preallocating

direct path load, 8-16

temporary for a direct path load, 8-10

stored functions

stored packages

stored procedures

direct path load, 8-24

stream format records, 3-8

exporting objects owned by, 1-5

string comparisons

SQL*Loader, 5-9, 5-42

synonyms

direct path load, 8-9

Export, 1-41

syntax

data definition language

SQL*Loader, 5-1

Export command, 1-8

Import command, 2-7

syntax diagrams

SQL*Loader

expanded, 5-8

high-level, 5-5

SYS

SYS.INCEXP table

Export, 1-42

incremental export tracking table, 1-17

SYS.INCFIL table

Export, 1-43

SYS.INCVID table

Export, 1-17, 1-43

SYSDATE datatype

case study, 4-22

no space used in bind array

SYSDATE keyword

advanced queue (AQ) importing, 2-60

system objects

importing, 2-12, 2-20

system tables

incremental export, 1-42

table-level Export, 1-7

table-level Import, 2-28

table-mode Export, 1-4

specifying, 1-20

table-mode Import, 2-5

examples, 2-31

tables

advanced queue (AQ)

exporting, 1-49

appending rows to

continuing a multiple table load

continuing a single table load

defining before Import, 2-13

definitions

creating before import, 2-13

exclusive access during direct path loads

exporting

specifying, 1-20

importing, 2-25

insert triggers

direct path load

SQL*Loader, 8-22

inserting rows

loading data into more than one table

maintaining consistency, 1-14

loading data into tables

SQL*Loader, 5-27

loading method

for individual tables

SQL*Loader, 5-37

manually ordering for import, 2-14

master table

name restrictions

nested

object import order, 2-3

partitioned, 1-7, 2-5, 2-28

partitioned in DB2

no Oracle equivalent, B-5

replacing rows in

size

USER_SEGMENTS view, 1-8

specifying a single load method for all tables

specifying table-mode Export, 1-20

system

incremental export, 1-42

truncating

updating existing rows

dropping during import, 2-52

TABLES parameter

Export, 1-20

Import, 2-25

tablespaces

read-only

reorganizing

tabs

loading data files and

SQL*Loader, 5-45

trimming

whitespace

not exported during backup, 1-41

temporary segments

FILE keyword

SQL*Loader, 8-28

temporary storage in a direct path load, 8-10

TERMINATED BY

SQL*Loader, 5-11, 5-64

WHITESPACE

SQL*Loader, 5-64, 5-79

with OPTIONALLY ENCLOSED BY

terminated fields

specified with a delimiter

SQL*Loader, 5-64, 5-77

TOUSER

Import parameter, 2-27

trailing

whitespace

trimming

SQL*Loader, 5-80

trailing blanks

loading with delimiters

migrating with export/import, 2-2

TRAILING NULLCOLS

case study, 4-22

control file keyword

SQL*LOader, 5-39

triggers

, 8-22

database insert triggers

, 8-22

permanently disabled

, 8-25

update triggers

SQL*Loader, 8-23

trimming

summary

trailing whitespace

VARCHAR fields

TRUNCATE keyword

Trusted Oracle

Trusted Oracle7 Server

privileges for SQL*Loader, 3-16

TYPE# column

unclustered table

exporting, 1-4

unique indexes

Import, 2-21

unique values

generating

uniqueness constraints

preventing errors during import, 2-18

UNLOAD (DB2 file format)

not supported by SQL*Loader, B-5

UNRECOVERABLE keyword

SQL*Loader, 5-13, 8-19

unsorted data

direct path load

updating rows in a table

SQL*Loader command-line parameter, 6-8

user definitions

importing, 2-12

USER_SEGMENTS view

Export and, 1-8

USERID

Export parameter, 1-22

Import parameter, 2-27

user-mode Export, 1-4

specifying, 1-18

user-mode Import, 2-5

specifying, 2-27

VARCHAR datatype, 5-55

specification

SQL*Loader, 5-60

trimming whitespace

VARCHAR2 datatype, 2-62

SQL*Loader, 5-54

VARGRAPHIC datatype, 5-55

specification

SQL*Loader, 5-59

variable format records

vs. fixed

creating views necessary for Export, 1-7

views

Export, 1-41

warning messages, 1-31

WHEN clause

discards resulting from

field condition

whitespace

included in a field, or not

SQL*Loader, 5-79

leading

preserving

SQL*Loader, 5-81

terminating a field with

trimming

WHITESPACE

WHITESPACE keyword

EXTERNAL format

trimming whitespace

length versus precision

specification