只导入指定表数据:
imp dd/Oracle123@orcl file=\\VBOXSVR\Downloads\dmp\dd.dmp fromuser=dd DATA_ONLY=y buffer=40960000 commit=y tables=tab1,tab2 log=c:\log.log
只导入表结构:
imp dd/Oracle123@orcl file=\\VBOXSVR\Downloads\dmp\dd.dmp fromuser=dd rows=n;
导入数据前,先删除所有触发器:
SELECT
'drop trigger ' || a.table_owner || '.' || trigger_name || ';' SQLtxt
FROM
all_triggers a
WHERE
a.table_owner LIKE 'USER_%';
只导入表数据:
imp dd/Oracle123@orcl file=\\VBOXSVR\Downloads\dmp\dd.dmp fromuser=dd DATA_ONLY=y buffer=40960000 commit=y log=c:\dd.log