Syntax:
This statement can only be performed by a SYSDBA.
An internal list is generated containing all the users and their base tables (in analogy to CATALOGEXTRACT). All entries that refer to tables residing on other locations are deleted from this list.
TABLEEXTRACT <table name> is executed for each table included in this list. The extracts are appended to the output file which, consequently, consists of a series of table descriptions and table contents of different users.