How to export using datapump excluding mutiple table in windows [message #630976] |
Wed, 07 January 2015 05:19 |
|
jgjeetu
Messages: 373 Registered: July 2013 Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
Following code is working well, but when i try to pass multiple table names as parameter it gives me error, please tell me how to pass argument for multiple tables in following code.
working code:-
expdp scott/tiger schemas=scott exclude=table:"IN('emp')" directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log
i tried following codes for passing multiple arguments but these are giving syntax error:-
expdp scott/tiger schemas=scott exclude=table:"IN('emp','dept')" directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log
expdp scott/tiger schemas=scott exclude=table:"IN(\'emp\',\'dept\')" directory=DATA_PUMP_DIR dumpfile=test1.dmp logfile=test1.log
please provide me the solution.
[Updated on: Wed, 07 January 2015 05:25] Report message to a moderator
|
|
|
|
|
|
|
|