Can Temporary Tables (TMP_PROFxxxxx) Created by REL Sessions be Dropped in Database?
(Doc ID 2010864.1)
Last updated on OCTOBER 17, 2023
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.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?
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