创建账户
进入oracle
sqlplus / as sysdba;
查询 pbd
select pdb_id,pdb_name,dbid,status,creation_scnfrom dba_pdbs;
切换PBD模式
alter sessionset container=ORCLPDB1;
创建账户 newfs
账户:newfs 密码:123456
create user newfs identifiedby 123456default tablespace userstemporary tablespacetemp;
授权账户权限
grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to newfs;
创建成功 账户(newfs)
地址:192.168.183.240
端口:1521
服务名:ORCLPDB1
用户名:newfs
密码:123456
创建账户 enterprise
账户:enterprise 密码:123456
create user enterpriseidentifiedby 123456default tablespace userstemporary tablespacetemp;
授权账户权限
grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to enterprise;
创建成功 账户(enterprise)
地址:192.168.183.240
端口:1521
服务名:ORCLPDB1
用户名:newfs
密码:123456
导入数据
授权oracle权限:
示例:
chown -R oracle:oinstall expdb_20210305_1.dmp
切换oracle账户:
su - oracle
导入数据:
示例:impdp 账户/密码@IP:PORT/服务名 dumpfile=文件.dmp grants=no full = y;
impdp newfs/123456@192.168.183.240:1521/ORCLPDB1 dumpfile=expdb_20210305_1.dmp grants=no full = y;
移动数据到黄线路径
再次执行导入:
示例:
impdp newfs/123456@192.168.183.240:1521/ORCLPDB1 dumpfile=expdb_20210305_1.dmp grants=no full = y;
完成导入
文章来源: blog.csdn.net,作者:鲁先生.,版权归原作者所有,如需转载,请联系作者。
原文链接:blog.csdn.net/lulongji2035/article/details/114526875