Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Cleanup old tables in R12 (BAK TMP etc)

edited Apr 8, 2016 9:22AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center