SYS@dottk SQL> ALTER TABLESPACE TEMP DROP TEMPFILE ‚+DATA/oracledba/tempfile/temp.278.618151115‘;Tablespace altered.Elapsed: 00:00:00.82SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;Database altered.Elapsed: 00:00:00.04SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ AUTOEXTEND ON MAXSIZE 16000M;Database altered.
Změna velikosti temp datafile:
SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ RESIZE 3000M;ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ RESIZE 5000M*ERROR at line 1:ORA-03297: file contains used data beyond requested RESIZE valueElapsed: 00:00:00.93SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ OFFLINE;Database altered.Elapsed: 00:00:00.51SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ online;Database altered.Elapsed: 00:00:18.06SYS@oracledba SQL> ALTER DATABASE TEMPFILE ‚+DATA/oracledba/tempfile/temp.270.745239301‘ RESIZE 1000M;Database altered.Elapsed: 00:00:02.60