Expand Table Space System

SQL> set linesize 200;
SQL> col FILE_NAME for a20
SQL> col TABLESPACE_NAME for a20
SQL> select tablespace_name,file_id,file_name,
  2  round(bytes / (1024 * 1024), 0) total_space
  3  from sys.dba_data_files
  4  order by tablespace_name;
 

Then alter tablespace system add datafile '+DATA/ORCL/8CC25D29530F7A6BE0537512F20A25D1/DATAFILE/system03.dbf' size 10G ； not more than 32G！！！！

 

https://blog.51cto.com/laobaiv1/1929403