1、
select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name --查看所有的表空间及其磁盘占用空间
2、如果表空间满了,扩展表空间
ALTER TABLESPACE "SMART_TABLE"
ADD
DATAFILE 'F:\app\LSQ\product\11.2.0\dbhome_1\database\Ftable1.dat' SIZE 4000M
REUSE AUTOEXTEND
ON NEXT 10M MAXSIZE
UNLIMITED;