Re: cx-oracle-users Digest, Vol 142, Issue 1
Anthony Tuininga <[email protected]> Mon, 10 Feb 2020 10:50:54 -0700
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAE1XR-5SNiVfmU9AeJnRaiWnH5c=5-by2Peh=8snkCMV54Py6A@mail.gmail.com> |
--===============8133037936843616837== Content-Type: multipart/alternative; boundary="000000000000246e86059e3c6216" --000000000000246e86059e3c6216 Content-Type: text/plain; charset="UTF-8" Hi Rashid, I don't know exactly what you are looking for, but I wrote a number of tools some time ago to assist with the generation of patch scripts for Oracle Database. ExportObjects was used to generate a set of files containing the objects found within a particular schema or set of schemas. These could be stored in a source control system. GeneratePatch was used to generate the patch scripts I mentioned. You can find these tools here: https://github.com/anthony-tuininga/cx_OracleTools. The tools still work but I haven't done much with them in the past few years. Hopefully they are of some use to you! Anthony On Mon, Feb 10, 2020 at 1:27 AM M.M.Rashid (Rubel) <[email protected]> wrote: > 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-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote: > >> Send cx-oracle-users mailing list submissions to >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> >> 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-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> >> You can reach the person managing the list at >> cx-oracle-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> >> 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 <[email protected]> >> To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org, [email protected], >> [email protected] >> Subject: [cx-oracle-users] cx_Oracle 7.3 >> Message-ID: >> < >> CAE1XR-5eTEJziLJkHYSCh1yZ63QrP5iGQQHCogAvCjJ3Q+DfZw-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org> >> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> 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: [email protected] > Phone: +61 406996028 (Mobile) > _______________________________________________ > cx-oracle-users mailing list > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > --000000000000246e86059e3c6216 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Hi Rashid,<div><br></div><div>I don't know exactly wha= t you are looking for, but I wrote a number of tools some time ago to assis= t with the generation of patch scripts for Oracle Database. ExportObjects w= as used to generate a set of files containing the objects found within a pa= rticular schema or set of schemas. These could be stored in a source contro= l system. GeneratePatch was used to generate the patch scripts I mentioned.= You can find these tools here:=C2=A0<a href=3D"https://github.com/anthony-= tuininga/cx_OracleTools">https://github.com/anthony-tuininga/cx_OracleTools= </a>. The tools still work but I haven't done much with them in the pas= t few years. Hopefully they are of some use=C2=A0to you!</div><div><br></di= v><div>Anthony</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" c= lass=3D"gmail_attr">On Mon, Feb 10, 2020 at 1:27 AM M.M.Rashid (Rubel) <= <a href=3D"mailto:[email protected]">[email protected]</a>> wrote:<br></= div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor= der-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Dear= All,<div><br></div><div>Looking for some case studies on syncing two oracl= e databases/schemas using Python. There are commercial tools out in the mar= ket but we prefer to do something=C2=A0using cx_Oracle , Python, exp/imp...= etc</div><div><br></div><div>Thanks in advance</div><div><br></div><div>Reg= ards,</div><div>Rashid</div></div><br><div class=3D"gmail_quote"><div dir= =3D"ltr" class=3D"gmail_attr">On Tue, Dec 3, 2019 at 8:16 PM <<a href=3D= "mailto:cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">cx= -oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>> wrote:<br></div><blockq= uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p= x solid rgb(204,204,204);padding-left:1ex">Send cx-oracle-users mailing lis= t submissions to<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:[email protected]= orge.net" target=3D"_blank">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <br> To subscribe or unsubscribe via the World Wide Web, visit<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"https://lists.sourceforge.net/lists/= listinfo/cx-oracle-users" rel=3D"noreferrer" target=3D"_blank">https://list= s.sourceforge.net/lists/listinfo/cx-oracle-users</a><br> or, via email, send a message with subject or body 'help' to<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:cx-oracle-users-request@lists= .sourceforge.net" target=3D"_blank">[email protected]= ge.net</a><br> <br> You can reach the person managing the list at<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:[email protected]= ourceforge.net" target=3D"_blank">cx-oracle-users-owner-5NWGOfrQmneRv+LV9MX5upmplPMkL2fr@public.gmane.org= et</a><br> <br> When replying, please edit your Subject line so it is more specific<br> than "Re: Contents of cx-oracle-users digest..."<br> <br> <br> Today's Topics:<br> <br> =C2=A0 =C2=A01. cx_Oracle 7.3 (Anthony Tuininga)<br> <br> <br> ----------------------------------------------------------------------<br> <br> Message: 1<br> Date: Mon, 2 Dec 2019 18:09:14 -0700<br> From: Anthony Tuininga <<a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a>><br> To: <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_bla= nk">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>, <a href=3D"mailto:DB-SIG@pyt= hon.org" target=3D"_blank">[email protected]</a>,<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:[email protected]" t= arget=3D"_blank">[email protected]</a><br> Subject: [cx-oracle-users] cx_Oracle 7.3<br> Message-ID:<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <<a href=3D"mailto:CAE1XR-5eTEJziLJkHYSCh1yZ= 63QrP5iGQQHCogAvCjJ3Q%[email protected]" target=3D"_blank">CAE1XR-5eTEJ= ziLJkHYSCh1yZ63QrP5iGQQHCogAvCjJ3Q+DfZw-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org</a>><br> Content-Type: text/plain; charset=3D"utf-8"<br> <br> What is cx_Oracle?<br> <br> cx_Oracle is a Python extension module that enables access to Oracle<br> Database for Python 3.x and 2.x and conforms to the Python database API 2.0= <br> specifications with a number of enhancements.<br> <br> <br> Where do I get it?<br> <a href=3D"https://oracle.github.io/python-cx_Oracle" rel=3D"noreferrer" ta= rget=3D"_blank">https://oracle.github.io/python-cx_Oracle</a><br> <br> The easiest method to install/upgrade cx_Oracle is via pip as in<br> <br> =C2=A0 =C2=A0 python -m pip install cx_Oracle --upgrade<br> <br> <br> What's new?<br> <br> See my colleague's blog post for an overview:<br> <a href=3D"https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-dat= abase-is-on-pypi" rel=3D"noreferrer" target=3D"_blank">https://blogs.oracle= .com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi</a><br> <br> See the full release notes for all of the details:<br> <a href=3D"https://cx-oracle.readthedocs.io/en/latest/release_notes.html#ve= rsion-7-3-december-2019" rel=3D"noreferrer" target=3D"_blank">https://cx-or= acle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019<= /a><br> <br> Please provide any feedback via GitHub issues (<br> <a href=3D"https://github.com/oracle/python-cx_Oracle/issues" rel=3D"norefe= rrer" target=3D"_blank">https://github.com/oracle/python-cx_Oracle/issues</= a>).<br> -------------- next part --------------<br> An HTML attachment was scrubbed...<br> <br> ------------------------------<br> <br> <br> <br> ------------------------------<br> <br> Subject: Digest Footer<br> <br> _______________________________________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/list= info/cx-oracle-users</a><br> <br> <br> ------------------------------<br> <br> End of cx-oracle-users Digest, Vol 142, Issue 1<br> ***********************************************<br> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><div dir=3D"ltr"><div>M. M. RASHID(Rubel)</div><div>Perth, Australia.</div= ><div>E-mail: <a href=3D"mailto:[email protected]" target=3D"_blank">mmrube= [email protected]</a>=C2=A0 =C2=A0</div><div>Phone: +61 406996028 (Mobile)</div><= /div></div> _______________________________________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/list= info/cx-oracle-users</a><br> </blockquote></div> --000000000000246e86059e3c6216-- --===============8133037936843616837== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============8133037936843616837== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users --===============8133037936843616837==--