Is there a way to exclude objects in Change Management's Schema Compare — oracle-tech

    Forum Stats

  • 3,715,959 Users
  • 2,242,917 Discussions
  • 7,845,703 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

user5749071
user5749071 Member Posts: 3 Red Ribbon

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.  

Thanks,

Dan

Answers

Sign In or Register to comment.