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

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

阅读量：5314 次

发布时间：2019-06-14

本文共 11073 字，大约阅读时间需要 36 分钟。

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;

转载于:https://www.cnblogs.com/yh62-mds/p/10442572.html

你可能感兴趣的文章

HDU(4528)，BFS，2013腾讯编程马拉松初赛第五场(3月25日)