oracle导出数据
C:\Users\EDY>exp puser/test@localhost/orclpdb file=E:/backup/20220519/puser.dmp owner=(puser)
oracle导入数据
C:\Users\EDY>sqlplus system/sys as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on 星期四 5月 19 15:47:03 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter session set container=orclpdb;
会话已更改。
SQL> create user puser_test identified by test;
用户已创建。
SQL> grant dba to puser_test;
授权成功。
SQL> exit;
从 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 断开
C:\Users\EDY>imp puser_test/test@localhost/orclpdb file=E:\20220519\puser.dmp full=y
