createuserortablespace

create tablespace MPACdatafile '/app/datafile/orcl/MPAC.ora' size 5000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Mdatafile '/app/datafile/orcl/MPAC_M.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Gdatafile '/app/datafile/orcl/MPAC_G.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Bdatafile '/app/datafile/orcl/MPAC_B.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Sdatafile '/app/datafile/orcl/MPAC_S.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Idatafile '/app/datafile/orcl/MPAC_I.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Ndatafile '/app/datafile/orcl/MPAC_N.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Odatafile '/app/datafile/orcl/MPAC_O.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Pdatafile '/app/datafile/orcl/MPAC_P.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Rdatafile '/app/datafile/orcl/MPAC_R.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Udatafile '/app/datafile/orcl/MPAC_U.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_I_IDXdatafile '/app/datafile/orcl/MPAC_I_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_N_IDXdatafile '/app/datafile/orcl/MPAC_N_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_O_IDXdatafile '/app/datafile/orcl/MPAC_O_IDX.ora'size 500m 
autoextend on maxsize unlimited;
create tablespace MPAC_P_IDXdatafile '/app/datafile/orcl/MPAC_P_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_R_IDXdatafile '/app/datafile/orcl/MPAC_R_IDX.ora' size 1000m  reuse
autoextend on maxsize unlimited;
create tablespace MPAC_U_IDXdatafile '/app/datafile/orcl/MPAC_U_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_IDXdatafile '/app/datafile/orcl/MPAC_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_T_IDXdatafile '/app/datafile/orcl/MPAC_T_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_C_IDXdatafile '/app/datafile/orcl/MPAC_C_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_D_IDXdatafile '/app/datafile/orcl/MPAC_D_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_M_IDXdatafile '/app/datafile/orcl/MPAC_M_IDX.ora'size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_G_IDXdatafile '/app/datafile/orcl/MPAC_G_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_A_IDXdatafile '/app/datafile/orcl/MPAC_A_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_B_IDXdatafile '/app/datafile/orcl/MPAC_B_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_S_IDXdatafile '/app/datafile/orcl/MPAC_S_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_LOG_IDXdatafile '/app/datafile/orcl/MPAC_LOG_IDX.ora' size 1000m reuse
autoextend on maxsize unlimited;
create tablespace WSZdatafile '/app/datafile/orcl/WSZ.ora'size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Adatafile '/app/datafile/orcl/MPAC_A.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Cdatafile '/app/datafile/orcl/MPAC_C.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace MPAC_Ddatafile '/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_Tdatafile '/app/datafile/orcl/MPAC_T.ora' size 10000m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_Bdatafile '/app/datafile/orcl/JLMID_B.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_Idatafile '/app/datafile/orcl/JLMID_I.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace JLMID_Odatafile '/app/datafile/orcl/JLMID_O.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace SGMDdatafile '/app/datafile/orcl/SGMD.ora' size 500m reuse
autoextend on maxsize unlimited;
create tablespace SEAdatafile '/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;