tonydark01 发表于 2013-1-29 14:41:21

ORACLE 建表空间

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
//字段自动增长
页: [1]
查看完整版本: ORACLE 建表空间