alter tablespace system resize 1G; 仅支持bigfile类型的表空间,system表空间使用下面的命令。
ALTER DATABASE DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF' RESIZE 1G;
----------------------
ALTER DATABASEDATAFILE '/u07/oracle/oradata/train/media01.dbf'AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
-------------------------
ALTER TABLESPACE mediaAUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
ALTER DATABASE DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF' RESIZE 1G;
----------------------
ALTER DATABASEDATAFILE '/u07/oracle/oradata/train/media01.dbf'AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
-------------------------
ALTER TABLESPACE mediaAUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;