Oracle增加数据文件(表空间无法扩展)

1、java.sql.SQLException: ORA-01654: unable to extend index table_student by 8192 in tablespace SF_INDEX

2、查看现有情况

select file_name,tablespace_name,autoextensible from dba_data_files where TABLESPACE_NAME='SF_INDEX';

3、增加数据文件
alter tablespace SF_INDEX add datafile '+ORADATA/PRO_BUSINESS/DATAFILE/sf_index9.dbf' size 100M autoextend on next 100M maxsize UNLIMITED;

原文地址:https://www.cnblogs.com/zxg-blog/p/15132543.html