Problém 45:
Nelze zmenšit UNDO.SYS@myserver SQL> ALTER DATABASE DATAFILE ‘+DATA/mydb/datafile/undotbs1.260.618145941’ REALTER DATABASE DATAFILE ‘+DATA/mydb/datafile/undotbs1.260.618145941’ RESIZE 500M*ERROR at line 1:ORA-03297: file contains used data beyond requested RESIZE value
Řešení:
Vytvořit nový UNDO, nastavit dočasně jako default a poté zmenšit původní a změnit opět na default.
SYS@myserver SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘+DATA’ SIZE 50 M AUTOEXTEND ON ;Tablespace created.Elapsed: 00:00:28.05SYS@myserver SQL> ALTER SYSTEM SET undo_tablespace = UNDOTBS2 ;System altered.Elapsed: 00:00:00.27SYS@myserver SQL> DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES ;Tablespace dropped.Elapsed: 00:00:14.40SYS@myserver SQL> CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ‘+DATA’ SIZE 1000M AUTOEXTEND ON NEXT 5 M MAXSIZE 15000M ;Tablespace created.Elapsed: 00:00:23.92SYS@myserver SQL> ALTER SYSTEM SET undo_tablespace = UNDOTBS1 ;System altered.Elapsed: 00:00:00.12SYS@myserver SQL> DROP TABLESPACE undotbs2 INCLUDING CONTENTS AND DATAFILES ;Tablespace dropped.Elapsed: 00:00:17.40