Example 2-1 shows a table-mode export, specified using the TABLES
parameter. Issue the following Data Pump export command to perform a table export of the tables employees
and jobs
from the human resources (hr
) schema:
Because user hr
is exporting tables in his own schema, it is not necessary to specify the schema name for the tables. The NOLOGFILE=YES
parameter indicates that an Export log file of the operation will not be generated.