-- Export all public database links
expdp user/password full=y \
include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')"
-- Export one table
expdp user/password include=table:"in ('<TABLE_NAME>')"
-- Valid values for "INCLUDE" statement
select * from DATABASE_EXPORT_OBJECTS;
select * from SCHEMA_EXPORT_OBJECTS;
select * from TABLE_EXPORT_OBJECTS;
Comments