数据库导库
1,新增表空间和用户
在sql工具里输入
create tablespace zxyy datafile ‘D:\oracle\zxyy.dbf’ size 500M autoextend on next 128M extent management local uniform size 128K;
create temporary tablespace zxyy_temp tempfile ‘D:\oracle\zxyy_temp.dbf’ size 50m autoextend on next 50m maxsize 20480m extent management local;
CREATE USER zxyy IDENTIFIED BY 1 DEFAULT TABLESPACE zxyy TEMPORARY TABLESPACE zxyy_temp;
grant connect,dba to zxyy;
创建导入目录
create or replace directory impdir as ‘d:\oracle\zxyy’
2,导入数据
打开cmd命令,直接输入
impdp zxyy/1@127.0.0.1/orcl directory=impdir dumpfile=ZXYY-20211010.DMP remap_tablespace=NNC_DATA01:zxyy,NNC_INDEX01:zxyy,NNC_DATA02:zxyy,NNC_DATA03:zxyy remap_schema=HZSLYY:zxyy full=y
3,报错
无法通过 16 (在表空间 ZXYY 中) 扩展 ORA-39171: 作业出现可恢复的等待。
在sql里执行: alter tablespace zxyy add datafile ‘D:\oracle\zxyy3.dbf’ size 500M autoextend on next 128M maxsize unlimited;