Oracle8 Utilities Release 8.0 A58244-01 |
Library | Product | Contents

# Index

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

## A

  access privileges
    Export, 1-3
    Import, 2-12
  advanced queue (AQ) tables
    exporting, 1-49
    importing, 2-61
  aliases
    directory
      exporting, 1-47
      importing, 2-60
  ANALYZE
    Import parameter, 2-19
  APPEND keyword
    SQL*Loader, 5-37
  APPEND to table
    example, 4-11
    SQL*Loader, 5-26
  AQ (advanced queue) tables
    exporting, 1-49
    importing, 2-61
  arrays
    committing after insert
      Import, 2-20
    exporting, 1-47
    importing, 2-59
  ASCII
    fixed-format files
      exporting, 1-3
  ASCII character set
    Import, 2-55

## B

  backslash (\)
    escape character in quoted strings
      SQL*Loader, 5-13
    quoted filenames and
      SQL*Loader, 5-14
  backups
    restoring dropped snapshots
      Import, 2-51
  BAD
    SQL*Loader command-line parameter, 6-3
  bad file
    rejected records
      SQL*Loader, 3-13
    specifying
      bad records, 6-3
      SQL*Loader, 5-19
  BADDN keyword
    SQL*Loader, 5-19
  BADFILE keyword
    SQL*Loader, 5-19
  base backup
    Export, 1-37
  base tables
    incremental export and, 1-41
  BEGINDATA
    control file keyword
      SQL*Loader, 5-15
  BFILE columns
    exporting, 1-47
  bind array
    determining size
      SQL*Loader, 5-65
    determining size of
      SQL*Loader, 5-67
    minimizing memory requirements
      SQL*Loader, 5-70
    minimum requirements
      SQL*Loader, 5-65
    no space required for generated data
      SQL*Loader, 5-71
    performance implications
      SQL*Loader, 5-66
    size with multiple INTO TABLE clauses
      SQL*Loader, 5-70
    specifying number of rows
      conventional path load

SQL*Loader, 6-6

  specifying size
    SQL*Loader, 6-3

  BINDSIZE
    SQL*Loader command-line parameter, 6-3
  BINDSIZE command-line parameter
    SQL*Loader, 5-66
  blanks
    BLANKS keyword for field comparison
      SQL*Loader, 5-7, 5-38
    loading fields consisting of blanks
      SQL*Loader, 5-72
    preserving
      SQL*Loader, 5-78
    trailing
      loading with delimiters

SQL*Loader, 5-63

  trimming
    SQL*Loader, 5-72
  whitespace
    SQL*Loader, 5-72

  BLANKS keyword
    SQL*Loader, 5-38
  BUFFER
    Export parameter, 1-13
      direct path export, 1-34, 1-36
    Import parameter, 2-19
  buffers
    calculating for export, 1-13
    calculating for import, 2-19
    space required by
      LONG DATA

SQL*Loader, 5-58

  VARCHAR data

SQL*Loader, 5-56

  specifying with BINDSIZE parameter
    SQL*Loader, 5-67

  BYTEINT datatype, 5-51
    specification
      SQL*Loader, 5-8
    SQL*Loader, 5-52

## C

  cached sequence numbers
    Export, 1-46
  case studies
    SQL*Loader, 4-1
      associated files, 4-3
      file names, 4-3
      preparing tables, 4-4
  CATALOG.SQL
    preparing database for Export, 1-6
    preparing database for Import, 2-7
  CATEXP7.SQL
    preparing database for Export, 1-50
  CATEXP.SQL
    preparing database for Export, 1-6
    preparing database for Import, 2-7
  CATLDR.SQL
    setup script
      SQL*Loader, 8-9
  CHAR columns
    Version 6 export files, 2-63
  CHAR datatype
    delimited form
      SQL*Loader, 5-60
    reference
      SQL*Loader, 5-58
    specification
      SQL*Loader, 5-9
    trimming whitespace
      SQL*Loader, 5-73
  character datatypes
    conflicting fields
      SQL*Loader, 5-63
  character fields
    datatypes
      SQL*Loader, 5-58
    delimiters
      SQL*Loader, 5-60
    determining length
      SQL*Loader, 5-63
    specified with delimiters
      SQL*Loader, 5-58
  character sets
    conversion between
      during Export/Import, 1-45, 2-55
      SQL*Loader, 5-24
    direct path export, 1-36, 1-45
    eight-bit to seven-bit conversions
      Export/Import, 1-46, 2-56
    multi-byte
      Export/Import, 1-46, 2-56
      SQL*Loader, 5-24
    NCHAR data
      Export, 1-45
    single-byte
      Export/Import, 1-46, 2-55
    Version 6 conversions
      Import/Export, 2-56
  character strings
    as part of a field comparison
      SQL*LOader, 5-7
    padded
      when shorter than field

SQL*Loader, 5-39

  CHARACTERSET keyword
    SQL*Loader, 5-24
  CHARSET
    Import parameter, 2-20
  check constraints
    Import, 2-48
  clusters
    Export, 1-42
  columns
    exporting LONG datatypes, 1-47
    naming
      SQL*Loader, 5-40
    null columns at the end of a record
      SQL*Loader, 5-72
    reordering before Import, 2-15
    setting to a constant value
      SQL*Loader, 5-46
    setting to a unique sequence number
      SQL*Loader, 5-48
    setting to datafile record number
      SQL*Loader, 5-47
    setting to null
      SQL*Loader, 5-71
    setting to null value
      SQL*Loader, 5-47
    setting to the current date
      SQL*Loader, 5-47
    setting value to zero
      SQL*Loader, 5-71
    specifiying as PIECED
      SQL*Loader, 8-14
    specifying
      SQL*Loader, 5-39
  combining partitions, 2-31
  command-line parameters
    description
      SQL*Loader, 6-2
    Export, 1-11
    Import, 2-16
    specifying defaults
      SQL*Loader, 5-11
  Comments
    in Export parameter file, 1-10
    in Import parameter file, 2-11
    in SQL*Loader control file, 4-12
  COMMIT
    Import parameter, 2-20
  complete exports, 1-37, 1-39
    restrictions, 1-37
    specifying, 1-17
  completion messages
    Export, 1-33
  COMPRESS
    Export parameter, 1-13, 2-53
  COMPUTE option
    STATISTICS Export parameter, 1-19
  CONCATENATE keyword
    SQL*Loader, 5-29
  concurrent conventional path loads, 8-24
  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-71
    SQL*Loader, 5-40, 5-46
  CONSTRAINTS
    Export parameter, 1-15
  constraints
    automatic
      SQL*Loader, 8-22
    check
      Import, 2-48
    direct path load, 8-20
    disabling during a direct load, 8-20
    disabling referential constraints
      Import, 2-15
    enabling after a direct load, 8-20
    enforced on a direct load, 8-20
    failed
      Import, 2-48
    load method
      SQL*Loader, 8-8
    not null
      Import, 2-48
    preventing Import errors due to uniqueness constraints, 2-21
    referential integrity
      Import, 2-48
    uniqueness
      Import, 2-48
  continuation fields
    SQL*Loader, 3-9
  CONTINUE_LOAD keyword
    SQL*Loader, 5-29
  CONTINUEIF keyword
    example
      SQL*Loader, 4-14
    SQL*Loader, 5-29
  continuing interrupted loads
    SQL*Loader, 5-27
  CONTROL
    SQL*Loader command-line parameter, 6-4
  control files
    CONTROL
      SQL*Loader command-line parameter, 6-4
    creating
      SQL*Loader, 3-3
    data definition language syntax
      SQL*Loader, 5-4
    data definitions
      basics

