OBIA: Temporary Database Objects Created by the Spend Classification Processing are not Dropped after the Classifier Run (Doc ID 1477712.1)

Last updated on JULY 30, 2012

Applies to:

Oracle Spend Classification - Version 7.9.6.1 and later
Information in this document applies to any platform.

Symptoms

Temporary database objects created by the spend classification processing are not dropped after the classifier run is complete.  You can see thousands of objects (tables, indexes and mining models) whose names begin with DM$, DR$ or SA$ that look like temporary objects on the database. the number of objects seems to grow as you execute more classification runs. 

Cause

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