[cx-oracletools-users] copyTables - Requirements ; Wrapping in Transaction?

[Victor H. <vic...@ya...>]

Hi,

I'm looking at using cx_OracleTool's copyData script to synchronise the
tables between two separate Oracle schemas.

Firstly, I noticed in the cx_OracleTools README that it lists cx_PyGenLib,
cx_PyOracleLib and cx_Oracle as it's requirements.

However, in the CopyData.py script, it has the following imports:

   - import cx_Logging
   - import cx_LoggingOptions
   - import cx_OptionParser (from PyGenLib)
   - import cx_OracleUtils (from PyOracleLib)
   - import os

The two Logging modules - they come from the cx_Logging project (
http://cx-logging.sourceforge.net/), right? Should they be added to the
requirements in the README file?

Second question - I have a source table and a destination table. I need to
DELETE the rows from the destination table, then run the COPY. Is it
possible to wrap these two operations in a transaction, whilst using the
copyData.py script? Basically, we want to be able to rollback the DELETE if
something goes wrong with the COPY?

Cheers,
Victor