Oracle数据库导入含有Blob字段的表的dmp文件

--创建表空间
create tablespace QHDZW
datafile 'D:\app\lyl\product\11.2.0\dbhome_1\QHDZW.dbf'
size 50M
autoextend on next 50m maxsize 2048m
extent management local;

--创建临时表空间
create temporary tablespace qhdzw_temp
tempfile
'D:\app\lyl\product\11.2.0\dbhome_1\qhdzw_temp.dbf'
size 32m
autoextend on next 32m maxsize 1024m
extent management local;

--创建用户
create user qhd identified by qhd default tablespace QHDZW
temporary tablespace qhdzw_temp;

--用户授权
grant connect,resource to qhd;
grant dba to qhd;
-----------------为了防止临时表空间超，增加临时表空间
alter tablespace QHDZW
add datafile 'D:\APP\LYL\PRODUCT\11.2.0\DBHOME_1\QHDZW02.DBF'
size 1024M autoextend on next 50M maxsize unlimited;

alter database datafile 'D:\APP\LYL\PRODUCT\11.2.0\DBHOME_1\QHDZW02.DBF' autoextend on;

alter tablespace QHDZW
add datafile 'D:\APP\LYL\PRODUCT\11.2.0\DBHOME_1\QHDZW03.DBF'
size 1024M autoextend on next 50M maxsize unlimited;

alter database datafile 'D:\APP\LYL\PRODUCT\11.2.0\DBHOME_1\QHDZW03.DBF' autoextend on;

---------------导入
imp 'qhd/qhd@whzd' full=y file=D:\oracle-2019-02-18.DMP log=d:\whzd1.log

注意：如果导入的表空间名称和用户名称和当前表空间和用户不同， 可以在当前表空间中先建表，然后导入语句
先建表：imp combiz/eyoucom@combiz file=D:\sfw.dmp full=y rows=n
再导入：imp combiz/eyoucom@combiz file=D:\sfw.dmp full = y ignore=y