oracle資料表空間建立語句

常規資料表空間:
CREATE SMALLFILE
    TABLESPACE "CAMCDC"
    LOGGING
DATAFILE
'E:/camcdc/CAMCDC1.ora' SIZE 10000M,
'E:/camcdc/CAMCDC2.ora' SIZE 10000M,
'E:/camcdc/CAMCDC3.ora' SIZE 10000M,
'E:/camcdc/CAMCDC4.ora' SIZE 10000M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

暫存資料表空間:
CREATE SMALLFILE
　　TEMPORARY TABLESPACE "CAMCDC_TEMP"
　　TEMPFILE
    'E:/camcdc/CAMCDC_TEMP1.ora' SIZE 3000M,
    'E:/camcdc/CAMCDC_TEMP2.ora' SIZE 3000M,
    'E:/camcdc/CAMCDC_TEMP3.ora' SIZE 3000M,
    'E:/camcdc/CAMCDC_TEMP4.ora' SIZE 3000M,
    'E:/camcdc/CAMCDC_TEMP5.ora' SIZE 3000M,
    'E:/camcdc/CAMCDC_TEMP6.ora' SIZE 3000M
REUSE
　　AUTOEXTEND ON NEXT 1000M MAXSIZE UNLIMITED
　　EXTENT MANAGEMENT LOCAL
　　UNIFORM SIZE 1M ;