查询表空间

SELECT tablespace_name, file_id, file_name, round(bytes / (1024 * 1024), 0) total_space FROM dba_data_files ORDER BY tablespace_name,file_id desc

表空间扩容，新增文件

alter tablespace NNC_DATA01 add datafile 'D:\ORACLE\ORADATA\ORCL\NNC_DATA02.DBF' size 5G autoextend on next 512M Maxsize UNLIMITED;