Will Upgrade Perform Faster by Pre-Allocating Extent To AP_INVOICE_DISTRIBUTIONS_ALL ? (Doc ID 1900725.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Looking for out of the box ideas to cut down the timeline for an R12 upgrade.

Currently size is 750 million rows in the AP_INVOICE_DISTRIBUTIONS_ALL table
and another 700 million rows in the AP_CHRG_ALLOCATIONS table.

Would it make a substantial difference in the upgrade time
if space is pre-allocated to AP_INVOICE_DISTRIBUTIONS_ALL ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms