SQL$HELP72.HLB  —  EXPORT  Arguments  WITH_[NO]_DATA
    Specifies whether the .rbr file created by the EXPORT statement
    includes the data and metadata contained in the database, or the
    metadata only. The default is WITH DATA.

    When you specify the WITH NO DATA option, the EXPORT statement
    copies metadata, but not the data, from a 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.

                                   NOTE

       The WITH NO DATA 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 DATA option is not valid
       for Oracle CDD/Repository databases.
Close Help