Tag Archives: resize

UNDO management, Cannot shrink the UNDO tablespace.

Posted on January 12, 2010 by Carlos Acosta

One common question we can  find in the internet is how to shrink the undo tablespace, because even if we see it empty we can get an ORA 3297 error (see here how to deal with ORA 3297 error), therefore, … Continue reading →

Posted in Oracle Server, SQL | Tagged , , , , | 2 Comments

ORA 3297 when resizing a datafile

Posted on December 2, 2009 by Carlos Acosta

ORA 3297 when resizing a datafile December 2, 2009 · Leave a Comment · Edit This Sometimes we want to shrink a datafile and we get the ORA-3297 error, what? but if there is enough space!! Well , there is … Continue reading →

Posted in Oracle Server, SQL | Tagged , , , , , , , | 1 Comment