Can Temporary Tables (TMP_PROFxxxxx) Created by REL Sessions be Dropped in Database?
Last updated on JUNE 08, 2015
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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?
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