--增加表空间数据文件
alter tablespace "WEBSITE" add datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\WEBSITE_1.dbf' size 1024M
autoextend on next 200M
maxsize 30720M
--查询表空间 数据文件
select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space
from dba_data_files order by tablespace_name;
alter tablespace "WEBSITE" add datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\WEBSITE_1.dbf' size 1024M
autoextend on next 200M
maxsize 30720M
--查询表空间 数据文件
select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space
from dba_data_files order by tablespace_name;