创建用户

--服务器DUMP导出脚本
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
--导入     
create tablespace UNDOTBS2 datafile 'D:/oracle/product/10.2.0/oradata/orcl/UNDOTBS2_01.dbf' size 10M autoextend on next 10M;
create tablespace D_STATIC_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_STATIC_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace D_STATIC_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_STATIC_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_1_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_1_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_1_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_1_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_2_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_2_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_2_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_2_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_3_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_3_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_3_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_3_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_LOB_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_LOB_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_TS_LOB_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_TS_LOB_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace EMOS_TS_1_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/EMOS_TS_1_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace EMOS_TS_1_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/EMOS_TS_1_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace PPMDEMO_TS_1_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/PPMDEMO_TS_1_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace TEMP1 datafile 'D:/oracle/product/10.2.0/oradata/orcl/TEMP1_01.dbf' size 10M autoextend on next 10M;
create tablespace CRM_INTER_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRM_INTER_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace CRMPROG_TABLESPACE datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRMPROG_TABLESPACE_01.dbf' size 10M autoextend on next 10M;
create tablespace CRMACCESS_TABLESPACE datafile 'D:/oracle/product/10.2.0/oradata/orcl/CRMACCESS_TABLESPACE_01.dbf' size 10M autoextend on next 10M;
create tablespace D_10240_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_10240_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace D_10240_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_10240_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace D_1024_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_1024_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace D_1024_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_1024_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace D_128_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_128_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace D_128_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_128_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace TSAPDATA datafile 'D:/oracle/product/10.2.0/oradata/orcl/TSAPDATA_01.dbf' size 10M autoextend on next 10M;
create tablespace TSAPIDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/TSAPIDX_01.dbf' size 10M autoextend on next 10M;
create tablespace D_WKFORCE_DAT datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_WKFORCE_DAT_01.dbf' size 10M autoextend on next 10M;
create tablespace D_WKFORCE_IDX datafile 'D:/oracle/product/10.2.0/oradata/orcl/D_WKFORCE_IDX_01.dbf' size 10M autoextend on next 10M;
create tablespace ST_DATA datafile 'D:/oracle/product/10.2.0/oradata/orcl/ST_DATA_01.dbf' size 10M autoextend on next 10M;

drop user crmsel cascade;
drop user tsapaccess cascade;
drop user crmtcmhis cascade;
drop user pubom cascade;
drop user wfsaccess cascade;
drop user uumaccess cascade;
drop user crm_inter cascade;
drop user ppmplm_cf cascade;
drop user pub cascade;
drop user crmprog cascade;
drop user pubuserhis cascade;
drop user crmtbmhis cascade;
drop user ppmpub_cf cascade;
drop user pubuum cascade;
drop user ppm cascade;
drop user emos cascade;
drop user pubuser cascade;
drop user staccess cascade;
drop user pubtsap cascade;
drop user crmtcm cascade;
drop user tf_bpmadmin_access cascade;
drop user spsaccess cascade;
drop user ppmtest_cf cascade;
drop user crmchn cascade;
drop user pubst cascade;
drop user pubtt cascade;
drop user pubmeta cascade;
drop user ppmdemo cascade;
drop user crmtbm cascade;
drop user crmmkt cascade;
drop user crmaccess cascade;
drop user pubwfs cascade;
drop user rmaccess cascade;
drop user pubrm cascade;
drop user crmpar cascade;

