You can use this SAP DB Loader command to control the unloading of the entire database catalog or parts of it.

<catalogextract_statement> ::= CATALOGEXTRACT <part_spec> <outstream_spec>

You can also use the keywords EXTRACT CATALOG instead of the keyword CATALOGEXTRACT.

THE command CATALOGEXTRACT ALL can only be executed by the SYSDBA user.

• CATALOGEXTRACT ALL
  The data stream <outstream_spec> contains all commands for creating a database session and SQL statements for data definition that are required for the definition of the entire database catalog.
• CATALOGEXTRACT USER
  The data stream <outstream_spec> contains all commands for creating a database session and SQL statements for data definition that are required for the definition of the parts of the database catalog that belong to the specified user.
• CATALOGEXTRACT TABLE
  The specified table is a base table. The user is the owner of this table.
  The data stream <outstream_spec> contains all SQL statements for data definition that are required for the definition of the table the database catalog objects connected to it.

During unloading, the data stream <outstream_spec> is created for the database catalog definitions.

The system table TRANSFORMATIONMODEL and other system tables are filled.

The desired parts of the database catalog are unloaded to the data stream <outstream_spec>.

You can use the corresponding CATALOGLOAD command to restore these database catalog objects.

The unload process cannot be successfully completed. In this case, the SAP DB Loader logs the cause of the error in the log file.