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

<catalogload_statement> ::= CATALOGLOAD <part_spec> <instream_spec>

You can also use the keywords LOAD CATALOG instead of the keyword CATALOGLOAD.

A data stream was created with the CATALOGEXTRACT command.

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

• CATALOGLOAD ALL
  The entire database catalog is restored from the data stream <instream_spec> using the commands for creating a database session and the SQL statements for data definition.
• CATALOGLOAD USER
  The user that executes the CATALOGLOAD USER command must have the same user name as the owner of the database catalog objects in the data stream <instream_spec>. The database catalog objects in the data stream are restored using the commands for creating a database session and the SQL statements for data definition.
• CATALOGLOAD TABLE
  The user that executes the CATALOGLOAD TABLE command must have the same user name as the owner of the database catalog objects in the data stream <instream_spec>. The database catalog objects in the data stream are restored using the commands for creating a database session and the SQL statements for data definition.

The data stream <instream_spec> is required when loading.

The system table TRANSFORMATIONMODEL and other system tables are filled.

The desired parts of the database catalog are loaded from the data stream <instream_spec> to the database catalog.

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