Forum Stats

  • 3,836,754 Users
  • 2,262,182 Discussions


Is there a way to exclude objects in Change Management's Schema Compare

user5749071 Member Posts: 3 Blue Ribbon
edited Feb 12, 2019 10:14AM in Enterprise Manager Ops Center

Hi All,

I'm supporting a project that has 6000ish DB objects and many of the object names have system generated tables / objects (i.e. table names which have '$' in them). 

Is there a way to exclude system generated objects when comparing schemas?   I know you can choose which objects you want to include using a prefix (i.e. TMP, TAD etc) but these schemas do not have standard table naming practices so they are all over the place.

Any way to tackle this?   I'd like to make this an automated report going forward so we can compare schemas on a regular basis to look for "real" differences.