|
|
Archives of the TeradataForum
Message Posted: Tue, 24 Nov 2009 @ 16:18:56 GMT
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
| |