Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can i load data into a teradata table directly from an oracle table 1

Status
Not open for further replies.
sivatcs

sivatcs

Programmer
Nov 24, 2005
3
US
I have a table A in oracle Database.
I have another table B in Teradata.
The structures of the above table are same.

I want to load the data in oracle table to Teradata table. Is there any utility to do this. I would also like to know whether i can do this through a SQL Script in unix.


 
Sort by date Sort by votes
The Oracle to Teradata Gateway will allow you to identify Teradata as an Oracle instance and do insert statements.

It sits on top of Teradata ODBC, and is very slow.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
167
Teamalone
Teamalone
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
146
johnherman
johnherman
multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
280
Miguel93
Miguel93
Janet Charbula
  • Locked
  • Question
Finding a value within a table
Replies
0
Views
111
Janet Charbula
Janet Charbula
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
129
tmcrouse
tmcrouse

Part and Inventory Search

Sponsor

Back
Top