Re: Data Maksing in OEM - change source database

We encountered a similar issue. In OEM's sysman schema...

select target_name, target_type, target_guid, host_name from mgmt$target where target_name = <new_source_db>;

Update source_id in MGMT_DM_SCOPESPECS with target_guid of the new source database.

In the application model, add the new source database and made it source.

Regards,

Doug

> On December 14, 2018 at 12:41 PM Jeff Chirco <backseatdba_at_gmail.com> wrote:
>
> I have Enterprise Manager 13c and use the Masking pack. Does anybody know to change the source database? I migrated a database and it has a new name in EM so I need to removed the old one but the masking application data modeling is tied to it and I can't see how to change the source. I can add a new "associated" database.
> Thanks in advance.
>
> Jeff
>

--
http://www.freelists.org/webpage/oracle-l