备份某个用户下以xxx开头的表

备份某个用户下以xxx开头的表

create directory export_dir as  'D:\export';

 

grant read,write on directory export_dir to scott;



Expdp scott/tiger DIRECTORY=export_dir DUMPFILE=tab.dmp TABLES=xxx% logfile=exp.log;