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:

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

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