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;