Archives of the TeradataForum
Message Posted: Tue, 23 Mar 2004 @ 19:26:14 GMT
| Subj: | | Capturing Updates in a Readable File |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Tuesday, March 23, 2004 14:23 -->
My system is OLTP. There is journaling on the tables. Doesn't anyone have a method of capturing these updates in a readable file?
My problem is that nightly I need to send full copies of the tables to an Oracle application. First we Fastexport the data and then transmit
it to the Oracle server. Then it is loaded into Oracle which is taking very long. This entire process is taking about 12 hours. So they want us
to only send the updates made to the tables the previous day instead of the entire table.
Thanks.
| 
