创建用户和表空间

create tablespace SYS
datafile 'D:\OraDataFile\DataFile\WZ_WXZJ.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER SYS IDENTIFIED BY supermap DEFAULT TABLESPACE SYS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO WZ_WXZJ;
GRANT DBA TO SYS;
GRANT RESOURCE TO SYS;
grant create any view to SYS;
GRANT CREATE ANY TABLE TO SYS;
GRANT SELECT ANY TABLE TO SYS;
GRANT COMMENT ANY TABLE TO SYS;
GRANT LOCK ANY TABLE TO SYS;
GRANT SELECT ANY DICTIONARY TO SYS;
---------------------------------------------------------------------------------------------------------

create tablespace BDCDCK
datafile 'E:\app\Administrator\oradata\BDCDCK.dbf' size 100M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER BDCDCK IDENTIFIED BY salis DEFAULT TABLESPACE BDCDCK TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO BDCDCK;
GRANT DBA TO BDCDCK;
GRANT RESOURCE TO BDCDCK;
grant create any view to BDCDCK;
GRANT CREATE ANY TABLE TO BDCDCK;
GRANT SELECT ANY TABLE TO BDCDCK;
GRANT COMMENT ANY TABLE TO BDCDCK;
GRANT LOCK ANY TABLE TO BDCDCK;
GRANT SELECT ANY DICTIONARY TO BDCDCK;
---------------------------------------------------------------------------------------------------------------

create tablespace BDCK
datafile 'E:\app\Administrator\oradata\BDCK.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER BDCK IDENTIFIED BY salis DEFAULT TABLESPACE BDCK TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO BDCK;
GRANT DBA TO BDCK;
GRANT RESOURCE TO BDCK;
grant create any view to BDCK;
GRANT CREATE ANY TABLE TO BDCK;
GRANT SELECT ANY TABLE TO BDCK;
GRANT COMMENT ANY TABLE TO BDCK;
GRANT LOCK ANY TABLE TO BDCK;
GRANT SELECT ANY DICTIONARY TO BDCK;

---------------------------------------------------------------------------------------------------------------

create tablespace QJDC_WORKFLOW
datafile 'E:\app\Administrator\oradata\QJDC_WORKFLOW.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER QJDC_WORKFLOW IDENTIFIED BY salis DEFAULT TABLESPACE QJDC_WORKFLOW TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO QJDC_WORKFLOW;
GRANT DBA TO QJDC_WORKFLOW;
GRANT RESOURCE TO QJDC_WORKFLOW;
grant create any view to QJDC_WORKFLOW;
GRANT CREATE ANY TABLE TO QJDC_WORKFLOW;
GRANT SELECT ANY TABLE TO QJDC_WORKFLOW;
GRANT COMMENT ANY TABLE TO QJDC_WORKFLOW;
GRANT LOCK ANY TABLE TO QJDC_WORKFLOW;
GRANT SELECT ANY DICTIONARY TO QJDC_WORKFLOW;

---------------------------------------------------------------------------------------------------------------


---------

------------------------------------------------------------------------------------------------------

create tablespace SMWB_SUPPORT
datafile 'E:\app\Administrator\oradata\SMWB_SUPPORT.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER SMWB_SUPPORT IDENTIFIED BY salis DEFAULT TABLESPACE SMWB_SUPPORT TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO SMWB_SUPPORT;
GRANT DBA TO SMWB_SUPPORT;
GRANT RESOURCE TO SMWB_SUPPORT;
grant create any view to SMWB_SUPPORT;
GRANT CREATE ANY TABLE TO SMWB_SUPPORT;
GRANT SELECT ANY TABLE TO SMWB_SUPPORT;
GRANT COMMENT ANY TABLE TO SMWB_SUPPORT;
GRANT LOCK ANY TABLE TO SMWB_SUPPORT;
GRANT SELECT ANY DICTIONARY TO SMWB_SUPPORT;

---------------------------------------------------------------------------------------------------------------

create tablespace QJDC_LOG
datafile 'E:\app\Administrator\oradata\QJDC_LOG.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER QJDC_LOG IDENTIFIED BY salis DEFAULT TABLESPACE QJDC_LOG TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO QJDC_LOG;
GRANT DBA TO QJDC_LOG;
GRANT RESOURCE TO QJDC_LOG;
grant create any view to QJDC_LOG;
GRANT CREATE ANY TABLE TO QJDC_LOG;
GRANT SELECT ANY TABLE TO QJDC_LOG;
GRANT COMMENT ANY TABLE TO QJDC_LOG;
GRANT LOCK ANY TABLE TO QJDC_LOG;
GRANT SELECT ANY DICTIONARY TO QJDC_LOG;
---------------------------------------------------------------------------------------------------------------

create tablespace QJDC_META
datafile 'E:\app\Administrator\oradata\QJDC_META.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER QJDC_META IDENTIFIED BY salis DEFAULT TABLESPACE QJDC_META TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO QJDC_META;
GRANT DBA TO QJDC_META;
GRANT RESOURCE TO QJDC_META;
grant create any view to QJDC_META;
GRANT CREATE ANY TABLE TO QJDC_META;
GRANT SELECT ANY TABLE TO QJDC_META;
GRANT COMMENT ANY TABLE TO QJDC_META;
GRANT LOCK ANY TABLE TO QJDC_META;
GRANT SELECT ANY DICTIONARY TO QJDC_META;

---------------------------------------------------------------------------------------------------------------
create tablespace SMWB_FRAMEWORK
datafile 'E:\app\Administrator\oradata\SMWB_FRAMEWORK.dbf' size 50M
autoextend on next 30M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

CREATE USER SMWB_FRAMEWORK IDENTIFIED BY salis DEFAULT TABLESPACE SMWB_FRAMEWORK TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;
GRANT CONNECT TO SMWB_FRAMEWORK;
GRANT DBA TO SMWB_FRAMEWORK;
GRANT RESOURCE TO SMWB_FRAMEWORK;
grant create any view to SMWB_FRAMEWORK;
GRAN

T CREATE ANY TABLE TO SMWB_FRAMEWORK;
GRANT SELECT ANY TABLE TO SMWB_FRAMEWORK;
GRANT COMMENT ANY TABLE TO SMWB_FRAMEWORK;
GRANT LOCK ANY TABLE TO SMWB_FRAMEWORK;
GRANT SELECT ANY DICTIONARY TO SMWB_FRAMEWORK;