(Contents)(Next)

DBEXTRACT

DBEXTRACT combines the two statements CATALOGEXTRACT ALL and TABLEEXTRACT ALL to form one statement. This statement along with DBLOAD is the only way to migrate the procedural database objects TRIGGER, DBPROCEDURE, and DBFUNCTION with LOAD means.

Syntax:

The first generated output file is a plaintext file. It contains the catalog definitions. The second output file is not readable. It contains the table contents.

DBEXTRACT can only be executed by a SYSDBA.


(Contents)(Next)