Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 11 Jun 2007 @ 12:34:21 GMT

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

Subj:   Re: 5728: Partitioning violation for table TARGET
From:   D silva, Joseph Vinish

I assume your source is not partitioned.

When you partition a table, you are specifcying an expression (based on the partitioning columns) that evaluates to a number (which is the partition number).

This number (PARTITION) should be within the values of 1 and 65535. (so if your partition was deptno and you tried to have a deptno = 65599, you will get an error)

If you use RANGE_N, then the expression should be eithin the limits of one of the ranges if you had specified a range (let's say your partitioned a column BILLDATE to be between 2006-01-01 and 2006-12-31 EACH '1' MONTH and then you tried to insert a value for BILLDATE 2005-03-12 or say NULL and you don't have NORANGE or UNKNOWN partitions defined, it will error out).

If you use CASE_N, Should satisy one of the case conditions (if you are using CASE_N to partiton and there's no NOCASE or UNKNOWN partitions)

If you can post your Partitioning DDL, we might be able to suggest what to look for in the source table.

Joseph D'silva

  <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