TABLESPACES parameter specifies that all tables in the specified tablespace be exported to the Export dump file. This includes all tables contained in the list of tablespaces and all tables that have a partition located in the list of tablespaces. Indexes are exported with their tables, regardless of where the index is stored.
You must have the
EXP_FULL_DATABASE role to use
TABLESPACES to export all tables in the tablespace.
TABLESPACES is used in conjunction with
TRANSPORT_TABLESPACE=y, you can specify a limited list of tablespaces to be exported from the database to the export file.