exp username/psd@sid file='E:\xx.dmp' tables=(xxx_%) ROWS=N
以下代码没什么用,我就乱写
set oracle_sid=ora11g
sqlplus / as sysdba
create directory expdpbak as 'd:\expdpbak';
expdp HBHMP/HBHMP DIRECTORY=expdpbak CONTENT=METADATA_ONLY DUMPFILE=hbhmp.dmp logfile=hbhmp.log