1、EXP
a>完全模式 full=y EXP USER/PASSWORD@DB (AS ROLE) BUFFER=64000 FILE=C:\FULL.DMP FULL=Y b>用户模式 owner=user EXP USER/PASSWORD@DB BUFFER=64000 FILE=C:\USER.DMP OWNER=USER c>表模式 tables=tab_* EXP USER/PASSWORD@DB BUFFER=64000 FILE=C:\TAB_*.DMP TABLES=(TAB_1, TAB_2) 对tab_1导出加条件 EXP USER/PASSWORD@DB BUFFER=64000 FILE=C:\TAB_*.DMP TABLES=(TAB_1) QUERY=\"WHERE NAME LIKE 'JION%'\"
2、IMP
a>完全模式 full=y IMP USER/PASSWORD@DB (AS ROLE) BUFFER=64000 FILE=C:\FULL.DMP FULL=Y b>用户模式 owner=user IMP USER/PASSWORD@DB BUFFER=64000 FILE=C:\USER.DMP OWNER=USER c>表模式 tables=tab_* IMP USER/PASSWORD@DB BUFFER=64000 FILE=C:\TAB_*.DMP TABLES=(TAB_1, TAB_2)