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
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 »Where to Change Redo Logs in DBCA or OUI
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 »You Cannot Resize a DataFile in "ALTER TABLESPACE" Except ...