Re: Data comparison between two schemas

This is the main landing page for license questions regarding these packs:

https://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC139

The pack in question is here:
https://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC2175 on the same page.

Database Lifecycle Management Pack.

It's a bit like the Compression one and it includes several things which aren't obvious, for example:

" The init.ora parameter ENABLE_DDL_LOGGING is licensed as part of the Database Lifecycle Management Pack when set to TRUE. When set to TRUE, the database reports schema changes in real time into the database alert log under the message group schema_ddl. The default setting is FALSE."

That one sure caught me by surprise.

Related to your question on schema comparison it says:

Schema Comparison From the Enterprise Manager home page, click on Targets, Databases, and then select a Database. From the database home page, click on  Schema, Change Management. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

If the Target Home Page is accessed directly or by other paths:

From the database home page, click on Schema, Change Management. All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of the Database Lifecycle Management Pack.

However, dbms_comparison is not listed there - so it should not be included in the license and available to use.

To be on the safe side, however, you may wanna shoot off an email to your account manager and have them confirm.

Stefan

On Tue, Jul 10, 2018 at 7:59 PM, Nagaraj chk <nagaraj.chk_at_gmail.com> wrote:

> Hi Gurus,
>
>
> We would like to know, Data comparison between two schemas are possible
> via OEM. I can see an option “Data Comparison” on OEM 13c console, but not
> sure if any license is required to test the option. We have a requirement
> to test the data integrity between two schemes and do you recommend any
> option to do in simpler way ?
>
> -Naga
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

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