ALTER DATABASE DATAFILE '/home/oracle/app/oradata/orcl/tbs_test.dbf' RESIZE 2024M;
ALTER DATABASE DATAFILE '/home/oracle/app/oradata/orcl/tbs_test.dbf' AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED; ALTER TABLESPACE TBS_TEST AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
3、增加新的数据文件
alter tablespace TBS_TEST add datafile '/home/oracle/app/oradata/orcl/tbs_test02.dbf ' size 100M AUTOEXTEND off;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69984085/viewspace-2756876/ ,如需转载,请注明出处,否则将追究法律责任。