Cleanup old tables in R12 (BAK TMP etc)
I've just taken over an EBS instance that's been upgraded and patched from version 10 to version 12 over the past 20 years. I have a number of %BAK% and %TMP% and tables in my database
For example:
BAK_AP_AE_HEADERS%
BAK_AP_AE_LINES%
EDW_GL_ACCT%_M_TEMP
CST_INQUIRY_TEMP
CST_LISTS_TEMP
GEM_LOOKUP_VALUES_BAK
MTL_SUMMARY_TEMP
MSC_BOM_TEMP
GL_ACCRUAL_TEMP1
PA_PAGE_LAYOUTS_TMP
These are just a sample of the 3000+ tables I'm examining to determine if they should be trashed. Does anyone have a good script that can be used to clean up the low hanging fruit? Or a good rule of thumb? I know that many of the things I am seeing are leftover from old in-house development, but I also know that the Oracle upgrades leave a lot of junk, too.