Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 13 Nov 2000 @ 21:18:28 GMT

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

Subj:   Re: Moving objects from Oracle 7.3 to Teradata V2R3
From:   Paul Johnson

We migrated almost 3 billion rows from Oracle 7 to V2R3 earlier this year. All Oracle extracts, and Teradata DDL/pre-load conditioning/loads were hand crafted with no real issues to report. Lack of an Oracle "Fastexport" style tool was a shame but a simple SQL Plus unload to the Unix file system did the trick.

Manually creating tables, views and indexes should create no problems, nor should triggers with the later DBMS releases. The Oracle data maintenance processes were analysed and re-written to make use of Teradata utilities such as Fastload, Multiload etc. Again, no real problems to report.

I think it's a fundamentally flawed approach to point an off the shelf software app at Oracle and ask it to migrate to Teradata, or any other DBMS for that matter. There are a multitude of physical design decisions to make when migrating from one platform to another. Simply doing a drag-and-drop is an approach fraught with potential problems.

Paul Johnson

  <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: 28 Jun 2020