Importing Data from Teradata to Oracle

UDA
Enthusiast

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.

1 REPLY
Enthusiast

Re: Importing Data from Teradata to Oracle

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.