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 MSDBYQ ADD DATAFILE 'D:\ORADATA\ORCL\MSDBYQ4.DBF' SIZE 2048M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
3 修改原表空间文件
alter database datafile 'D:\ORADATA\ORCL\MSDBYQ4.DBF' autoextend on next 100m maxsize 20480M;