创建oracle 表空间&临时表空间sql

临时表空间：

create temporary tablespace YY_TEMP TEMPFILE '/home/oracle/app/oradata/yysoft/yy_temp.bdf'size 100m reuse autoextend on next 20m maxsize unlimited;

表空间：

CREATE TABLESPACE "WT_CMS"
    LOGGING
    DATAFILE
    '/oradata/data1/orclwt/WT_CMS001.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS001.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS002.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS002.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS003.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS003.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS004.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS004.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS005.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS005.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS006.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS006.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS007.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS007.dbf' SIZE 32000M,
    '/oradata/data1/orclwt/WT_CMS008.dbf' SIZE 32000M,
    '/oradata/data2/orclwt/WT_CMS008.dbf' SIZE 32000M
   REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;