Can Temporary Tables (TMP_PROFxxxxx) Created by REL Sessions be Dropped in Database? (Doc ID 2010864.1)

Last updated on JUNE 08, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

We found a lot of temporary tables, with name like TMP_PROFxxxx (for ex. TMP_PROF21157020929 or TMP_PROF21156194342). Maybe this table is from bad pin_rel executions?

select max(created), min(created), count(1)
from dba_tables t, dba_objects o
where t.owner = 'PIN00'
 and t.table_name = object_name
 and t.owner = o.owner
 and t.table_name like 'TMP_PROF%'
 and substr(t.table_name,9,1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
MAX(CREATED) MIN(CREATED)   COUNT(1)
------------ ------------ ----------
14-APR-15    24-DEC-13          2516


These tables could be dropped?
Is any OOB procedure to clean up these tables?
 

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