SQL$HELP72.HLB  —  EXPORT  Arguments  WITH_[NO]_EXTENSIONS
    Specifies whether or not the .rbr file created by the EXPORT
    statement includes extensions that are compatible only with
    Oracle Rdb Version 3.0 or higher database systems. The default
    is WITH EXTENSIONS.

    When you specify the WITH NO EXTENSIONS option, the resulting
    interchange (.rbr) file contains only the definitions of the
    domains, the tables, and indexes. Indexes are converted to sorted
    indexes and are minus storage maps. The following conversions
    take place for domains:

    o  TINYINT data types are converted to SMALLINT data types

    o  DATE ANSI, TIMESTAMP, and TIME data types are converted to
       DATE VMS data types

    In addition, all null values are converted to the columns'
    missing value or default to a data type specific missing value.
    For example, null numeric values are replaced by zeros and null
    character values are replaced by blanks.

    When you specify the WITH NO EXTENSIONS option, many features
    of Oracle Rdb databases are not exported. For example, storage
    areas, storage maps, triggers, collating sequences, functions,
    modules, and outlines are not backed up when you specify the WITH
    NO EXTENSIONS argument.

                                   NOTE

       The WITH NO EXTENSIONS option is not compatible with Oracle
       CDD/Repository databases (CDD$DATABASE.RDB). If you attempt
       to export a CDD$DATABASE.RDB database, SQL issues an error
       message stating that the WITH NO EXTENSIONS option is not
       valid for Oracle CDD/Repository databases.
Close Help