ALTER TABLESPACE COALESCE

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 »

How to Resolve ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

by Ed Chen
February 12, 2020October 10, 2021

ORA-03217 ORA-03217 means that the statement looks syntactically correct, but the action you performed is invalid for a temporary tablespace. Let's check the content of… Read More »

JavaScript is not enabled. Please enable it and reload the page.