dcampus20 是自定义名称
先删除用户和表空间
drop user dcampus20 cascade; DROP TABLESPACE dcampus20 INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE DCAMPUS20_TEMP INCLUDING CONTENTS AND DATAFILES;
创建用户和表空间
CREATE TEMPORARY TABLESPACE DCAMPUS20_TEMP TEMPFILE 'C:\Program Files\Oracle\DCAMPUS20_TEMP.dbf' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; CREATE TABLESPACE DCAMPUS20 LOGGING DATAFILE 'C:\Program Files\Oracle\DCAMPUS20.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL; CREATE USER DCAMPUS20 IDENTIFIED BY digitalcampus DEFAULT TABLESPACE DCAMPUS20 TEMPORARY TABLESPACE DCAMPUS20_TEMP; grant connect,resource,dba to DCAMPUS20; GRANT CREATE SESSION to DCAMPUS20;
在cmd中导入数据
imp dcampus20/digitalcampus@dcampus20 file=D:\Job\文档\dcampus.dmp full=y ignore=y imp dcampus20/digitalcampus@dcampus20 fromuser=dcampus touser=dcampus20 file=D:\Job\文档\dcampus.dmp full=y ignore=y --imp dcampus/digitalcampus@ORCL file=H:\JobFiles\dcampus.dmp full=y ignore=y
