Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 31 May 2005 @ 12:23:46 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Maintaining Partitions Dynamically
From:   Howard Bradley

  I have a problem in migrating one of my oracle script where the partition maintenance is happening dynamically, in oracle they are list partitioned and they are dropped using a procedure, where the partition and table name is passed as a parameter.  

  In teradata we have converted the same to case_n  

  Can any of you please suggest what approach i should take in order to over come this issue.  

The approach I would suggest is :

1) Make a note of all the possible ways you can think of that might solve the problem (if you can't think of any the Teradata manuals are often quite useful as a starting point).

2) Develop and test each possible solution being careful to note which are the successful ones.

3) Evaluate all of the successful solutions on any other relevant criteria such as performance, site production standards, ease of future maintenance etc.

4) Decide which solution to adopt.

5) Implement the solution.

I am sure others will have different approaches but I find this works well for me.

Good luck


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020