ALTER TABLESPACE TEMP SHRINK TEMPFILE

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

ORA-03297 There're two error patterns of ORA-03297, one is to resize a data file, the other is to shrink a temp file. Resize Data File… Read More »

Resizing a temporary tablespace may have 2 meanings in Oracle, one is to increase its size, the other is to shrink its size. In this… Read More »