Re: Partitioning in the Oracle EBS

From: Karth Panchan <keyantech_at_gmail.com>
Date: Wed, 8 May 2013 12:28:49 -0400
Message-Id: <F64E7D84-63C2-4E81-9510-F9D437C902A8_at_gmail.com>

I worked in place where EBS data want to be outputted to down stream reporting database.

To support this custom schema was created and output data staged there. All tables are partitioned monthly with active & archive sub partition.

Once downstream consumed data goes to archive partition.

Partition was done here to manage data and improve performance EBS custom batch job. Also it helped to improve downstream extract.

None of the EBS tables were touched as it makes Oracle support & upgrade more complicated.

HTH
Karth

On May 8, 2013, at 11:26 AM, "Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org> wrote:

> Has anybody implemented custom partitioning in the Oracle EBS. If so;
> Why?
> What benefits were achieved?
> What tables were partitioned?
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> Information Systems
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 08 2013 - 18:28:49 CEST