Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2008 @ 11:27:41 GMT


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


Subj:   Re: How to achieve ROWID in Teradata
 
From:   Victor Sokovin

  I am working in Migration (oracle to TD) project while doing I am facing problem with ROWID i.e I can achieve the ROWID in V2R5.0 demo version but when I am trying to run the same query in V2R6.1 its not working i.e its giving error as ROWID is not allowed.  


  Can anybody help on this how to achieve the same in TD .  


Direct access to ROWID in Teradata is not recommended. You'll have to understand what exactly the Oracle application is doing with row IDs and think of an alternative in your Teradata "translation".

This subject is very well handled in the Archives of this Forum. Just a few threads which may provide a good introduction and further reading:

www.teradataforum.com/teradata/20020219_094825.htm

www.teradataforum.com/teradata/20040223_154642.htm


Victor



     
  <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