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.