sqlplus/as sysdba
SQL> startup
SQL> shutdown immediate

新增永久表空间

CREATE TABLESPACE TBS_TEST

? 新增临时表

空间

 CREATE TEMPORARY TABLESPACE TBS_TEMP 
TEMPFILE 'D:\ORACLE\ORADATA\STANDARD\DATA\TBS_TEMP.DBF' 
SIZE 10M AUTOEXTEND ON NEXT 1M;

CREATE UNDO TABLESPACE TBS_UNDO2
DATAFILE 'D:\ORACLE\ORADATA\STANDARD\DATA\TBS_UNDO2.DBF' 
SIZE 10M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE BIGFILE TABLESPACE TBS_BIG 
DATAFILE 'D:\ORACLE\ORADATA\STANDARD\DATA\TBS_BIG.DBF' 
SIZE 10G  AUTOEXTEND ON NEXT 1G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;