All Forums UDA
Nits 10 posts Joined 05/06
04 May 2006
Importing Data from Teradata to Oracle

Hi,I want to import data based on some query from Teradata to Oracle.Please give suggestions in that respect.

Nytewynd 13 posts Joined 12/05
09 May 2006

You can set up a Oracle heterogeneous service to connect to teradata through an ODBC connection, and then create a DBLink right to Teradata.You can use the DBMS_HS_PASSTHROUGH functions to run native SQL on teradata and get the results back.The other option is to run your query in queryman, then export the results and load it into oracle using SQL Loader or Access.

You must sign in to leave a comment.