Oracle 导入.dmp和.log文件

0x00 创建导入文件夹并授予权限

SQL>show user
USER IS "SYS"

crate directory data_hehe as '导入文件夹路径'
grant read,write on directory data_hehe to scott;

0x01 导入数据库

SQL>show user
USER IS "SYS"

#注意 用户名一定要与导出的.dmp里写的用户名一直
SQL>create user LIBSYS(用户名) identity by LIBSYS(密码)
2 DEFAULT TABLESPACE users;
3 quota 20g on users

grant connect to LIBSYS;

cd   导入文件夹路径

imp system/oracle FULL=y file=one.dmp log=one.log
linux

Comments