1、先查询表空间信息: select tablespace_name,file_id,file_name,round(bytes / (1024 * 1024) totalspace from sys.dba_data_files order by tablespace_name)
2、修改表空间大小:alter database datafile '/u02/upss/data/pas.dbf' resize 1000M
1、先查询表空间信息: select tablespace_name,file_id,file_name,round(bytes / (1024 * 1024) totalspace from sys.dba_data_files order by tablespace_name)
2、修改表空间大小:alter database datafile '/u02/upss/data/pas.dbf' resize 1000M