What is cx_OracleDBATools?
cx_OracleTools is a set of Python scripts that handle Oracle database
development tasks in a cross platform manner and improve (in my opinion)
on the tools that are available by default in an Oracle client
installation. Those who use cx_Oracle (a Python interface driver for
Oracle compatible with the DB API) may also be interested in this
project, if only as examples. Binaries are provided for those who do not
have a Python installation.
Where do I get it?
http://starship.python.net/crew/atuining
What's new?
1) Added ExportXML and ImportXML utilities for importing and exporting dat=
a
from an Oracle database as XML.
2) Added support in ExportData for limiting the number of rows exported an=
d
skipping some rows first.
3) Added support in CopyData for the case where all the columns on the tar=
get
table form the primary key.
4) Added support for case sensitive tables and column names in CopyData.
5) Added option --report-point to CopyData which defaults to --commit-poin=
t.
6) Added options --log-file, --log-level and --log-prefix to all of the to=
ols
and removed --timestamp and --prefix on DbDebugger since the new opti=
ons
cover the functionality of the old ones.
7) Added options --suppress-owner-dir, --include-roles, --include-users,
--no-related and --no-triggers to ExportObjects.
8) Added option --sort-by to DumpData to modify the query executed to incl=
ude
a sort clause.
9) Added option --only-if to DescribeSchema and ExportObjects which allows
for filtering the objects described by a where clause against dba_obj=
ects.
10) DbDebugger now displays the time to the microsecond if desired.
11) GeneratePatch now makes sure that owner changes are displayed before
displaying anything about the objects for that owner that are being
patched.
12) GeneratePatch now produces consistent results by performing a sort befo=
re
displaying any results.
13) Fixed bug in GeneratePatch parsing grants with the "with grant option"
specified.
14) Fixed bug in DescribeObject where connect statements were being display=
ed.
Anthony Tuininga
|