SQL*Loader, 3-3

  definition
    SQL*Loader, 3-3
  editing
    SQL*Loader, 3-3
  field delimiters
    SQL*Loader, 5-10
  guidelines for creating
    SQL*Loader, 3-4
  location
    SQL*Loader, 3-5
  specifying data
    SQL*Loader, 5-15
  specifying discard file
    SQL*Loader, 5-21
  storing
    SQL*Loader, 3-5

  conventional path Export
    compared to direct path Export, 1-33
  conventional path loads
    basics, 8-2
    bind array
      SQL*Loader, 5-66
    compared to direct path loads, 8-7
    using, 8-3
  CREATE SESSION privilege
    Export, 1-3
    Import, 2-12
  CREATE USER command
    Import, 2-14
  CTIME column
    SYS.INCEXP table, 1-43
  cumulative exports, 1-37, 1-38
    recording, 1-18
    restrictions, 1-37
    specifying, 1-17
    SYS.INCFIL table, 1-44
    SYS.INCVID table, 1-44

## D

  DATA
    SQL*Loader command-line parameter, 6-4
  data
    binary versus character format
      SQL*Loader, 3-9
    delimiter marks in data
      SQL*Loader, 5-62
    distinguishing different input formats
      SQL*Loader, 5-43
    enclosed
      SQL*Loader, 3-10
    exporting, 1-19
    formatted data
      SQL*Loader, 4-27
    generating unique values
      SQL*Loader, 5-48
    including in control files
      SQL*Loader, 5-15
    loading in sections
      SQL*Loader, 8-14
    loading into more than one table
      SQL*Loader, 5-43
    loading LONG
      SQL*Loader, 5-58
    loading without files
      SQL*Loader, 5-46
    mapping to Oracle format
      SQL*Loader, 3-3
    maximum length of delimited data
      SQL*Loader, 5-63
    methods of loading into tables
      SQL*Loader, 5-25
    moving between operating systems
      SQL*Loader, 5-65
    saving in a direct path load, 8-12
    saving rows
      SQL*Loader, 8-18
    terminated
      SQL*Loader, 3-10
    unsorted
      SQL*Loader, 8-17
    values optimized for performance
      SQL*Loader, 5-46
  data conversion
    description
      SQL*Loader, 3-10
  data definition language
    basics
      SQL*Loader, 3-3
    BEGINDATA keyword, 5-15
    BLANKS keyword
      SQL*Loader, 5-38
    CHARACTERSET keyword, 5-24
    column_name
      SQL*Loader, 5-8
    CONCATENATE keyword, 5-29
    CONSTANT keyword, 5-40, 5-46
    CONTINUEIF keyword, 5-29
    datatype_spec
      SQL*Loader, 5-9
    date mask
      SQL*Loader, 5-10
    DEFAULTIF keyword
      SQL*Loader, 5-71
    delimiter_spec
      SQL*Loader, 5-10
    description
      SQL*Loader, 3-5
    DISABLED_CONSTRAINTS keyword
      SQL*Loader, 8-21
    DISCARDDN keyword, 5-21
    DISCARDMAX keyword
      SQL*Loader, 5-23
    example definition
      SQL*Loader, 3-5
    EXCEPTIONS keyword
      SQL*Loader, 8-21
    EXTERNAL keyword, 5-60
    field_condition
      SQL*Loader, 5-7
    FILE keyword
      SQL*Loader, 8-27
    FLOAT keyword, 5-60
    INDDN keyword, 5-16
    INFILE keyword, 5-16
    length
      SQL*Loader, 5-10
    loading data in sections
      SQL*Loader, 8-14
    NULLIF keyword
      SQL*Loader, 5-71
    parallel keyword
      SQL*Loader, 8-26
    pos_spec
      SQL*Loader, 5-7
    POSITION keyword, 5-40
    precision
      SQL*Loader, 5-10
    RECNUM keyword, 5-40
    REENABLE keyword
      SQL*Loader, 8-21
    reference
      keywords and parameters

SQL*Loader, 5-1

  SEQUENCE keyword, 5-48
  syntax diagrams
    expanded

SQL*Loader, 5-7

  high-level

SQL*Loader, 5-4

  syntax reference
    SQL*Loader, 5-1
  SYSDATE keyword, 5-47
  TERMINATED keyword, 5-61
  UNRECOVERABLE keyword
    SQL*Loader, 8-18
  WHITESPACE keyword, 5-61

  data definition language (DDL), 3-3
  data field
    specifying the datatype
      SQL*Loader, 5-40
  data mapping
    concepts
      SQL*Loader, 3-3
  data path loads
    direct and conventional, 8-2
  data recovery
    direct path load
      SQL*Loader, 8-13
  database administrator (DBA)
    privileges for export, 1-3
  database objects
    export privileges, 1-3
    exporting LONG columns, 1-47
    transferring across a network
      Import, 2-50
  databases
    data structure changes
      incremental export and, 1-41
    full export, 1-16
    full import, 2-23
    importing into secondary
      Import, 2-21
    incremental export, 1-37
    preparing for Export, 1-6
    preparing for Import, 2-7
    privileges for exporting, 1-3
    privileges for importing, 2-11
    reducing fragmentation via full export/import, 2-47
    reusing existing data files
      Import, 2-21
  datafiles
    preventing overwrite during import, 2-21
    reusing during import, 2-21
    specifying
      SQL*Loader, 5-16, 6-4
    specifying buffering
      SQL*Loader, 5-18
    specifying format
      SQL*Loader, 5-18
    storage
      SQL*Loader, 3-6
  datatypes
    BFILE
      Export, 1-47
    BYTEINT, 5-52
      SQL*Loader, 5-8
    CHAR, 5-58
      Import, 2-63
      SQL*Loader, 5-9
    conflicting character datatype fields, 5-63
    converting
      SQL*Loader, 3-10, 5-50
    DATE, 5-58
      determining length, 5-64
      SQL*Loader, 5-9
    DECIMAL, 5-53
      SQL*Loader, 5-9
    default
      SQL*Loader, 5-40
    determining character field lengths
      SQL*Loader, 5-63
    DOUBLE, 5-52
      SQL*Loader, 5-8
    FLOAT, 5-52
      SQL*Loader, 5-8
    GRAPHIC, 5-54
      SQL*Loader, 5-9
    GRAPHIC EXTERNAL, 5-54
    INTEGER, 5-51
      SQL*Loader, 5-8
    LONG
      Export, 1-47
      Import, 2-61
    MLSLABEL
      Trusted Oracle7 Server, 5-59
    native
      conflicting length specifications

