1.表空间,查询
SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
ALTER TABLESPACE DEPLOY ADD DATAFILE
'/opt/oracle/oradata/DEPLOY/deploy02.dbf' SIZE 50M
AUTOEXTEND ON NEXT 5M MAXSIZE 100M;
再次查询: