oracle 导入 dmp 文件

Oracle 导入 dmp 文件

赋予导入数据库权限
需要sysdba登录赋予权限

1
2
3
GRANT IMP_FULL_DATABASE to username;

GRANT IMP_FULL_DATABASE to scott;

然后导入数据库

1
2
3
imp username/[email protected]:port/servername file=db.dmp full=y ignore=y buffer=640000;

imp scott/[email protected]:1521/orcl file=E:/xxx.dmp full=y ignore=y buffer=64000;