SQL*Loader, 5-57

  inter-operating system transfer issues, 5-65
  SQL*Loader, 3-9, 5-51

  NUMBER
    SQL*Loader, 5-50
  numeric EXTERNAL, 5-60
    trimming

SQL*Loader, 5-73

  RAW, 5-54
    SQL*Loader, 5-9
  SMALLINT, 5-51
    SQL*Loader, 5-8
  specifications
    SQL*Loader, 5-8
  specifying
    SQL*Loader, 5-50
  specifying the datatype of a data field
    SQL*Loader, 5-40
  VARCHAR, 5-56
    SQL*Loader, 5-9
  VARCHAR2
    Import, 2-63
    SQL*Loader, 5-50
  VARGRAPHIC, 5-55
    SQL*Loader, 5-9
  ZONED, 5-52
    SQL*Loader, 5-9

  DATE datatype
    delimited form
      SQL*Loader, 5-60
    determining length
      SQL*Loader, 5-64
    mask
      SQL*Loader, 5-64
    specification
      SQL*Loader, 5-9
    SQL*Loader, 5-58
    trimming whitespace
      SQL*Loader, 5-73
  date mask
    SQL*Loader, 5-10
  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-4
    RESUME keyword
      SQL*Loader equivalents, 5-26
    SQL*Loader compatibility
      ignored statements, B-3
  DBA role
    EXP_FULL_DATABASE role, 1-7
  DBCS (DB2 double-byte character set)
    not supported by Oracle, B-5
  DDL, 3-5
    SQL*Loader data definition language, 3-3
  DECIMAL datatype
    (packed), 5-51
    EXTERNAL format
      SQL*Loader, 5-60
      trimming whitespace

SQL*Loader, 5-73

  length and precision
    SQL*Loader, 5-10
  specification
    SQL*Loader, 5-9
  SQL*Loader, 5-53

  DEFAULT column values
    Oracle Version 6 export files, 2-63
  DEFAULTIF keyword
    field condition
      SQL*Loader, 5-37
    SQL*Loader, 5-71
  DELETE ANY TABLE privilege
    SQL*Loader, 5-27
  DELETE CASCADE
    SQL*Loader, 5-26, 5-27
  DELETE privilege
    SQL*Loader, 5-26
  delimited data
    maximum length
      SQL*Loader, 5-63
  delimited fields
    field length
      SQL*Loader, 5-64
  delimited files
    exporting, 1-3
  delimiter_spec
    SQL*Loader, 5-10
  delimiters
    and SQL*Loader, 3-10
    control files
      SQL*Loader, 5-10
    enclosure
      SQL*Loader, 5-74
    field specifications
      SQL*Loader, 5-74
    initial and trailing
      case study, 4-27
    loading trailing blanks
      SQL*Loader, 5-63
    marks in data
      SQL*Loader, 5-62
    optional enclosure
      SQL*Loader, 5-74
    specifying
      SQL*Loader, 5-35, 5-60
    termination
      SQL*Loader, 5-74
  DESTROY
    Import parameter, 2-21
  DIRECT
    Export parameter, 1-15, 1-34
    SQL*Loader command-line parameter, 6-4
  direct path export, 1-33
    BUFFER parameter, 1-36
    character set and, 1-45
    invoking, 1-34
    performance, 1-36
    RECORDLENGTH parameter, 1-36
  direct path load
    , 8-10
    advantages, 8-6
    case study, 4-24
    choosing sort order
      SQL*Loader, 8-17
    compared to convetional path load, 8-7
    conditions for use, 8-7
    data saves, 8-12, 8-18
    DIRECT
      SQL*Loader command-line parameter, 6-4
    DIRECT command line parameter
      SQL*Loader, 8-9
    DISABLED_CONSTRAINTS keyword, 8-21
    disabling media protection
      SQL*Loader, 8-18
    dropping indexes, 8-19
      to continue an interrupted load

SQL*Loader, 5-28

  EXCEPTIONS keyword, 8-21
  field defaults, 8-8
  improper sorting
    SQL*Loader, 8-17
  indexes, 8-9
  instance recovery, 8-13
  loading into synonyms, 8-9
  LONG data, 8-14
  media recovery, 8-13
  partitioned load
    SQL*Loader, 8-24
  performance, 8-15
  performance issues, 8-9
  preallocating storage, 8-15
  presorting data, 8-16
  recovery, 8-13
  REENABLE keyword, 8-21
  referential integrity constraints, 8-20
  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-16
  table insert triggers, 8-21
  temporary segment storage requirements, 8-10
  triggers, 8-20
  using, 8-7, 8-9
  version requirements, 8-9

  directory aliases
    exporting, 1-47
    importing, 2-60
  DISABLED_CONSTRAINTS keyword
    SQL*Loader, 8-21
  DISCARD
    SQL*Loader command-line parameter, 6-4
  discard file
    basics
      SQL*Loader, 3-15
    DISCARDDN keyword
      different placement from DB2, B-4
      SQL*Loader, 5-21
    DISCARDFILE keyword
      example, 4-14
    DISCARDMAX keyword
      example, 4-14
      SQL*Loader, 5-23
    DISCARDS control file clause
      different placement from DB2, B-4
    DISCARDS keyword
      SQL*Loader, 5-23
    DISCRDMAX keyword
      SQL*Loader, 5-23
    SQL*Loader, 5-21
  discarded records
    causes
      SQL*Loader, 5-23
    discard file
      SQL*Loader, 5-21
    limiting the number
      SQL*Loader, 5-23
    SQL*Loader, 3-13
  DISCARDMAX
    SQL*Loader command-line parameter, 6-5
  DISCARDMAX keyword
    discarded records
      SQL*Loader, 5-23
  discontinued loads
    continuing
      SQL*Loader, 5-27
  DOUBLE datatype, 5-51
    specification
      SQL*Loader, 5-8
    SQL*Loader, 5-52
  dropped snapshots
    Import, 2-51
  dropping
    indexes
      to continue a direct path load

SQL*LOader, 5-28

## E

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

SQL*Loader, 5-63

  SQL*Loader, 5-60
  trimming

