oracle 建立表空間完整版

CREATE SMALLFILE TABLESPACE "TEST2" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\test2.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO


CREATE SMALLFILE TABLESPACE "TEST2" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\test2.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE 5M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO



CREATE SMALLFILE TABLESPACE "TEST2" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\test2.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO