Enterprise Manager Generic (MOSC)

MOSC Banner

Patches in SYSMAN.MGMT_ECM_PATCH_CACHE

edited Aug 12, 2009 10:07PM in Enterprise Manager Generic (MOSC) 6 commentsAnswered
I noticed in one of my development databases, I have a table SYSMAN.MGMT_ECM_PATCH_CACHE which contains two rows of data related to some old patches. Can I truncate this table as it is large because it seems to contain the patch contents in BLOB format? (exported "SYSMAN"."MGMT_ECM_PATCH_CACHE"             972.2 MB       2 rows)

select ARU_ID,TYPE,BUG_NO,RELEASE,PATCH_DATE,LAST_REFERENCED,ABSTRACT
from sysman.mgmt_ecm_patch_cache

 ARU_ID     TYPE      BUG_NO     RELEASE     PATCH_DATE              LAST_REFERENCED        ABSTRACT                                                           
 ---------  --------  ---------  ----------  ----------------------  ---------------------  -------------------------------------------------------------------
 8866412    Patchset  5337014    10.2.0.3    2/21/2007 12:00:00 AM   9/28/2007 4:58:31 PM   10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER                      

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