thank you all, very useful information.
-Naga
On Sun, Jul 15, 2018 at 9:29 AM, Stefan Knecht <knecht.stefan@xxxxxxxxx>
wrote:
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
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | @zztat_oracle | fb.me/zztat | zztat.net/blog/
