创建表空间
create tablespace 表空间名字 logging datafile ‘/home/db/oracle/oradata/hfmsdb/hfms_data.dbf’ size 50m autoextend on next 50m maxsize 20480m extent management local;
创建临时表空间
create temporary tablespace 表空间名字 tempfile ‘/home/db/oracle/oradata/hfmsdb/hfms_temp.dbf’ size 50m autoextend on next 50m maxsize 20480m extent management local;
追加表空间数据文件
alter tablespace 表空间名字 add datafile ‘/home/db/oracle/oradata/hfmsdb/hfms_data02.dbf’ size 50m autoextend on next 50m maxsize 20480m ;