创建表空间命令：CREATE TABLESPACE userdata
DATAFILE '/u01/oradata/userdata01.dbf' SIZE 100M
AUTOEXTEND ON NEXT 5M MAXSIZE 200M;
调整表空间：CREATE TABLESPACE user_data
DATAFILE
'/u01/oradata/userdata01.dbf' SIZE 200M
AUTOEXTEND ON NEXT 10M MAXSIZE 500M;
手动加表空间
ALTER DATABASEDATAFILE '/u03/oradata/userdata02.dbf'RESIZE 200M;
原文链接：https://www.f2er.com/oracle/211755.html