SQL*Loader, 5-73

  SQL*Loader, 3-9
  ZONED
    SQL*Loader, 5-60

  external files
    exporting, 1-47
  EXTERNAL keyword
    SQL*Loader, 5-60

## F

  fatal errors
    Export, 1-33
    Import, 2-48, 2-49
  FEEDBACK
    Export parameter, 1-16
    Import parameter, 2-22
  field conditions
    specifying
      SQL*Loader, 5-37
  field length
    specifications
      SQL*Loader, 5-73
  fields
    and SQL*Loader, 3-10
    character
      data length

SQL*Loader, 5-63

  comparing
    SQL*Loader, 5-7
  comparing to literals
    SQL*Loader, 5-39
  continuation
    SQL*Loader, 3-9
  DECIMAL EXTERNAL
    trimming whitespace

SQL*Loader, 5-73

  delimited
    determining length

SQL*Loader, 5-64

  specifications

SQL*Loader, 5-74

  SQL*Loader, 5-60

  enclosed
    SQL*Loader, 5-61
  FLOAT EXTERNAL
    trimming whitespace

SQL*Loader, 5-73

  INTEGER EXTERNAL
    trimming whitespace

SQL*Loader, 5-73

  length of
    SQL*Loader, 5-10
  loading all blanks
    SQL*Loader, 5-72
  location
    SQL*Loader, 5-40
  numeric and precision versus length
    SQL*Loader, 5-10
  numeric EXTERNAL
    trimming whitespace

SQL*Loader, 5-73

  precision
    SQL*Loader, 5-10
  predetermined size
    length

SQL*Loader, 5-64

  SQL*Loader, 5-73

  relative positioning
    SQL*Loader, 5-74
  specification of position
    SQL*Loader, 5-7
  specified with a termination delimiter
    SQL*Loader, 5-61
  specified with enclosure delimiters
    SQL*Loader, 3-10, 5-61
  specifying
    SQL*Loader, 5-39
  specifying default delimiters
    SQL*Loader, 5-35
  terminated
    SQL*Loader, 5-61
  VARCHAR
    never trimmed

SQL*Loader, 5-73

  ZONED EXTERNAL
    trimming whitespace

SQL*Loader, 5-73

  FIELDS clause
    SQL*Loader, 5-35
    terminated by whitespace
      SQL*Loader, 5-76
  FILE
    Export parameter, 1-16
    Import parameter, 2-22
    keyword
      SQL*Loader, 8-27
    SQL*Loader command-line parameter, 6-5
  FILE columns
    Import, 2-60
  filenames
    bad file
      SQL*Loader, 5-19
    quotation marks
      SQL*Loader, 5-13
    specifying more than one
      SQL*Loader, 5-17
    SQL*Loader, 5-12
  files
    file processing options string
      SQL*Loader, 5-18
    logfile
      SQL*Loader, 3-15
    SQL*Loader
      bad file, 3-13
      discard file, 3-15
    storage
      SQL*Loader, 3-6
  fixed format records
    SQL*Loader, 3-6
  fixed-format records
    vs. variable
      SQL*Loader, 3-6, 3-7
  FLOAT datatype, 5-51
    EXTERNAL format
      SQL*Loader, 5-60
      trimming whitespace

SQL*Loader, 5-73

  specification
    SQL*Loader, 5-8
  SQL*Loader, 5-52

  FLOAT EXTERNAL data values
    SQL*Loader, 5-60
  FLOAT keyword
    SQL*Loader, 5-60
  foreign function libraries
    exporting, 1-47
    importing, 2-60
  FORMAT statement in DB2
    not allowed by SQL*Loader, B-5
  formats
    and input records
      SQL*Loader, 5-44
  formatting errors
    SQL*Loader, 5-19
  fragmentation
    reducing database fragmentation via full export/import, 2-47
  FROMUSER
    Import parameter, 2-22
  FTP
    Export files, 1-44
  FULL
    Export parameter, 1-16
    Import parameter, 2-23
  full database mode
    Import, 2-23

## G

  GRANTS
    Export parameter, 1-16
    Import parameter, 2-23
  grants
    exporting, 1-16
    importing, 2-13, 2-23
  GRAPHIC datatype, 5-51
    EXTERNAL format
      SQL*Loader, 5-54
    specification
      SQL*Loader, 5-9
    SQL*Loader, 5-54
  GRAPHIC EXTERNAL datatype, 5-51

## H

  HELP
    Export parameter, 1-17
    Import parameter, 2-23
  help
    Export, 1-9
    Import, 2-10
  hexadecimal strings
    as part of a field comparison
      SQL*Loader, 5-7
    padded
      when shorter than field

SQL*Loader, 5-39

