createuserortablespace

create tablespace MPAC datafile '/app/datafile/orcl/MPAC.ora' size 5000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_M datafile '/app/datafile/orcl/MPAC_M.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_G datafile '/app/datafile/orcl/MPAC_G.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_B datafile '/app/datafile/orcl/MPAC_B.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_S datafile '/app/datafile/orcl/MPAC_S.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_I datafile '/app/datafile/orcl/MPAC_I.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_N datafile '/app/datafile/orcl/MPAC_N.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_O datafile '/app/datafile/orcl/MPAC_O.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_P datafile '/app/datafile/orcl/MPAC_P.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_R datafile '/app/datafile/orcl/MPAC_R.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_U datafile '/app/datafile/orcl/MPAC_U.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_I_IDX datafile '/app/datafile/orcl/MPAC_I_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_N_IDX datafile '/app/datafile/orcl/MPAC_N_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_O_IDX datafile '/app/datafile/orcl/MPAC_O_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_P_IDX datafile '/app/datafile/orcl/MPAC_P_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_R_IDX datafile '/app/datafile/orcl/MPAC_R_IDX.ora' size 1000m  reuse
autoextend on maxsize unlimited;
create tablespace MPAC_U_IDX datafile '/app/datafile/orcl/MPAC_U_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_IDX datafile '/app/datafile/orcl/MPAC_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_T_IDX datafile '/app/datafile/orcl/MPAC_T_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_C_IDX datafile '/app/datafile/orcl/MPAC_C_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_D_IDX datafile '/app/datafile/orcl/MPAC_D_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_M_IDX datafile '/app/datafile/orcl/MPAC_M_IDX.ora'size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_G_IDX datafile '/app/datafile/orcl/MPAC_G_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_A_IDX datafile '/app/datafile/orcl/MPAC_A_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_B_IDX datafile '/app/datafile/orcl/MPAC_B_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_S_IDX datafile '/app/datafile/orcl/MPAC_S_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_LOG_IDX datafile '/app/datafile/orcl/MPAC_LOG_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace WSZ datafile '/app/datafile/orcl/WSZ.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_A datafile '/app/datafile/orcl/MPAC_A.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_C datafile '/app/datafile/orcl/MPAC_C.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_D datafile '/app/datafile/orcl/MPAC_D.ora' size 15000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_LOG datafile '/app/datafile/orcl/MPAC_LOG.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_T datafile '/app/datafile/orcl/MPAC_T.ora' size 10000m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_B datafile '/app/datafile/orcl/JLMID_B.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_I datafile '/app/datafile/orcl/JLMID_I.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_O datafile '/app/datafile/orcl/JLMID_O.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace SGMD datafile '/app/datafile/orcl/SGMD.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace SEA datafile '/app/datafile/SEA.ora' size 5000m reuse
autoextend on maxsize unlimited;

drop user mpac cascade;

drop user wsz cascade;


drop user sgmd cascade;
drop user sgmd1 cascade;
drop user sxykcc cascade;
drop user sxykgg cascade;
drop user sxykjd cascade;


drop user sea cascade;




CREATE USER mpac PROFILE DEFAULT IDENTIFIED BY mpac DEFAULT 
TABLESPACE MPAC ACCOUNT UNLOCK;
grant dba to mpac;


CREATE USER sgmd PROFILE DEFAULT IDENTIFIED BY sgmd DEFAULT 
TABLESPACE SGMD ACCOUNT UNLOCK;
grant dba to sgmd;


CREATE USER SXYKCC PROFILE DEFAULT IDENTIFIED BY SXYKCC DEFAULT 
TABLESPACE MPAC_D ACCOUNT UNLOCK;
grant dba to SXYKCC;


CREATE USER SXYKGG PROFILE DEFAULT IDENTIFIED BY SXYKGG DEFAULT 
TABLESPACE MPAC ACCOUNT UNLOCK;
grant dba to SXYKGG;


CREATE USER SXYKJD PROFILE DEFAULT IDENTIFIED BY SXYKJD DEFAULT 
TABLESPACE MPAC_T ACCOUNT UNLOCK;
grant dba to SXYKJD;




CREATE USER JLPT PROFILE DEFAULT IDENTIFIED BY JLPT


CREATE USER WSZ PROFILE DEFAULT IDENTIFIED BY wsz DEFAULT 
TABLESPACE WSZ ACCOUNT UNLOCK;
grant dba to WSZ;


CREATE USER sea PROFILE DEFAULT IDENTIFIED BY sea DEFAULT 
TABLESPACE SEA ACCOUNT UNLOCK;
grant dba to sea;


CREATE USER sgmd1 PROFILE DEFAULT IDENTIFIED BY sgmd1 DEFAULT 
TABLESPACE SGMD ACCOUNT UNLOCK;
grant dba to sgmd1;