Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Try to shrink datafiles after deleting huge amount of records

A LabadiJan 12 2013 — edited Jan 12 2013

Dear Sir;

I have deleted more than 50 million records along with table’s partitions for the previous year.
now I'm trying to shrink datafile with more than 10GB free space but still unable to delete due to
ORA-03297: file contains used data beyond requested RESIZE value.

How can we shrink these datafile or otherwise what is the best way to delete huge amount of records and get additional space in HD

Thanks and best regards
Ali Labadi

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2013

Added on Jan 12 2013

#general-database-discussions

2 comments

392 views