## I

  IGNORE
    Import parameter, 2-23
      existing objects, 2-49
      object identifiers and, 2-57
  IMP_FULL_DATABASE role, 2-23
    created by CATEXP.SQL, 2-7
    Import, 2-12, 2-29
  Import, 2-1
    ANALYZE parameter, 2-19
    backup files, 2-51
    BUFFER parameter, 2-19
    CATALOG.SQL
      preparing the database, 2-7
    CATEXP.SQL
      preparing the database, 2-7
    character set conversion, 1-45, 2-55
    character sets, 2-55
    CHARSET parameter, 2-20
    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-21
    conversion of Version 6 CHAR columns to VARCHAR2, 2-63
    creating an index-creation SQL script, 2-25
    cumulative, 2-43
    data files
      reusing, 2-21
    database
      reusing existing data files, 2-21
    DESTROY parameter, 2-21
    disabling referential constraints, 2-15
    displaying online help, 2-23
    dropping a tablespace, 2-54
    error handling, 2-48
    errors importing database objects, 2-48
    example session, 2-33
    export COMPRESS parameter, 2-53
    export file
      importing the entire file, 2-23
      listing contents before import, 2-27
    failed integrity constraints, 2-48
    fatal errors, 2-48, 2-49
    FEEDBACK parameter, 2-22
    FILE parameter, 2-22
    FROMUSER parameter, 2-22
    full database mode
      specifying, 2-23
    FULL parameter, 2-23
    grants
      specifying for import, 2-23
    GRANTS parameter, 2-23
    HELP parameter, 2-10, 2-23
    IGNORE parameter, 2-23, 2-49
    IMP_FULL_DATABASE role, 2-12
    importing grants, 2-13, 2-23
    importing objects into other schemas, 2-14
    importing rows, 2-27
    importing tables, 2-27
    incremental, 2-43
      specifying, 2-24
    INCTYPE parameter, 2-24
    INDEXES parameter, 2-25
    INDEXFILE parameter, 2-25
    INSERT errors, 2-48
    interactive method, 2-41
    into a secondary database, 2-21
    invalid data, 2-48
    invoking, 2-7
    length of Oracle Version 6 export file DEFAULT columns, 2-63
    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-23
    objects imported, 1-4
    OPTIMAL storage parameter, 2-52
    Oracle Version 6 integrity constraints, 2-63
    parameter file, 2-11, 2-26
    parameters, 2-16
    PARFILE parameter, 2-26
    POINT_IN_TIME_RECOVER parameter, 2-26
    preparing the database, 2-7
    privileges required, 2-11, 2-12
    read-only tablespaces, 2-53
    recompiling stored procedures, 2-60
    RECORDLENGTH parameter, 2-26
    records
      specifying length, 2-26
    reducing database fragmentation, 2-47
    refresh error, 2-51
    reorganizing tablespace during, 2-54
    resource errors, 2-49
    restrictions, 2-53
    rows
      specifying for import, 2-27
    ROWS parameter, 2-27
    schema objects, 2-12, 2-14
    schemas
      specifying for import, 2-22
    sequences, 2-49
    SHOW parameter, 1-3, 2-27
    single-byte character sets, 2-55
    SKIP_UNUSABLE_INDEXES parameter, 2-27
    snapshot log, 2-50
    snapshot master table, 2-51
    snapshots, 2-50
      restoring dropped, 2-51
    specifying by user, 2-22
    specifying index creation commands, 2-25
    specifying the export file, 2-22
    SQL*Net See Net8
    statistics on imported data, 2-62
    storage parameters
      overriding, 2-53
    stored functions, 2-60
    stored packages, 2-60
    stored procedures, 2-60
    system objects, 2-14, 2-23
    table objects
      import order, 2-4
    tables created before import, 2-15
    TABLES parameter, 2-27
    tablespaces, 2-21
    TOUSER parameter, 2-29
    transferring files across networks, 2-50
    Trusted Oracle and, 2-2
    unique indexes, 2-24
    uniqueness constraints
      preventing import errors, 2-21
    user definitions, 2-14
    user mode
      specifying, 2-29
    USERID parameter, 2-29
    using Oracle Version 6 files, 2-63
  incremental export, 1-37
    backing up data, 1-42
    command syntax, 1-17
    data selected, 1-41
    recording, 1-18
    restrictions, 1-37
    session example, 1-42
    specifying, 1-17
    SYS.INCFIL table, 1-44
    SYS.INCVID table, 1-44
  incremental import
    parameter, 2-24
    specifying, 2-24
  INCTYPE
    Export parameter, 1-17
    Import parameter, 2-24
  INDDN keyword
    SQL*Loader, 5-16
  index options
    SINGLEROW keyword
      SQL*Loader, 5-37
    SORTED INDEXES
      SQL*Loader, 5-36
  Index Unusable state
    indexes left in Index Unusable state, 8-11
  INDEXES
    Export parameter, 1-17
    Import parameter, 2-25
  indexes
    creating manually, 2-25
    direct path load
      left in direct load state, 8-11
    dropping
      before continuing a direct path load

SQL*Loader, 5-28

  SQL*Loader, 8-19

  exporting, 1-17
  importing, 2-25
  index-creation commands
    Import, 2-25
  left direct load state
    SQL*Loader, 8-17
  multiple column
    SQL*Loader, 8-17
  presorting data
    case study, 4-24
    SQL*Loader, 8-16
  skipping unusable, 2-27
  SQL*Loader, 5-36
  state after discontinued load
    SQL*Loader, 5-27
  unique, 2-24

  INDEXFILE
    Import parameter, 2-25
  INFILE keyword
    SQL*Loader, 5-16
  INIT.ORA file
    Export, 1-36
  insert errors
    Import, 2-48
    specifying allowed number before termination
      SQL*Loader, 6-5
  INSERT into table
    SQL*Loader, 5-26
  INTEGER datatype, 5-51
    EXTERNAL format, 5-60
      trimming whitespace

SQL*Loader, 5-73

  specification
    SQL*Loader, 5-8

  integrity constraints
    failed on Import, 2-48
    load method
      SQL*Loader, 8-8
    Oracle Version 6 export files, 2-63
  interactive method
    Export, 1-29
    Import, 2-41
  interrupted loads
    continuing
      SQL*Loader, 5-27
  INTO TABLE clause
    effect on bind array size
      SQL*Loader, 5-70
  INTO TABLE statement
    column names
      SQL*Loader, 5-40
    discards
      SQL*Loader, 5-23
    multiple
      SQL*Loader, 5-43
    SQL*Loader, 5-33
  invalid data
    Import, 2-48
  invalid objects
    warning messages
      during export, 1-32
  invoking Export, 1-7
    direct path, 1-34
  invoking Import, 2-7
  ITIME column
    SYS.INCEXP table, 1-43

## K

  key values
    generating
      SQL*Loader, 5-48
  key words, A-2

## L

  language support
    Export, 1-45
    Import, 2-55
  leading whitespace
    definition
      SQL*Loader, 5-72
    trimming
      SQL*Loader, 5-75
  length
    specifying record length for export, 1-18, 2-26
  length indicator
    determining size
      SQL*loader, 5-68
  length of a numeric field
    SQL*Loader, 5-10
  length subfield
    VARCHAR DATA
      SQL*Loader, 5-56
  libraries
    foreign function
      exporting, 1-47
      importing, 2-60
  LOAD
    SQL*Loader command-line parameter, 6-5
  loading
    combined physical records
      SQL*Loader, 4-14
    datafiles containing TABs
      SQL*Loader, 5-41
    delimited, free-format files, 4-11, 4-32
    fixed-length data, 4-8
    negative numbers
      SQL*Loader, 4-14
    variable-length data, 4-5
  LOB data, 1-7
    compression, 1-13
    Export, 1-47
  LOG
    Export parameter, 1-17, 1-32
    Import parameter, 2-26
    SQL*Loader command-line parameter, 6-6
  log file
    specifying
      SQL*Loader, 6-6
  log files
    after a discontinued load
      SQL*Loader, 5-28
    datafile information
      SQL*Loader, 7-4
    example, 4-25, 4-30
    Export, 1-17, 1-32
    global information
      SQL*Loader, 7-2
    header Information
      SQL*Loader, 7-2
    Import, 2-26
    SQL*Loader, 3-15
    summary statistics
      SQL*Loader, 7-5
    table information
      SQL*Loader, 7-3
    table load information
      SQL*Loader, 7-4
  logical records
    consolidating multiple physical records into
      SQL*Loader, 5-29
    versus physical records
      SQL*Loader, 3-9
  LONG data
    exporting, 1-47
    importing, 2-61
    loading
      SQL*Loader, 5-58
    loading with direct path load, 8-14
    LONG FLOAT
      C language datatype, 5-52
  LXBCNF executable, 9-16
  LXEGEN executable, 9-20
  LXINST executable, 9-2

