Re: [cx-oracle-users] How to sync two oracle databases (schemas)

[John N. <mr....@gm...>]

Triggers and two database links?



On Mon, Feb 10, 2020 at 8:03 PM M.M.Rashid (Rubel) <mm...@gm...>
wrote:

> Hello Community,
>
> Need suggestion - need to sync two oracle databases/schemas. Any changes
> on source DB to be propagated to the target DB (INSERT/UPDATE/DELETE).
> Commercial tools out there in the market but is not an option. I was
> thinking of using oracle exp/imp and Python to automate. Any suggestion is
> appreciated. Source is on-prem and target is hosted on AWS.
>
> Thanks,
> Rubel
>
>
>
> On Mon, Feb 10, 2020 at 8:55 PM <
> cx-...@li...> wrote:
>
>> Send cx-oracle-users mailing list submissions to
>>         cx-...@li...
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> or, via email, send a message with subject or body 'help' to
>>         cx-...@li...
>>
>> You can reach the person managing the list at
>>         cx-...@li...
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of cx-oracle-users digest..."
>>
>>
>> Today's Topics:
>>
>>    1. Re: cx-oracle-users Digest, Vol 142, Issue 1 (M.M.Rashid (Rubel))
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Mon, 10 Feb 2020 16:25:58 +0800
>> From: "M.M.Rashid (Rubel)" <mm...@gm...>
>> To: cx-...@li...
>> Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue
>>         1
>> Message-ID:
>>         <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=f=
>> vPc...@ma...>
>> Content-Type: text/plain; charset="utf-8"
>>
>> Dear All,
>>
>> Looking for some case studies on syncing two oracle databases/schemas
>> using
>> Python. There are commercial tools out in the market but we prefer to do
>> something using cx_Oracle , Python, exp/imp...etc
>>
>> Thanks in advance
>>
>> Regards,
>> Rashid
>>
>> On Tue, Dec 3, 2019 at 8:16 PM <
>> cx-...@li...> wrote:
>>
>> > Send cx-oracle-users mailing list submissions to
>> >         cx-...@li...
>> >
>> > To subscribe or unsubscribe via the World Wide Web, visit
>> >         https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> > or, via email, send a message with subject or body 'help' to
>> >         cx-...@li...
>> >
>> > You can reach the person managing the list at
>> >         cx-...@li...
>> >
>> > When replying, please edit your Subject line so it is more specific
>> > than "Re: Contents of cx-oracle-users digest..."
>> >
>> >
>> > Today's Topics:
>> >
>> >    1. cx_Oracle 7.3 (Anthony Tuininga)
>> >
>> >
>> > ----------------------------------------------------------------------
>> >
>> > Message: 1
>> > Date: Mon, 2 Dec 2019 18:09:14 -0700
>> > From: Anthony Tuininga <ant...@gm...>
>> > To: cx-...@li..., DB...@py...,
>> >         pyt...@py...
>> > Subject: [cx-oracle-users] cx_Oracle 7.3
>> > Message-ID:
>> >         <
>> > CAE...@ma...>
>> > Content-Type: text/plain; charset="utf-8"
>> >
>> > What is cx_Oracle?
>> >
>> > cx_Oracle is a Python extension module that enables access to Oracle
>> > Database for Python 3.x and 2.x and conforms to the Python database API
>> 2.0
>> > specifications with a number of enhancements.
>> >
>> >
>> > Where do I get it?
>> > https://oracle.github.io/python-cx_Oracle
>> >
>> > The easiest method to install/upgrade cx_Oracle is via pip as in
>> >
>> >     python -m pip install cx_Oracle --upgrade
>> >
>> >
>> > What's new?
>> >
>> > See my colleague's blog post for an overview:
>> >
>> >
>> https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi
>> >
>> > See the full release notes for all of the details:
>> >
>> >
>> https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019
>> >
>> > Please provide any feedback via GitHub issues (
>> > https://github.com/oracle/python-cx_Oracle/issues).
>> > -------------- next part --------------
>> > An HTML attachment was scrubbed...
>> >
>> > ------------------------------
>> >
>> >
>> >
>> > ------------------------------
>> >
>> > Subject: Digest Footer
>> >
>> > _______________________________________________
>> > cx-oracle-users mailing list
>> > cx-...@li...
>> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> >
>> >
>> > ------------------------------
>> >
>> > End of cx-oracle-users Digest, Vol 142, Issue 1
>> > ***********************************************
>> >
>>
>>
>> --
>> M. M. RASHID(Rubel)
>> Perth, Australia.
>> E-mail: mm...@gm...
>> Phone: +61 406996028 (Mobile)
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>>
>> ------------------------------
>>
>>
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>> ------------------------------
>>
>> End of cx-oracle-users Digest, Vol 143, Issue 1
>> ***********************************************
>
>
>>
>
> --
> M. M. RASHID(Rubel)
> Perth, Australia.
> E-mail: mm...@gm...
> Phone: +61 406996028 (Mobile)
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
-- 
John A. Nielson
(504) 344.7225