Archives of the TeradataForum

Message Posted: Sat, 11 Nov 2000 @ 16:20:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Could you please provide some more details on how you are moving from Oracle to Teradata? We are attempting to use SQL*PLUS COPY with the Oracle Gateway for Teradata. We are finding he performance to be very poor. We are also experiencing problems with date fields:

- Null dates

- Dates that cause 'unique constraint violations' in Teradata where the only difference in the Oracle row is

- the time portion of the date, which is dropped off during the COPY

- Dates with years greater than 3500

So, I am very interested to know how you are moving the data from Oracle to Teradata.

Thank you very much,

Linda Borushko
Bull Information Systems

	<Prev	Next>		<<First	<Prev	Next>	Last>>