How to Shrink Empty Tablespace
Shrink Empty Tablespaces Dropping empty tablespaces for reclaiming unused space is not a reversible operation, any mistake may cost you a lot in a production… Read More »How to Shrink Empty Tablespace
ALTER DATABASE DATAFILE RESIZE
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 »How to Resolve ORA-03297: file contains used data beyond requested RESIZE value