Default: ALL
Purpose
Syntax and Description
CONTENT=[ALL | DATA_ONLY | METADATA_ONLY]
ALL
unloads both data and metadata. This is the default.
DATA_ONLY
unloads only table row data; no database object definitions are unloaded.
METADATA_ONLY
unloads only database object definitions; no table row data is unloaded. Be aware that if you specify CONTENT=METADATA_ONLY
, then when the dump file is subsequently imported, any index or table statistics imported from the dump file will be locked after the import.
Restrictions
The CONTENT=METADATA_ONLY
parameter cannot be used with the TRANSPORT_TABLESPACES
(transportable-tablespace mode) parameter or with the QUERY
parameter.
Example
The following is an example of using the CONTENT
parameter:
> expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp CONTENT=METADATA_ONLY
This command will execute a schema-mode export that will unload only the metadata associated with the hr
schema. It defaults to a schema-mode export of the hr
schema because no export mode is specified.