Oracle7 Server Utilities User's Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents



Go to previous file in sequence


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]
  • 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
  • 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
  • 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
  • GRANTS
  • GRAPHIC datatype
  • GRAPHIC EXTERNAL datatype
  • HELP
  • hexadecimal strings
  • 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
  • key values, generating, SQL*Loader
  • 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
  • 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
  • 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
  • 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
  • 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
  • quotation marks
  • 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
  • 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
  • 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
  • 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
  • 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]
  • warning messages
  • WHEN clause
  • WHITESPACE keyword, SQL*Loader
  • whitespace
  • ZONED datatype


    Go to previous file in sequence

    Oracle
    Copyright © 1996 Oracle Corporation.
    All Rights Reserved.
    Go to Product Documentation Library
    Library
    Go to books for this product
    Product
    Go to Contents for this book
    Contents