Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Moving objects from Oracle 7.3 to Teradata V2R3
From:   Linda Borushko

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023