前提:Oracle 10 导出文件为nbzyjk926.dmp
环境centOS,oracle11g
1. 创建用户
1.1 创建表空间
create tablespace yz_ohsms logging datafile '/orcl/app/oracle/oradata/orcl/yz_ohsms01.dbf' size 32m autoextend on next 32m maxsize 10000m extent management local;
1.2 创建用户
create user yz_ohs identified by oracle_hx default tablespace yz_ohsms;
1.3 授权给用户
grant dba, unlimited tablespace to yz_ohs;
1.4 测试用户
conn yz_ohs/oracle_hx;
2. 拷贝文件备份文件
mv /home/software/nbzyjk926.dmp /orcl/databak/nbzyjk926.dmp
3. 导入文件
imp yz_ohs/oracle_hx file=/orcl/databak/nbzyjk926.dmp fromuser=NB_ZYJK touser=yz_ohs ignore=y