2 Replies Latest reply on Jan 12, 2013 10:59 AM by 864103

    Try to shrink datafiles after deleting huge amount of records

    A Labadi
      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