friends..
db = 11gr2
os= linux
I am trying to export few tables and synonyms of a user but expdp gives error as
"UDE-00010: multiple job modes requested, schema and tables"
If I remove schema parameter and add schema name to table then it will give error as
"ORA-39038: object path "Synonym" is not supported for TABLE jobs"
any idea on how to include tables and synonym of a user in one export job?
parfile used:
DIRECTORY= DATA_PUMP
DUMPFILE = TEST.DMP
LOGFILE = TEST.LOG
CONTENT=ALL
SCHEMAS = OPS$TEST
TABLES = TAB1, TAB2, TAB3
INCLUDE = SYNONYM:"IN('SYN1','SYN2')"
EXCLUDED = STATISTICS, OBJECT_GRANT, USER
thank you...
typo edited.