1 Reply Latest reply: Sep 26, 2012 6:26 PM by Hussein Sawwan-Oracle RSS

    PJI schema is huge compared to others - how do i purge

    user12965601
      Our PJI schema is growing huge compared to others. Is there anyway to purge it or minimize the growth. Our Projects activities are not much compared to other areas.

      Thanks
        • 1. Re: PJI schema is huge compared to others - how do i purge
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.
          Our PJI schema is growing huge compared to others. Is there anyway to purge it or minimize the growth. Our Projects activities are not much compared to other areas.
          Do you have any historical data?

          Have you verified that you have data that you can purge?

          Please see these docs.

          Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management [ID 752322.1]
          Purging Strategy for eBusiness Suite 11i [ID 732713.1]
          Using Database Partitioning with Oracle E-Business Suite [ID 554539.1]

          Thanks,
          Hussein