创建新用户并导入数据
新用户名为testbj 密码为testbj
创建用testbj
drop user testbj cascade;
create user testbj identified by testbj;
创建表空间testbj
create tablespace testbj datafile '/oracledata/app/oracle/oradata/CNRUD/datafile/testbj.dbf' size 10G AUTOEXTEND on next 1G MAXSIZE 30G;
修改用户默认表空间
alter user testbj default tablespace testbj;
用户授权
GRANT CREATE ANY TABLE TO testbj;
GRANT UNLIMITED TABLESPACE TO testbj;
GRANT CONNECT TO testbj;
GRANT RESOURCE TO testbj;
GRANT CREATE ANY VIEW TO testbj;
设置字符集(可选 -可能影响导入后表备注展示)
二选一 (建议与源数据端一致)
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG=SIMPLIFIEDCHINESE_CHINA.ZHS16GBK
imp导入后台执行
nohup imp testbj/testbj@192.168.36.23:1521/cnrud1 full=y file=/oracledata/backup20220401.dmp ignore=y log=impbackup20220427.log > nohup_imp.out &
导入日志可查看
impbackup20220427.log
nohup_imp.out
注意事项:
检查表空间可用空间是否充足
表空间与数据源表空间命名一致
导入用户名与源用户名最好一致