Oracle 新建表空间和导入数据

最新推荐文章于 2024-03-20 17:03:13 发布

鱼草野

最新推荐文章于 2024-03-20 17:03:13 发布

阅读量1.6k

点赞数

分类专栏： oracle11g 文章标签： oracle

本文链接：https://blog.youkuaiyun.com/yucaoye/article/details/61915579

版权

oracle11g 专栏收录该内容

8 篇文章

订阅专栏

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