tablespace

SQL> alter database datafile '+REG_DATA01/SHESTMP/DATAFILE/datacore_data.369.964966381' resize 50G;
alter database datafile '+REG_DATA01/SHESTMP/DATAFILE/datacore_data.369.964966381' resize 50G
*
ERROR at line 1:
ORA-01144: File size (6553600 blocks) exceeds maximum of 4194303 blocks


SQL> alter tablespace DATACORE_DATA add datafile '+REG_DATA01' size 30G;

Tablespace altered.

SQL> alter tablespace DATACORE_DATA add datafile '+REG_DATA01' size 30G;

Tablespace altered.


SQL> alter database tempfile '+REG_DATA01/SHESTMP/TEMPFILE/temp.306.962059941' resize 25G;

SQL> alter database datafile '+REG_DATA01/SHESTMP/DATAFILE/undotbs2.312.962059957' resize 30G;

SQL> alter database datafile '+REG_DATA01/SHESTMP/DATAFILE/undo.310.962059773' resize 30G;

请使用浏览器的分享功能分享到微信等