## M

  master table
    snapshots
      Import, 2-51
  media protection
    disabling for direct path loads
      SQL*Loader, 8-18
  media recovery
    direct path load, 8-13
      SQL*Loader, 8-13
  memory
    controlling usage
      SQL*Loader, 5-18
  merging partitions in a table, 2-7, 2-31
  messages
    Export, 1-32
    Import, 2-47
  migrating data across partitions, 2-31
  missing data columns
    SQL*Loader, 5-35
  MLSLABEL datatype
    SQL*Loader
      Trusted Oracle7 Server, 5-59
  mode
    full database
      Export, 1-16, 1-22
      Import, 2-23
    objects exported by each, 1-4
    table
      Export, 1-19, 1-25
      Import, 2-27
    user
      Export, 1-17, 1-24
  multi-byte character sets
    blanks
      SQL*Loader, 5-39
    Export and Import issues, 1-46, 2-56
    SQL*Loader, 5-24
  multiple CPUs
    SQL*Loader, 8-24
  multiple table load
    control file specification
      SQL*Loader, 5-43
    discontinued
      SQL*Loader, 5-28
    generating unique sequence numbers for
      SQL*Loader, 5-49
  multiple-column indexes
    SQL*Loader, 8-17

## N

  NAME column
    SYS.INCEXP table, 1-43
  National Language Support
    SQL*Loader, 5-24
  National Language Support (NLS)
    data object files, 9-4
    Export, 1-45
    Import, 2-20, 2-55
    NLS Configuration Utility, 9-16
    NLS Data Installation Utility, 9-2
  native datatypes
    and SQL*Loader, 5-51
    binary versus character data
      SQL*Loader, 3-9
    conflicting length specifications
      SQL*Loader, 5-57
    delimiters
      SQL*Loader, 5-51
    inter-operating system transfer issues
      SQL*Loader, 5-65
  NCHAR data
    Export, 1-45
    Import, 2-57
  negative numbers
    loading
      SQL*Loader, 4-14
  nested tables
    exporting, 1-49
      consistency and, 1-14
    importing, 2-58
  networks
    Export, 1-44
    Import and, 2-50
    transporting Export files across a network, 1-44
  NLS
    See National Language Support (NLS)
  NLS Calendar Utility, 9-20
  NLS Data Installation Utility, 9-2
  NLS_LANG
    environment variable
      SQL*Loader, 5-24
  NLS_LANG environment variable
    Export, 1-46
    Import, 2-56
  NONE option
    STATISTICS Export parameter, 1-19
  non-fatal errors
    warning messages, 1-32
  normalizing data during a load
    SQL*Loader, 4-18
  NOT NULL constraint
    Import, 2-48
    load method
      SQL*Loader, 8-8
  null columns
    at end of record
      SQL*Loader, 5-72
    setting
      SQL*Loader, 5-71
  null data
    missing columns at end of record
      SQL*Loader, 5-35
    unspecified columns
      SQL*Loader, 5-39
  NULLIF keyword
    field condition
      SQL*Loader, 5-37
    SQL*Loader, 5-71, 5-72
  NULLIF...BLANKS
    case study, 4-25
  NULLIF...BLANKS keyword
    SQL*Loader, 5-38
  NUMBER datatype
    SQL*Loader, 5-50
  numeric EXTERNAL datatypes
    binary versus character data
      SQL*Loader, 3-9
    delimited form
      SQL*Loader, 5-60
    determining length
      SQL*Loader, 5-63
    SQL*Loader, 5-60
    trimming
      SQL*Loader, 5-73
    trimming whitespace
      SQL*Loader, 5-73
  numeric fields
    precision versus length
      SQL*Loader, 5-10

## O

  object identifiers
    Export, 1-48
    Import, 2-57
  object names
    SQL*Loader, 5-12
  object tables
    Import, 2-58
  object type definitions
    exporting, 1-48
    importing, 2-58
  objects
    considerations for Importing, 2-57
    creation errors, 2-48, 2-49
    identifiers, 2-57
    ignoring existing objects during import, 2-23
    import creation errors, 2-23
    privileges, 2-12
    restoring sets
      Import, 2-43
  online help
    Export, 1-9
    Import, 2-10
  operating systems
    moving data to different systems
      SQL*Loader, 5-65
  OPTIMAL storage parameter, 2-52
  optimizing
    direct path loads, 8-15
    input file processing
      SQL*Loader, 5-18
  OPTIONALLY ENCLOSED BY
    SQL*Loader, 5-10, 5-74
  OPTIONS keyword
    for parallel loads
      SQL*Loader, 5-34
    SQL*Loader, 5-11
  Oracle Version 6
    exporting database objects, 2-63
  Oracle7
    creating export files with, 1-50
  ORANLS option, 9-2, 9-16
  output file
    specifying for Export, 1-16
  OWNER
    Export parameter, 1-17
  OWNER# column
    SYS.INCEXP table, 1-43

## P

  packed decimal data
    SQL*Loader, 5-10
  padding of literal strings
    SQL*Loader, 5-39
  PARALLEL
    SQL*Loader command-line parameter, 6-6
  PARALLEL keyword
    SQL*Loader, 8-26
  parallel loads
    allocating extents
      FILE

SQL*Loader command-line parameter, 6-5

  PARALLEL
    SQL*Loader command-line parameter, 6-6

  parameter file
    comments, 1-10, 2-28
    Export, 1-10, 1-17
    Import, 2-11, 2-26
    maximum size
      Export, 1-10
  parameters
    ANALYZE
      Import, 2-19
    BUFFER
      Export, 1-13
      Import, 2-19
    CHARSET
      Import, 2-20
    COMMIT
      Import, 2-20
    COMPRESS, 1-13
    conflicts between export parameters, 1-21
    CONSTRAINTS
      Export, 1-15
    DESTROY
      Import, 2-21
    DIRECT
      Export, 1-15
    Export, 1-11
    FEEDBACK
      Export, 1-16
      Import, 2-22
    FILE
      Export, 1-16
      Import, 2-22
    FROMUSER
      Import, 2-22
    FULL
      Export, 1-16
      Import, 2-23
    GRANTS
      Export, 1-16
      Import, 2-23
    HELP
      Export, 1-17
      Import, 2-23
    IGNORE
      Import, 2-23
    INCTYPE
      Export, 1-17
      Import, 2-24
    INDEXES
      Export, 1-17
      Import, 2-25
    INDEXFILE
      Import, 2-25
    LOG, 1-32
      Export, 1-17
      Import, 2-26
    OWNER
      Export, 1-17
    PARFILE
      Export, 1-7, 1-17
      Import, 2-26
    POINT_IN_TIME_RECOVER
      Export, 1-18
      Import, 2-26
    RECORD
      Export, 1-18
    RECORDLENGTH
      Export, 1-18
      Import, 2-26
    RECOVERY_TABLESPACES
      Export, 1-19
    ROWS
      Export, 1-19
      Import, 2-27
    SHOW
      Import, 2-27
    SKIP_UNUSABLE_INDEXES
      Import, 2-27
    STATISTICS
      Export, 1-19
    TABLES
      Export, 1-19
      Import, 2-27
    TOUSER
      Import, 2-29
    USERID
      Export, 1-21
      Import, 2-29
  PARFILE
    Export command-line option, 1-7, 1-10, 1-17
    Import command-line option, 2-11, 2-26
    SQL*Loader command-line parameter, 6-6
  PART statement in DB2
    not allowed by SQL*Loader, B-5
  partitioned load
    concurrent conventional path loads, 8-24
    SQL*Loader, 8-24
  partitioned table
    export consistency and, 1-14
    exporting, 1-6
    importing, 2-6, 2-31, 2-33
  partitioned tables in DB2
    no Oracle equivalent, B-5
  partition-level Export, 1-6
    examples, 1-27
  partition-level Import, 2-30
    guidelines, 2-30
    merging partitions, 2-31
    reconfiguring partitions, 2-32
    specifying, 1-19
  passwords
    hiding, 2-8
  performance
    direct path Export, 1-33, 1-36
    direct path loads, 8-15
    Import, 2-21
    optimizing reading of data files
      SQL*Loader, 5-18
    partitioned load
      SQL*Loader, 8-24
  performance improvement
    conventional path for small loads, 8-21
  physical versus logical records
    SQL*Loader, 3-9
  PIECED keyword
    SQL*Loader, 8-14
  POINT_IN_TIME_RECOVER
    Export parameter, 1-18
    Import parameter, 2-26
  POSITION keyword
    specification of field position
      SQL*Loader, 5-7
    SQL*Loader, 5-40
    tabs, 5-41
    with multiple INTO TABLE clauses
      SQL*Loader, 5-42, 5-45
  precision of a numeric field versus length
    SQL*Loader, 5-10
  predetermined size fields
    SQL*Loader, 5-73
  preface
    Send Us Your Comments, xix
  prerequisites
    SQL*Loader, 3-16
  PRESERVE BLANKS keyword
    SQL*Loader, 5-78
  presorting data for a direct path load
    case study, 4-24
  primary keys
    Import, 2-48
  privileges
    complete export, 1-37
    creating for Export, 1-7
    cumulative export, 1-37
    DELETE
      SQL*Loader, 5-26
    DELETE ANY TABLE
      SQL*Loader, 5-27
    Export and, 1-3
    granted to others, 2-13
    Import, 2-11, 2-12
    incremental export, 1-37
    required for SQL*Loader, 3-16
    See also grants, roles
    SQL*Loader and Trusted Oracle7 Server, 3-16

## Q

  quotation marks
    backslash
      escape character

SQL*Loader, 5-13

  in filenames

SQL*Loader, 5-14

  filenames
    SQL*Loader, 5-13
  SQL string
    SQL*Loader, 5-13
  table names and, 1-20, 2-28
  use with database object names
    SQL*Loader, 5-12

## R

  RAW datatype, 5-51
    specification
      SQL*Loader, 5-9
    SQL*Loader, 5-54
  READBUFFERS keyword
    SQL*Loader, 5-18, 8-15
  read-consistent export, 1-14
  read-only tablespaces
    Import, 2-53
  RECNUM keyword
    no space used in bind array
      SQL*Loader, 5-71
    SQL*Loader, 5-40
    use with SKIP
      SQL*Loader, 5-47
  recompiling
    stored functions, procedures, and packages, 2-60
  reconfiguring partitions, 2-32
  RECORD
    Export parameter, 1-18
  RECORDLENGTH
    Export parameter, 1-18
      direct path export, 1-34, 1-36
    Import parameter, 2-26
  records
    consolidating into a single logical record
      SQL*Loader, 5-29
    discarded
      DISCARD

SQL*Loader command-line parameter, 6-4

  DISCARDMAX

SQL*Loader command-line parameter, 6-5

  SQL*Loader, 5-21

  discarded by SQL*Loader, 3-13, 5-23
  distinguishing different formats
    SQL*Loader, 5-44
  extracting multiple logical records
    SQL*Loader, 5-43
  fixed format
    SQL*Loader, 3-6
  null columns at end
    SQL*Loader, 5-72
  physical versus logical
    SQL*Loader, 3-9
  rejected
    SQL*Loader, 5-19
  rejected by Oracle
    SQL*Loader, 3-15
  rejected by SQL*Loader, 3-13
  setting column to record number
    SQL*Loader, 5-47
  short
    missing data columns

SQL*Loader, 5-35

  skipping
    SQL*Loader, 6-8
  specifying how to load
    LOAD

SQL*Loader command-line parameter, 6-5

  specifying length for export, 1-18, 2-26
  specifying length for import, 2-26
  stream format
    SQL Loader, 3-8
    SQL*Loader, 3-6
  variable format
    SQL*Loader, 3-8

  RECOVERABLE keyword
    SQL*Loader, 5-12
  recovery
    direct path load
      SQL*Loader, 8-13
    replacing rows, 5-26
  RECOVERY_TABLESPACES parameter
    Export, 1-19
  redo log files
    direct path load, 8-13
    instance and media recovery
      SQL*Loader, 8-13
    saving space
      direct path load, 8-18
  REENABLE keyword
    SQL*Loader, 8-21
  REF data
    exporting, 1-13
    importing, 2-59
  referential integrity constraints
    disabling for import, 2-15
    Import, 2-48
    SQL*Loader, 8-20
  refresh error
    snapshots
      Import, 2-51
  reject file
    specifying
      SQL*Loader, 5-19
  rejected records
    SQL*Loader, 3-13, 5-19
  relative field positioning
    where a field starts
      SQL*Loader, 5-74
    with multiple INTO TABLE clauses
      SQL*Loader, 5-44
  remote operation
    Export/Import, 1-44
  REPLACE table
    example, 4-14
    to replace table during a load
      SQL*LOader, 5-26
  reserved words, A-2
    SQL*Loader, A-2
  resource errors
    Import, 2-49
  RESOURCE role, 2-12
  restrictions
    DB2 load utility, B-4
    Export, 1-3
    Import, 2-53
    importing grants, 2-13
    importing into another user's schema, 2-14
    importing into own schema, 2-12
    table names in Export parameter file, 1-20
    table names in Import parameter file, 2-28
  RESUME
    DB2 keyword
      SQL*Loader equivalents, 5-26
  roles
    EXP_FULL_DATABASE, 1-3, 1-7
    IMP_FULL_DATABASE, 2-7, 2-12, 2-23, 2-29
    RESOURCE, 2-12
  rollback segments
    CONSISTENT Export parameter, 1-14
    controlling size during import, 2-21
    during loads
      SQL*Loader, 5-20
    Export, 1-42
    Import, 2-53
  row errors
    Import, 2-48
  ROWID
    Import, 2-51
  ROWS
    command line parameter
      SQL*Loader, 8-12
    Export parameter, 1-19
    Import parameter, 2-27
    performance issues
      SQL*Loader, 8-18
    SQL*Loader command-line parameter, 6-6
  rows
    choosing which to load
      SQL*Loader, 5-34
    exporting, 1-19
    specifying for import, 2-27
    specifying number to insert before save
      SQL*Loader, 8-12
    updates to existing
      SQL*Loader, 5-26

