导出
exp userid=test/test file=./db_str.dmp log=./db_str.log full=y rows=n compress=y direct=y
exp userid=test/test file=./db_str.dmp log=./db_str.log owner=bmflow compress=y direct=y
导入
imp userid=gkh/bmflow file=expdat.dmp fromuser=bmflow touser=gkh
sqlplus中
$exp username/password@servername owner=username rows=y file=D:\20100521.dmp;
$imp username/password@servername fromuser=fr0mUserName touser=toUserName file=D:\20100521.dmp rows=y;
其中,rows=n 不带数据;rows=y 带数据。
servername通过Net Configuration Assistant的本地net服务名配置
exp userid=test/test file=./db_str.dmp log=./db_str.log full=y rows=n compress=y direct=y
exp userid=test/test file=./db_str.dmp log=./db_str.log owner=bmflow compress=y direct=y
导入
imp userid=gkh/bmflow file=expdat.dmp fromuser=bmflow touser=gkh
sqlplus中
$exp username/password@servername owner=username rows=y file=D:\20100521.dmp;
$imp username/password@servername fromuser=fr0mUserName touser=toUserName file=D:\20100521.dmp rows=y;
其中,rows=n 不带数据;rows=y 带数据。
servername通过Net Configuration Assistant的本地net服务名配置