Syntax:
This statement can only be executed by a SYSDBA.
CREATE statements for all objects of the database catalog are written into the file specified after OUTFILE (* as the filename is not allowed).
GRANT statements are written into the command file for all the privileges granted to other users.
The generated command file contains the following statements:
- CREATE USER for all users and user groups defined in the catalog. Passwords are encrypted.
- CREATE DOMAIN for all DOMAIN definitions,
- CREATE TABLE for all base tables,
- CREATE SYNONYM for all table name synonyms,
- GRANT for all privileges granted to other users,
- CREATE INDEX for all indexes,
- ALTER TABLE ... FOREIGN KEY for all link associations,
- CREATE VIEW for all view tables,
- statements for reloading triggers and DB procedures,
- COMMENT ON for all comments.
The statements are written to the command file in an executable order.
Where required, OWNER statements are written into the generated command file. These serve to associate the objects with their original owners when restoring the catalog.
These OWNER statements are executed and the passwords are decrypted successfully only when the command file is performed with CATALOGLOAD ALL.