SQL$HELP72.HLB  —  IMPORT
    Creates an Oracle Rdb database from an interchange .rbr file.

    You use the IMPORT statement with the EXPORT statement to make
    changes to Oracle Rdb databases that cannot be made any other
    way. The EXPORT statement unloads a database to an .rbr file.
    The IMPORT statement re-creates the database with changes that
    may not be allowed by an ALTER DATABASE statement. The IMPORT
    statement lets you:

    o  Convert from a single-file to a multifile database, and vice
       versa.

    o  Change database root file parameters that you cannot change
       with the ALTER DATABASE statement:

       -  COLLATING SEQUENCE

       -  SEGMENTED STRING STORAGE AREA

       -  PROTECTION IS ANSI/ACLS

       -  DEFAULT STORAGE AREA

    o  Change storage area parameters that you cannot change with the
       ALTER DATABASE statement:

       -  PAGE SIZE

       -  PAGE FORMAT

       -  THRESHOLDS

       -  INTERVAL

       -  FILENAME, SNAPSHOT FILENAME

    o  Reload tables with existing rows to take advantage of newly
       created hashed indexes.

    o  Reload tables to take advantage of new or changed storage
       maps.

    o  Move a database to another directory or disk structure.
       However, if moving a database is the only change you need
       to make, it is more efficient to use the RMU Backup and RMU
       Restore commands.

    o  Create an empty target database that uses the same data
       definitions as a source database by copying the metadata,
       but not the data, to the target.

       If you use the NO DATA option, the IMPORT statement creates an
       Oracle Rdb database whose metadata is identical to that found
       in the source database used by the EXPORT statement, but the
       duplicate database contains no data. The NO DATA option is not
       compatible with the repository databases. See the description
       in the Arguments section under the NO DATA option.
Additional Information: explode extract
Environment Format Arguments Examples

DCE$IMPORT_HELP.HLB

Close Help