oracle创建表空间

最新推荐文章于 2023-05-09 13:23:36 发布

hyy_217

最新推荐文章于 2023-05-09 13:23:36 发布

阅读量237

点赞数

分类专栏： ORACLE

本文链接：https://blog.csdn.net/hyy_217/article/details/71512712

版权

ORACLE 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

create tablespace "T_OA" datafile 'D:/oradata/T_OA.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace T_WFENGINE datafile 'D:/oradata/T_WFENGINE.dbf' size 8M autoextend on next 5M maxsize 10M;
create tablespace T_PUBLISH datafile 'D:/oradata/T_PUBLISH.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace T_portal datafile 'D:/oradata/T_portal.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace I_OA datafile 'D:/oradata/I_OA.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace I_WFENGINE datafile 'D:/oradata/I_WFENGINE.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace I_PUBLISH datafile 'D:/oradata/I_PUBLISH.dbf' size 8M autoextend on next 5M maxsize 200M;
create tablespace T_WORKFLOW datafile 'D:/oradata/T_WORKFLOW.dbf' size 20M autoextend on next 5M maxsize 200M;

create user oa identified by "oa" default tablespace T_OA;
grant resource,connect,dba to oa;

create user workflowengine identified by "workflowengine" default tablespace T_WFENGINE;
grant resource,connect,dba to workflowengine;

create user nwpub identified by "nwpub" default tablespace T_PUBLISH;
grant resource,connect,dba to nwpub;

create user portal identified by "portal" default tablespace T_portal;
grant resource,connect,dba to portal;

create user workflow identified by "workflow" default tablespace T_WORKFLOW;
grant resource,connect,dba to workflow;

grant select any table to oa
ALTER USER OA QUOTA UNLIMITED ON T_OA
grant select any table to workflow
ALTER USER WORKFLOW QUOTA UNLIMITED ON T_WORKFLOW

exp system/starsino@anjioa file=d:/anjiaoa.dmp owner=(oa,workflow)
imp system/starsino@anjioa file=d:/anjiaoa.dmp full=y