Using oracle wallets to move data from Oracle to teradata [message #602053] |
Fri, 29 November 2013 01:40 |
Ankita06666
Messages: 2 Registered: October 2009 Location: New Delhi
|
Junior Member |
|
|
I want to replicate a table from oracle to Teradata.
I use oracle wallets to move data from Oracle to teradata.
The tables that I am replicating are huge.
I have done this by creating a batch job,which does a simple select from the Oracle table and does a insert into Teradata table.
And most of the times job failes with - oracle wallet error.
Checked the logs and it says that the external table is missing.
Below is the error:
1 ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB
I am trying to know the reason for the failure.
Any thoughts, ideas ?
|
|
|