Re: Data comparison between two schemas

From: Nagaraj chk <nagaraj.chk_at_gmail.com>
Date: Mon, 16 Jul 2018 08:01:32 +0530
Message-ID: <CAG6s0C2gUfFbqEq8RAqPS67Nmzr7yumbtt=7jQroL3HbdheZ2w_at_mail.gmail.com>



thank you all, very useful information.

-Naga

On Sun, Jul 15, 2018 at 9:29 AM, Stefan Knecht <knecht.stefan_at_gmail.com> 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_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
Received on Mon Jul 16 2018 - 04:31:32 CEST

Original text of this message