ORA-03297: file contains used data beyond requested RESIZE value

Chyba

SQL> ALTER DATABASE DATAFILE '/oradata/PROD/PROD/undotbs01.dbf' RESIZE 5000M;
ALTER DATABASE DATAFILE '/oradata/PROD/PROD/undotbs01.dbf' RESIZE 5000M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

Řešení

SQL> create undo tablespace UNDOTBS2 datafile '/oradata/PROD/PROD/undotbs02.dbf' size 100m;

Tablespace created.

SQL> alter system set undo_tablespace=UNDOTBS2;

System altered.

SQL> drop tablespace UNDOTBS1 including contents and datafiles cascade constraints;

Tablespace dropped.

A zpět

SQL> create undo tablespace UNDOTBS1 datafile '/oradata/PROD/PROD/undotbs01.dbf' size 100m;

Tablespace created.

SQL> alter system set undo_tablespace=UNDOTBS1;

System altered.

SQL> drop tablespace UNDOTBS2 including contents and datafiles cascade constraints;

Tablespace dropped.

Komentáře