Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Nov 2009 @ 16:18:56 GMT


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


Subj:   Re: Exchange Partitions
 
From:   Curley, David

You can't. I believe the best you can do is insert into the empty staging table, do whatever quality checks you can at that point, then insert into the final table (which could be an insert into a single table or an insert into an empty version of the final table unioning the new and old data).

It's definitely an inferior process to simply exchanging the partition. I'd say that after data concurrency and autonomous transactions, partition exchange is the next Oracle feature I most miss. (Next would be that the OLAP windowing functions work only over number of rows rather than data ranges, and then the fact that in 5 years on Oracle, I never found a query generating incorrect results, but in the last three weeks I've written two where Teradata gets the wrong answer.)


Dave



     
  <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