Oracle 新建表空间和导入数据

来源：互联网发布：2017淘宝总消费怎么查编辑：程序博客网时间：2024/06/07 07:52

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

0 0