How To Calculate Temp Tablespace Size Required For Bulk Load Based On Data? (Doc ID 2358166.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Goal

OIM R2PS3 using Oracle RAC database which is setup with two database servers and bulk loading 45k Users using the Bulk upload - https://docs.oracle.com/cd/E52734_01/oim/OMDEV/bulkload.htm#OMDEV1742

As per this documentation, Tablespace has been created for bulk load and also extended OIM table space using oim_blkld_setup.sql.

But while running the bulk load, it throws the below error:

How to calculate temp tablespace size required for bulk load based on data?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.