Oracle7 Server Utilities Index

Contents Index Home

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

  • check constraints, Import
  • clusters
  • columns
  • command-line parameters
  • comments
  • COMMIT, Import parameter
  • complete exports [2]
  • COMPRESS, Export parameter [2]
  • CONCATENATE keyword, SQL*Loader
  • connecting to a database, importing user definitions, Import
  • consistent views, exporting
  • CONSISTENT, Export parameter
  • consolidating extents, Export parameter COMPRESS
  • CONSTANT keyword
  • constraints
  • continuation fields, SQL*Loader
  • CONTINUE_LOAD keyword, SQL*Loader
  • CONTINUEIF keyword
  • continuing interrupted loads, SQL*Loader
  • control files
  • CONTROL, SQL*Loader command-line parameter
  • conventional path loads, basics [2]
  • CREATE SESSION privilege
  • CREATE USER, Import
  • CTIME column, Export
  • cumulative exports [2]

    D

  • data conversion, description, SQL*Loader
  • data definition language
  • data field, specifying the datatype, SQL*Loader
  • data mapping, concepts, SQL*Loader
  • data path loads, direct and conventional
  • data recovery, direct path load, SQL*Loader
  • database administrator (DBA), privileges, for export
  • database objects
  • databases
  • data
  • datafiles
  • data
  • datatypes
  • data
  • DATE datatype
  • date mask, SQL*Loader
  • DB2 load utility
  • DBA role, EXP_FULL_DATATBASE role
  • DBCS (DB2 double-byte character set), not supported by Oracle
  • DBHIGH system label, Trusted Oracle7 Server
  • DBMS MAC database, Trusted Oracle7 Server
  • DDL
  • DECIMAL datatype
  • DEFAULT column values, Oracle Version 6 export files
  • DEFAULTIF keyword
  • DELETE ANY TABLE privilege, SQL*Loader
  • DELETE CASCADE, SQL*Loader [2]
  • DELETE privilege, SQL*Loader
  • delimited data, maximum length, SQL*Loader
  • delimited fields, field length, SQL*Loader
  • delimited files, reading, Export
  • delimiter_spec, SQL*Loader
  • delimiters
  • DESTROY, Import parameter
  • direct load state, indexes left in direct load state
  • Direct path exports
  • direct path load
  • DIRECT
  • DISABLED_CONSTRAINTS keyword, SQL*Loader
  • discard file
  • discarded records
  • DISCARDMAX keyword, discarded records, SQL*Loader
  • DISCARDMAX, SQL*Loader command-line parameter
  • DISCARD, SQL*Loader command-line parameter
  • discontinued loads, continuing, SQL*Loader
  • DOUBLE datatype
  • dropped snapshots, Import
  • dropping, indexes, to continue a direct path load, SQL*LOader

    E

  • EBCDIC file conversion
  • EBCDIC to ASCII conversion, Import [2]
  • eight-bit character set support, See National Language Support
  • enclosed fields
  • enclosure delimiters
  • ending column of a field, SQL*Loader
  • error handling
  • error messages
  • errors
  • escape character, quoted strings, SQL*Loader
  • EXCEPTIONS keyword, SQL*Loader
  • EXP-00024, fatal error message
  • EXP_FULL_DATABASE role [2] [3]
  • EXP_FULL_DATABASE, export modes
  • EXPDAT.DMP, Export output file [2]
  • EXPDATE column, Export
  • EXPFILE column, Export
  • EXPID column
  • export file
  • Export modes
  • export views, establishing, Export
  • Export/Import, using Oracle Version 6 files
  • Export
  • exporting database objects, log files
  • Export, interactive mode [2]
  • EXPTYPE column, Export
  • EXPUSER column, Export
  • EXPVEW.SQL
  • extent allocation, FILE, SQL*Loader command line parameter
  • extents
  • EXTERNAL datatypes
  • EXTERNAL keyword, SQL*Loader

    F

  • fatal errors
  • FEEDBACK
  • field conditions, specifying, SQL*Loader
  • field length, specifications, SQL*Loader
  • FIELDS clause
  • fields
  • file format, export files
  • FILE
  • filenames
  • files
  • FILE, SQL*Loader command-line parameter
  • files
  • fixed format records, SQL*Loader
  • FIXED keyword, obsoleted
  • fixed-format records
  • FLOAT datatype
  • FLOAT EXTERNAL data values, SQL*Loader
  • FLOAT keyword, SQL*Loader
  • FORMAT statement in DB2, not allowed by SQL*Loader
  • formats, and input records, SQL*Loader
  • formatting errors, SQL*Loader
  • fragmentation, reducing database fragmentation via full export/import
  • FROMUSER, Import parameter
  • FTP, Export files
  • FULL database export
  • FULL database import
  • FULL, Import parameter

    G

  • GRANTS
  • GRAPHIC datatype
  • GRAPHIC EXTERNAL datatype

    H

  • HELP
  • hexadecimal strings

    I

  • IBM Code Page 500 files
  • IGNORE parameter, Import [2]
  • IMP_FULL_DATABASE role [2]
  • Import/Export, using Oracle Version 6 files
  • Import
  • incremental export
  • incremental export/import
  • incremental export
  • incremental import parameter
  • INCTYPE
  • INDDN keyword, SQL*Loader [2]
  • index options
  • indexes
  • INDEXFILE, Import parameter
  • INFILE keyword, SQL*Loader [2]
  • INSERT errors
  • INSERT into table, SQL*Loader
  • INSERT keyword, SQL*Loader
  • instance recovery, direct path load, SQL*Loader
  • INTEGER datatype [2]
  • integrity constraints
  • interrupted loads, continuing, SQL*Loader
  • INTO TABLE clause, effect on bind array size, SQL*Loader
  • INTO TABLE statement
  • invalid data, Import
  • invalid objects, warning messages, during export
  • ITIME column, Export

    J

    K

  • key values, generating, SQL*Loader

    L

  • labels
  • language support, see National Language Support
  • leading whitespace
  • length indicator, determining size, SQL*loader
  • length of a numeric field, SQL*Loader
  • length subfield, VARCHAR DATA, SQL*Loader
  • length, specifying record length for export
  • loading
  • LOAD, SQL*Loader command-line parameter
  • log files
  • log file, specifying, SQL*Loader
  • log files
  • LOG, Export parameter [2]
  • logical records
  • LOG
  • LONG columns
  • LONG data
  • LONG RAW data, importing, errors
  • LXBCNF executable
  • LXEGEN executable
  • LXINST executable

    M

  • Mandatory Access Control, MLS export parameter, Trusted Oracle7 Server
  • master table
  • media protection, disabling for direct path loads, SQL*Loader
  • media recovery
  • memory, controlling usage, SQL*Loader
  • messages
  • missing data columns, SQL*Loader
  • MLS_LABEL_FORMAT, Export parameter, Trusted Oracle7 Server
  • MLS_LISTLABELS, Import parameter, Trusted Oracle7 Server
  • MLS_MAPFILE, Import parameter, Trusted Oracle7 Server
  • MLS, Export parameter, Trusted Oracle7 Server [2]
  • MLSLABEL datatype, SQL*Loader, Trusted Oracle7 Server [2]
  • MLSLABEL, field masks, SQL*Loader, Trusted Oracle7 Server
  • Multi Level-Security labels, MLS export paramter, Trusted Oracle7 Server
  • multi-byte character sets
  • multiple CPUs, SQL*Loader
  • multiple table load
  • multiple-column indexes, SQL*Loader

    N

  • National Language Support (NLS)
  • National Language Support
  • native datatypes
  • negative numbers, loading, SQL*Loader
  • network issues, Export
  • networks
  • NLS Calendar Utility
  • NLS Data Installation Utility
  • NLS_LANG
  • NLS, see National Language Support
  • Non-fatal errors, warning messages
  • normalizing data during a load, SQL*Loader
  • NOT NULL constraint, load method, SQL*Loader
  • not null constraints, Import
  • null columns
  • null data
  • NULLIF keyword
  • NULLIF...BLANKS keyword, SQL*Loader
  • NULLIF...BLANKS, case study
  • NUMBER datatype, SQL*Loader
  • numeric EXTERNAL datatypes
  • numeric fields, precision versus length, SQL*Loader

    O

  • object names, SQL*Loader
  • objects
  • obsolete parameters
  • online help
  • operating systems, moving data to different systems, SQL*Loader
  • OPTIMAL, storage parameter
  • optimizing
  • OPTIONALLY ENCLOSED BY, SQL*Loader [2]
  • OPTIONS keyword, for parallel loads, SQL*Loader [2]
  • ORA_NLS environment variable [2]
  • Oracle Version 6
  • ORANLS option [2]
  • OS MAC database, Trusted Oracle7 Server
  • output file, specifiying for Export
  • OWNER, Export parameter

    P

  • packed decimal data, SQL*Loader
  • padding of literal strings, SQL*Loader
  • PARALLEL keyword, SQL*Loader
  • parallel loads
  • PARALLEL, SQL*Loader command-line parameter
  • parameter file
  • parameters
  • PARFILE, Export command line option [2]
  • PART statement in DB2, not allowed by SQL*Loader
  • partitioned load, SQL*Loader
  • partitioned tables in DB2, no Oracle equivalent
  • passwords, hiding
  • performance improvement, conventional path for small loads
  • performance
  • physical versus logical records, SQL*Loader
  • PIECED keyword, SQL*Loader
  • POSITION keyword
  • precision of a numeric field versus length, SQL*Loader
  • predetermined size fields, SQL*Loader
  • prerequisites, SQL*Loader
  • PRESERVE BLANKS keyword, SQL*Loader
  • presorting data for a direct path load, case study
  • primary keys, Import
  • privileges

    Q

  • quotation marks

    R

  • RAW datatype
  • read-consistent export [2]
  • read-only tablespaces
  • READBUFFERS keyword, SQL*Loader [2]
  • RECLEN keyword, obsoleted
  • RECNUM keyword
  • recompiling, stored functions, procedures, and packages
  • RECORD, Export parameter
  • RECORDLENGTH
  • records
  • RECORD, SQL*Loader parameter, obsoleted
  • records
  • RECOVERABLE keyword, SQL*Loader
  • recovery
  • redo log files
  • REENABLE keyword, SQL*Loader
  • referential integrity constraints
  • refresh error, snapshots, Import
  • reject file, specifying, SQL*Loader
  • rejected records, SQL*Loader [2]
  • relative field positioning
  • Release 7.0 features
  • Release 7.1 features
  • Release 7.2 features, Export/Import
  • remote operation, Export/Import
  • REPLACE keyword, SQL*Loader
  • REPLACE table
  • reserved words, SQL*Loader
  • resource errors, Import
  • restrictions
  • RESUME, DB2 keyword, SQL*Loader equivalents
  • roles, EXP_FULL_DATABASE [2] [3] [4] [5]
  • rollback segments
  • row errors, Import
  • ROWID, Import
  • rows

    S

  • schemas
  • scientific notation for FLOAT EXTERNAL
  • secondary database, importing
  • secure databases
  • segments, temporary, FILE keyword, SQL*Loader
  • SEQUENCE keyword, SQL*Loader
  • sequence numbers
  • sequences
  • short records with missing data, SQL*Loader
  • SHORTINT, C Language datatype
  • SHOW, Import parameter [2]
  • SILENT, SQL*Loader command-line parameter
  • single table load, discontinued, SQL*Loader
  • single-byte character sets, Import
  • SINGLEROW, SQL*Loader
  • SKIP
  • SMALLINT datatype
  • snapshot log, Import
  • snapshots
  • SORTED INDEXES
  • sorting
  • SQL operators, applying to fields, SQL*Loader
  • SQL statements, executing, Import
  • SQL string
  • SQL*Loader
  • SQL*Net
  • SQL/DS option (DB2 file format), not supported by SQL*Loader
  • starting column of a field, SQL*Loader
  • STATISTICS
  • storage parameters
  • stored functions, importing
  • stored packages, importing
  • stored procedures
  • stream format records, SQL*Loader [2]
  • STREAM keyword, obsoleted
  • string comparisons, SQL*Loader [2]
  • synonyms
  • syntax diagrams
  • syntax, data definition language, SQL*Loader
  • SYS.INCEXP
  • SYS.INCFIL
  • SYS.INCVID
  • SYSDATE datatype
  • SYSDATE keyword, SQL*Loader
  • SYS, exporting objects owned by
  • system objects, importing [2]
  • system tables, incremental export

    T

  • tables
  • tablespaces
  • tables
  • tabs
  • temporary segments
  • temporary storage in a direct path load
  • TERMINATED BY, SQL*Loader [2]
  • terminated fields
  • TOUSER, Import parameter
  • trailing blanks, loading with delimiters, SQL*Loader
  • TRAILING NULLCOLS
  • trailing, whitespace, trimming, SQL*Loader
  • triggers
  • trimming
  • TRUNCATE keyword, SQL*Loader
  • Trusted Oracle7 Server

    U

  • unclustered tables
  • unique indexes, Import
  • unique values, generating, SQL*Loader
  • uniqueness constraints, Import
  • uniqueness contraints, preventing errors during import
  • UNLOAD (DB2 file format), not supported by SQL*Loader
  • UNRECOVERABLE keyword, SQL*Loader [2]
  • unsorted data, direct path load, SQL*Loader
  • updating rows in a table, SQL*Loader
  • user definitions, importing
  • user export mode
  • USER_SEGMENTS view, table sizes [2]
  • USERID
  • users, user definition, Import

    V

  • VARCHAR datatype
  • VARCHAR2 datatype, SQL*Loader
  • VARCHAR2 dtatatype
  • VARGRAPHIC datatype
  • variable format records, SQL*Loader [2]
  • VARIABLE, SQL*Loader keyword, obsoleted
  • views, creating views necessary for Export [2]

    W

  • warning messages
  • WHEN clause
  • WHITESPACE keyword, SQL*Loader
  • whitespace

    X

    Y

    Z

  • ZONED datatype