How to Shrink Empty Tablespaceby Ed ChenOctober 26, 2023November 11, 2023Shrink 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
How to Resolve ORA-03297: file contains used data beyond requested RESIZE valueby Ed ChenOctober 20, 2021June 8, 2022ORA-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