****全库Expdp导出,再全库Impdp导入****
源系统:
操作系统:CentOS
Oracle数据库版本:Oracle11g Enterprise Edition Release 11.2.0.1.0
SID:orcl
端口:1521
目标系统:
操作系统:Windows 2012
Oracle数据库版本:Oracle11g Enterprise Edition Release 11.2.0.1.0
SID:orcl
端口:1521
源系统和目标系统都建立账号
create user username identified by password;
grant connect,resoure to username;
赋予expdp和impdp命令权限:
grant exp_full_database,imp_full_database to username;
SQL> create user migrate identified by migrate;
User created
SQL> grant connect,resource,dba to migrate;
Grant succeeded
SQL> grant exp_full_database,imp_full_database to migrate;
Grant succeeded
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ------------------------