oracle用户迁移数据

###目标库创建表空间存放的文件夹，并授予oracle的权限
cd /
mkdir pmsatt
chown oracle.oinstall pmsatt/ -R

###目标库创建用户、表空间，并授权
su - oracle
sqlplus /as sysdba
create bigfile tablespace pmsatt datafile ‘\pmsatt.dbf’ size 70g autoextend on next 1024m;
create user pmsatt identified by “pm-db68”;
alter user pmsatt default tablespace pmsatt;
grant connect,resource,dba to pmsatt;

###创建directory目标对象 ，（这个导出 导入之前都需要先创建 ）
mkdir /backupdmp //路径指定，注意oracle权限
chown oracle.oinstall /backupdmp/ -R
sqlplus / as sysdba //登陆数据库
create or replace directory expdp as ‘/backupdmp’; //创建目录对象expdp
grant read,write on directory expdp to public; //授予权限
select * from dba_directories; //查看directory

###源库退出到oracle导出用户
expdp “pmsadmin/pm-db68” directory=expdp schemas=pmsadmin dumpfile=exp_user%U.dmp logfile=exp_user.log compression=all parallel=4

###目标库退出到oracle关闭监听
lsnrctl stop

###目标库导入pmsadmin到pmsatt用户（指定表空间、用户）
impdp “pmsatt/pm-db68” directory=expdp remap_tablespace=PMS:pmsatt remap_schema=pmsadmin:pmsatt table_exists_action=truncate dumpfile=exp_user%U.dmp logfile=exp_user.log parallel=4

###目标库进入sqlplus编译无效文件
@$ORACLE_HOME/rdbms/admin/utlrp.sql