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:

Identity Manager - Version 11.1.2.3.171017 and later
Information in this document applies to any platform.

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

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