2 Replies Latest reply: Jan 12, 2013 4:59 AM by 864103 RSS

    Try to shrink datafiles after deleting huge amount of records

    932226
      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