create tablespace FSDATA
datafile 'G:\server\oracle\bsp\fsdata.dbf' size 500M REUSE
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
//创建
drop tablespace FSDATA including contents and datafiles
//删除
alter database datafile 'D:\oradata\orcl\PERFSTAT.DBF' autoextend on
//字段自动增长
datafile 'G:\server\oracle\bsp\fsdata.dbf' size 500M REUSE
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
//创建
drop tablespace FSDATA including contents and datafiles
//删除
alter database datafile 'D:\oradata\orcl\PERFSTAT.DBF' autoextend on
//字段自动增长