(B)0[m[4mEXPORT[m q> database-file-spec q>INTO q> interchange-file-spec qk
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqwqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqwqqqqqqq>
mq> [4mWITH[m qqqqqwqqq> [4mEXTENSIONS[m qqqqqqqu
tqqq> [4mNOEXTENSIONS[m qqqqqu
tqqq> [4mDATA[m qqqqqqqqqqqqqu
mqqq> [4mNODATA[m qqqqqqqqqqqj
1 – database-file-spec
The file specification for the database you want to export. Use
either a full or partial file specification or a logical name.
If you use a simple file name, Oracle Rdb looks for the database in
the current default directory. If you do not specify a file type,
Oracle Rdb uses RDB.
2 – interchange-file-spec
The file specification for a file in which EXPORT places an
intermediate version of the database. Use either a full or
partial file specification or a logical name. If you use a simple
file name, Oracle Rdb places the interchange file in the current
default directory. The default file type is RBR.
3 – WITH_EXTENSIONS
Specifies whether the exported format of the database is
compatible with a pre-Version 3.0 Oracle Rdb database (WITH
NOEXTENSIONS), or with an Oracle Rdb database created with Version
3.0 Oracle Rdb software or higher (WITH EXTENSIONS). The default is
WITH EXTENSIONS. The WITH EXTENSIONS option also directs Oracle Rdb
to preserve other parameters about the physical structure of
the exported database. Use WITH NOEXTENSIONS when you export
a database that you plan to import on pre-Version 3.0 Oracle Rdb
software.
When you specify the WITH NOEXTENSIONS option, null flags for
missing value fields are not exported, therefore numeric missing
values are replaced by zeros and character missing values are
replaced by blanks.
Note also that when you specify the WITH NOEXTENSIONS option,
features of Version 3.0 and higher Oracle Rdb databases are not
exported. Storage maps, triggers, and collating sequences, for
example, are not backed up when you specify the WITH NOEXTENSIONS
option.
The WITH NOEXTENSIONS option is not compatible with data
dictionary databases (CDD$DATABASE.RDB). If you attempt to export
a CDD$DATABASE.RDB database, RDO issues an error message stating
that the NOEXTENSIONS option is not valid for data dictionary
databases.
4 – WITH_DATA
Specifies whether the RBR file includes the data and metadata
contained in the database (WITH DATA), or the metadata only (WITH
NODATA). The default is WITH DATA.
When you specify the WITH NODATA option, the EXPORT statement
copies metadata from the source database to an RBR file. Use the
IMPORT statement to generate an empty database whose metadata is
identical to that of the source database.
The WITH NODATA option is not compatible with data dictionary
databases (CDD$DATABASE.RDB). If you attempt to export a
CDD$DATABASE.RDB database, RDO issues an error message stating
that the NODATA option is not valid for data dictionary
databases.