My Oracle Support Banner

Load Profile Adapter Taking Up to 24 Hours to Load Profiles and Also Filling the Temp Tablespace (Doc ID 2767540.1)

Last updated on APRIL 08, 2021

Applies to:

Oracle Utilities Network Management System - Version to [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version to [Release 2.4 to 2.5]
Information in this document applies to any platform.


On : version, NMS Infrastructure

Load Profile adapter taking upto 24 hours to load profiles and also giving error for temp tablespace:


The customer is collecting temperature based loading data for 16 months and creating load profiles for each of their feeders.  Each feeder on their model will have profiles for 16 months with one csv file for each month.   The time taken to load profiles is taking upwards of 24+ hours

While loading the profiles,  there is also an error being generated as the TEMP  tablespace gets maxed out.

ORA-01652: unable to extend temp segment by 128 in tablespace NMSADMIN_TMP




To view full details, sign in with your My Oracle Support account.

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

In this Document
 Fix Description
 Suggested Test

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