【转】Oracle导入相关的表空间

导入相关的表空间
使用oracle帐号


$


imp uep/U_tywg_2008 file=/export/home/oracle/uep.dmp fromuser=uep touser=uep
imp caffm/U_tywg_2008 file=/export/home/oracle/uep.dmp fromuser=caffm touser=caffm
imp ueppm/U_tywg_2008 file=/export/home/oracle/uep.dmp fromuser=ueppm touser=ueppm

create tablespace UEP include;
create tablespace UEP_PM;
UEP_CAF_FM


导出的表空间
exp uep/U_tywg_2008 owner=uep file=/export/home/oracle/uep.dmp;
exp caffm/U_tywg_2008 owner=caffm file=/export/home/oracle/caffm.dmp;
exp ueppm/U_tywg_2008 owner=ueppm file=/export/home/oracle/ueppm.dmp;