首页 / LINUX / linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128）

linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128）

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128），小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含11626字，纯文字阅读大概需要17分钟。

内容图文

1，创建表空间

CREATE TABLESPACE BM   DATAFILE ‘/oradata/mdsdata/mdsmpac001‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE BM_BM   DATAFILE ‘/oradata/mdsdata/mdsmpac002‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE BM_BM_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac003‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE BM_OD   DATAFILE ‘/oradata/mdsdata/mdsmpac4‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE BM_SS   DATAFILE ‘/oradata/mdsdata/mdsmpac5‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE BM_SS_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac6‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE IDX_CTXSYS   DATAFILE ‘/oradata/mdsdata/mdsmpac7‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MDSPICK   DATAFILE ‘/oradata/mdsdata/mdsmpac8‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC         DATAFILE ‘/oradata/mdsdata/mdsmpac9‘ SIZE 200M AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_A       DATAFILE ‘/oradata/mdsdata/mdsmpac10‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_A_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac11‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_B       DATAFILE ‘/oradata/mdsdata/mdsmpac12‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_B_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac13‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_C       DATAFILE ‘/oradata/mdsdata/mdsmpac14‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_C_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac15‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_D       DATAFILE ‘/oradata/mdsdata/mdsmpac16‘ SIZE 50M  AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_D_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac17‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_E    DATAFILE ‘/oradata/mdsdata/mdsmpac18‘ SIZE 50M  AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_EA       DATAFILE ‘/oradata/mdsdata/mdsmpac19‘ SIZE 50M  AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_E_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac20‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_F       DATAFILE ‘/oradata/mdsdata/mdsmpac021‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_F_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac022‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_G       DATAFILE ‘/oradata/mdsdata/mdsmpac023‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_G_IDX       DATAFILE ‘/oradata/mdsdata/mdsmpac024‘ SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_I   DATAFILE ‘/oradata/mdsdata/mdsmpac025‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac026‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_I_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac027‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_LC   DATAFILE ‘/oradata/mdsdata/mdsmpac028‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_LCSGPM   DATAFILE ‘/oradata/mdsdata/mdsmpac029‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_LC_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac030‘ SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_LOG   DATAFILE ‘/oradata/mdsdata/mdsmpac031‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_LOG_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac032‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_M  DATAFILE ‘/oradata/mdsdata/mdsmpac033‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_M_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac034‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_N   DATAFILE ‘/oradata/mdsdata/mdsmpac035‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_N_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac036‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_O   DATAFILE ‘/oradata/mdsdata/mdsmpac037‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_O_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac038‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_P   DATAFILE ‘/oradata/mdsdata/mdsmpac039‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_P_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac040‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_R   DATAFILE ‘/oradata/mdsdata/mdsmpac041‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_R_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac042‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_S   DATAFILE ‘/oradata/mdsdata/mdsmpac043‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_SG   DATAFILE ‘/oradata/mdsdata/mdsmpac044‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_S_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac045‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_T   DATAFILE ‘/oradata/mdsdata/mdsmpac046‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_T_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac047‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_U   DATAFILE ‘/oradata/mdsdata/mdsmpac048‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_U_IDX   DATAFILE ‘/oradata/mdsdata/mdsmpac049‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_QC_TEST01   DATAFILE ‘/oradata/mdsdata/mdsmpac050‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_SVMIDX   DATAFILE ‘/oradata/mdsdata/mdsmpac051‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_SVMRPT   DATAFILE ‘/oradata/mdsdata/mdsmpac052‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_SVMDATA   DATAFILE ‘/oradata/mdsdata/mdsmpac053‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_WSZ   DATAFILE ‘/oradata/mdsdata/mdsmpac054‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE MPAC_ZK   DATAFILE ‘/oradata/mdsdata/mdsmpac055‘ SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

 

 2,创建用户

create user mpaccs identified by mpaccs; alter user mpaccs default tablespace   MPAC quota unlimited on MPAC; alter user mpaccs temporary tablespace temp; grant create trigger to mpaccs ; grant create session to mpaccs ; grant create sequence to mpaccs ; grant create synonym to mpaccs ; grant create table to mpaccs ; grant create view to mpaccs ; grant create procedure to mpaccs ; grant alter session to mpaccs ; grant dba to mpaccs ;

create user mds identified by mds default tablespace MPAC temporary tablespace temp; grant connect to mds; grant resource to mds; grant dba to mds;

create user sgpm identified by sgpm default tablespace MPAC temporary tablespace temp; grant connect to sgpm; grant resource to sgpm; grant dba to sgpm;

create user cj identified by cj default tablespace MPAC temporary tablespace temp; grant connect to cj; grant resource to cj; grant dba to cj;

 

linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128）

标签：temp   limited   cat   mit   source   toe   dba   auto   ted   

本文系统来源：https://www.cnblogs.com/yh62-mds/p/10442572.html

内容总结

以上是互联网集市为您收集整理的linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128）全部内容，希望文章能够帮你解决linux部署Oracle数据库--创建表空间和用户（我的是26的库时间20192271128）所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/504581.html

来源：【匿名】