--创建表空间
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
