oracle导入数据泵

导入数据泵 sqlplus登录system账号

SQL*Plus: Release 11.2.0.1.0 Production on 星期六 6月 13 16:08:38 2020

Copyright © 1982, 2010, Oracle. All rights reserved.

请输入用户名: system 输入口令:

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace KTYBZHWEB datafile ‘C:\app\34568\admin\orcl\KTYBZHWEB.dbf’ size 1024M autoextend on next 10M maxsize unlimited;

表空间已创建。

SQL> create user OAADMIN identified by root default tablespace KTYBZHWEB;

用户已创建。

SQL> grant connect,dba,resource to OAADMIN;

授权成功。

cmd执行命令 C:\Users\34568>impdp oaadmin/root DIRECTORY=DATA_PUMP_DIR DUMPFILE=expdat.dmp logfile=expdat.log remap_tablespace=LIS1:LIS2 remap_schema=lis1user:lis2user;