在DOS下
导出
exp userid = ehtemp/ehtemp@localdev LOG=exp_dev_ehtemp.log
compress=n
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
constraints=Y
owner=ehtemp;导入
imp userid = ehtemp/ehtemp@dev
LOG=imp_dev_ehtemp.log
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
Commit=Y
Ignore=N
constraints=Y;
导出
exp userid = ehtemp/ehtemp@localdev LOG=exp_dev_ehtemp.log
compress=n
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
constraints=Y
owner=ehtemp;导入
imp userid = ehtemp/ehtemp@dev
LOG=imp_dev_ehtemp.log
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
Commit=Y
Ignore=N
constraints=Y;
/************导出导入库******************/
/********服务器端*************/
exp system/eport file="oracledatabackup.dmp" log="oracledatabackup.log" owner=(offline_ems3,offline_dec,offline_trn) grants=Y;
imp system/eport file="oracledatabackup.dmp" full=Y Ignore=y;
/********客户端*************/
exp system/eport@服务名 file="oracledatabackup.dmp" log="oracledatabackup.log" owner=(offline_ems3,offline_dec,offline_trn) grants=Y;
imp system/eport@服务名 file="oracledatabackup.dmp" full=Y Ignore=y;
都有存储的信息。