Home » SQL & PL/SQL » SQL & PL/SQL » Using oracle wallets to move data from Oracle to teradata
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 ?
Previous Topic: Insert Script for Inserting values from Excel file
Next Topic: need to understand syntax
Goto Forum:
  


Current Time: Fri Apr 19 19:21:01 CDT 2024