创建tablespace命令

CREATE SMALLFILE
    TABLESPACE "FERMATDATA"
    LOGGING
    DATAFILE
    'G:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/FERMATDATA.ora' SIZE
    1024M AUTOEXTEND
    ON NEXT  50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT  AUTO

CREATE SMALLFILE
    TABLESPACE "FERMATINDEXES"
    LOGGING
    DATAFILE
    'G:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/FERMATINDEXES.ora'
    SIZE 512M AUTOEXTEND
    ON NEXT  50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
    SEGMENT SPACE MANAGEMENT  AUTO