[cx-oracletools-users] copyTables - Requirements ; Wrapping in Transaction?
Brought to you by:
atuining
|
From: Victor H. <vic...@ya...> - 2011-11-03 02:02:41
|
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 |