create user crmsel identified by crmsel123 default tablespace CRM_TS_3_DAT;
create user tsapaccess identified by tsapaccess123 default tablespace TSAPDATA;
create user crmtcmhis identified by crmtcmhis123 default tablespace CRM_TS_2_DAT;
create user pubom identified by pubom123 default tablespace D_128_DAT;
create user wfsaccess identified by wfsaccess123 default tablespace D_WKFORCE_DAT;
create user uumaccess identified by uumaccess123 default tablespace D_STATIC_DAT;
create user crm_inter identified by crm_inter123 default tablespace D_1024_DAT;
create user ppmplm_cf identified by ppmplm_cf123 default tablespace PPMDEMO_TS_1_DAT;
create user pub identified by pub123 default tablespace D_STATIC_DAT;
create user crmprog identified by crmprog123 default tablespace CRMPROG_TABLESPACE;
create user pubuserhis identified by pubuserhis123 default tablespace D_10240_DAT;
create user crmtbmhis identified by crmtbmhis123 default tablespace CRM_TS_1_DAT;
create user ppmpub_cf identified by ppmpub_cf123 default tablespace PPMDEMO_TS_1_DAT;
create user pubuum identified by pubuum123 default tablespace D_STATIC_DAT;
create user ppm identified by ppm123 default tablespace CRM_TS_1_DAT;
create user emos identified by emos123 default tablespace EMOS_TS_1_DAT;
create user pubuser identified by pubuser123 default tablespace D_10240_DAT;
create user staccess identified by staccess123 default tablespace ST_DATA;
create user pubtsap identified by pubtsap123 default tablespace TSAPDATA;
create user crmtcm identified by crmtcm123 default tablespace CRM_TS_2_DAT;
create user tf_bpmadmin_access identified by tf_bpmadmin_access123 default tablespace D_1024_DAT;
create user spsaccess identified by spsaccess123 default tablespace D_1024_DAT;
create user ppmtest_cf identified by ppmtest_cf123 default tablespace PPMDEMO_TS_1_DAT;
create user crmchn identified by crmchn123 default tablespace CRM_TS_3_DAT;
create user pubst identified by pubst123 default tablespace TSAPDATA;
create user pubtt identified by pubtt123 default tablespace EMOS_TS_1_DAT;
create user pubmeta identified by pubmeta123 default tablespace D_10240_DAT;
create user ppmdemo identified by ppmdemo123 default tablespace PPMDEMO_TS_1_DAT;
create user crmtbm identified by crmtbm123 default tablespace CRM_TS_1_DAT;
create user crmmkt identified by crmmkt123 default tablespace CRM_TS_3_DAT;
create user crmaccess identified by crmaccess123 default tablespace CRMACCESS_TABLESPACE;
create user pubwfs identified by pubwfs123 default tablespace D_WKFORCE_DAT;
create user rmaccess identified by rmaccess123 default tablespace D_1024_DAT;
create user pubrm identified by pubrm123 default tablespace D_1024_DAT;
create user crmpar identified by crmpar123 default tablespace CRM_TS_3_DAT;
grant resource,connect to crmsel;
grant resource,connect to tsapaccess;
grant resource,connect to crmtcmhis;
grant resource,connect to pubom;
grant resource,connect to wfsaccess;
grant resource,connect to uumaccess;
grant resource,connect to crm_inter;
grant resource,connect to ppmplm_cf;
grant resource,connect to pub;
grant resource,connect to crmprog;
grant resource,connect to pubuserhis;
grant resource,connect to crmtbmhis;
grant resource,connect to ppmpub_cf;
grant resource,connect to pubuum;
grant resource,connect to ppm;
grant resource,connect to emos;
grant resource,connect to pubuser;
grant resource,connect to staccess;
grant resource,connect to pubtsap;
grant resource,connect to crmtcm;
grant resource,connect to tf_bpmadmin_access;
grant resource,connect to spsaccess;
grant resource,connect to ppmtest_cf;
grant resource,connect to crmchn;
grant resource,connect to pubst;
grant resource,connect to pubtt;
grant resource,connect to pubmeta;
grant resource,connect to ppmdemo;
grant resource,connect to crmtbm;
grant resource,connect to crmmkt;
grant resource,connect to crmaccess;
grant resource,connect to pubwfs;
grant resource,connect to rmaccess;
grant resource,connect to pubrm;
grant resource,connect to crmpar;

 

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
--全库导入 推荐FULL
imp 'sys/Password1@orcl as sysdba' file=F:\Transfer\dmp\V1.2.23.20120716_1830R_FULL.dmp commit=y ignore=y full=Y statistics=none buffer=100000000