## S

  schemas
    export privileges, 1-3
    specifying for Export, 1-19
    specifying for import, 2-22
  scientific notation for FLOAT EXTERNAL, 5-60
  script files
    preparing database for Import, 2-7
    running before Export, 1-6, 1-50
  secondary database
    importing, 2-21
  segments
    temporary
      FILE keyword

SQL*Loader, 8-27

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

## T

  table-level Export, 1-6
  table-level Import, 2-30
  table-mode Export
    specifying, 1-19
  table-mode Import
    examples, 2-33
  tables
    advanced queue (AQ)
      exporting, 1-49
    advanced queue (AQ) importing, 2-61
    appending rows to
      SQL*Loader, 5-26
    continuing a multiple table load
      SQL*Loader, 5-28
    continuing a single table load
      SQL*Loader, 5-28
    defining before Import, 2-15
    definitions
      creating before import, 2-15
    exclusive access during direct path loads
      SQL*Loader, 8-24
    exporting
      specifying, 1-19
    importing, 2-27
    insert triggers
      direct path load

SQL*Loader, 8-21

  inserting rows
    SQL*Loader, 5-26
  loading data into more than one table
    SQL*Loader, 5-43
  loading data into tables
    SQL*Loader, 5-25
  loading method
    for individual tables

SQL*Loader, 5-34

  maintaining consistency, 1-14
  manually ordering for import, 2-15
  master table
    Import, 2-51
  name restrictions
    Export, 1-20
    Import, 2-27
  nested
    exporting, 1-49
    importing, 2-58
  object import order, 2-4
  partitioned, 1-6, 2-6, 2-30
  partitioned in DB2
    no Oracle equivalent, B-5
  replacing rows in
    SQL*Loader, 5-26
  size
    USER_SEGMENTS view, 1-7
  specifying a single load method for all tables
    SQL*Loader, 5-27
  specifying table-mode Export, 1-19
  system
    incremental export, 1-43
  truncating
    SQL*Loader, 5-27
  updating existing rows
    SQL*Loader, 5-26

  TABLES parameter
    Export, 1-19
    Import, 2-27
  tablespaces
    dropping during import, 2-54
    Export, 1-42
    pre-created, 2-21
    read-only
      Import, 2-53
    reorganizing
      Import, 2-54
  tabs
    loading data files and
      SQL*Loader, 5-41
    trimming
      SQL*Loader, 5-72
    whitespace
      SQL*Loader, 5-72
  temporary segments
    FILE keyword
      SQL*Loader, 8-27
    not exported during backup, 1-42
  temporary storage in a direct path load, 8-10
  TERMINATED BY
    SQL*Loader, 5-10, 5-61
    WHITESPACE
      SQL*Loader, 5-61, 5-75
    with OPTIONALLY ENCLOSED BY
      SQL*Loader, 5-74
  terminated fields
    specified with a delimiter
      SQL*Loader, 5-61, 5-74
  TOUSER
    Import parameter, 2-29
  trailing
    whitespace
      trimming

SQL*Loader, 5-76

  trailing blanks
    loading with delimiters
      SQL*Loader, 5-63
  TRAILING NULLCOLS
    case study, 4-27
    control file keyword
      SQL*LOader, 5-36
  triggers
    , 8-22
    database insert triggers
      , 8-21
    permanently disabled
      , 8-24
    update triggers
      SQL*Loader, 8-22
  trimming
    summary
      SQL*Loader, 5-77
    trailing whitespace
      SQL*Loader, 5-76
    VARCHAR fields
      SQL*Loader, 5-73
  Trusted Oracle
    migrating with export/import, 2-2
  Trusted Oracle7 Server
    privileges for SQL*Loader, 3-16
  TYPE# column
    SYS.INCEXP table, 1-43

## U

  unique indexes
    Import, 2-24
  unique values
    generating
      SQL*Loader, 5-48
  uniqueness constraints
    Import, 2-48
    preventing errors during import, 2-21
  UNLOAD (DB2 file format)
    not supported by SQL*Loader, B-5
  UNRECOVERABLE keyword
    SQL*Loader, 5-12, 8-18
  unsorted data
    direct path load
      SQL*Loader, 8-17
  updating rows in a table
    SQL*Loader, 5-27
  user definitions
    importing, 2-14
  USER_SEGMENTS view
    Export and, 1-7
  USERID
    Export parameter, 1-21
    Import parameter, 2-29
    SQL*Loader command-line parameter, 6-8
  user-mode Export
    specifying, 1-17
  user-mode Import
    specifying, 2-29

## V

  VARCHAR datatype, 5-51
    specification
      SQL*Loader, 5-9
    SQL*Loader, 5-56
    trimming whitespace
      SQL*Loader, 5-73
  VARCHAR2 datatype, 2-63
    SQL*Loader, 5-50
  VARGRAPHIC datatype, 5-51
    specification
      SQL*Loader, 5-9
    SQL*Loader, 5-55
  variable format records
    vs. fixed
      SQL*Loader, 3-6
  views
    creating views necessary for Export, 1-7
    Export, 1-42

## W

  warning messages, 1-32
  WHEN clause
    discards resulting from
      SQL*Loader, 5-23
    example, 4-18
    field condition
      SQL*Loader, 5-37
    SQL*Loader, 5-34
  whitespace
    included in a field, or not
      SQL*Loader, 5-75
    leading
      SQL*Loader, 5-72
    preserving
      SQL*Loader, 5-78
    terminating a field with
      SQL*Loader, 5-75
    trailing, 5-72
    trimming
      SQL*Loader, 5-72
    WHITESPACE
      SQL*Loader, 5-10
  WHITESPACE keyword
    SQL*Loader, 5-61

## Z

  ZONED datatype, 5-51
    EXTERNAL format
      SQL*LOader, 5-60
      trimming whitespace

SQL*Loader, 5-73

  length versus precision
    SQL*Loader, 5-10
  specification
    SQL*Loader, 5-9
  SQL*Loader, 5-52

Prev
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents