Skip to Main Content

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!

Unable to shrink the datafile after truncate table

Rizwan ShaukatMar 24 2015 — edited Mar 24 2015

DB: 10G release 2

OS: Windows 2003 Server

We have table which carries size approx. 50GB in 13 Datafiles, now, i truncate table, tablespace total size is 75GB, after truncate size change to 25GB.

I try to resize datafile but get error "ORA-03297: file contains used data beyond requested RESIZE value".

Do i need to reorganize the datafiles? or other suggestion will be appreciated

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2015
Added on Mar 24 2015
5 comments
1,917 views