RESIZE

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

by Ed Chen
October 20, 2021June 8, 2022

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 »

Where to Change Redo Logs in DBCA or OUI

by Ed Chen
May 7, 2017January 19, 2023

The default size of redo log files is 50MB or 200MB during database creation. It could be too small for databases with high volume transactions… Read More »

You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...

by Ed Chen
May 4, 2016March 29, 2018

According to SQL syntax of Oracle database, you can't resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but… Read More »