Export from Oracle to Teradata? :(

[susheeltips]

Hi Guys!
Can someone give sample script to load the default scott database available in Oracle db onto Teradata? Your help is greatly appriciated.

Thanks in advance.

 

[tdatgod]

Hi,
on the DEMO disk you find a utility called OLEDBLOAD.

There is alos a DEMO example on how to use it.

You point the extract side at oracle and the load side at teradata and it will build the correct files to do the transfer.

---

 

[susheeltips]

Thank you, let me try that.

 

[susheeltips]

Hey Guys!

I was able to use the OLEDBdemo to export and import from SQL Server to Teradata but i still have a small problem using the same for Oracle.

When i give the source OLEDB provider for ODBC using a dsn created for Oracle, i don't get the list of the tables from oracle (scott for example) database and the application does not respond.

If it is the other way round when i use NCR as the source and OLEDB provider for ODBC using a dsn created for Oracle as destination the FastExport window starts and i get the following error at the end. To be frank i have created a Region table in scott table and trying to export Region table from oledbdemo database.

**** 12:06:40 UTY8715 FastExport is submitting the following request:

SELECT R_REGIONKEY, R_NAME, R_COMMENT FROM REGION ;
**** 12:06:41 UTY8724 Select request submitted to the RDBMS.
**** 12:06:46 UTY8725 Select execution completed. 2 data blocks generated.
**** 12:06:49 UTY4014 Access module error '34' received during 'close' operation
: '5 occurrences: Write failed because: Unspecified error.'

Any suggesstions.....

Thanks in advance.