Archives of the TeradataForum
Message Posted: Tue, 29 Jul 2008 @ 11:27:41 GMT
| 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
| 
