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@xxxxxxxxx> 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
