IN ORACLE MILIEU …

Beyond Knowledge

Daily Archives: February 21, 2008

Reducing datafile size to recover free space – Oracle Database 10g

At time, we want to recover some space from database just to allocate the same to some other tablespace or to return it back to OS disk. This situation arises many times. And many time we hit with error “ORA-03297: file contains used data beyond requested RESIZE value“. The concept is simple and many of [...]

Follow

Get every new post delivered to your Inbox.

Join 156 other followers