Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle ROWID Question

Status
Not open for further replies.

ksr

MIS
Jul 3, 2001
11
IN
Does Import / Export of Database, change the Internal RowID of Data being maintained by Oracle. Does installing a new version of Oracle, changes the RowID of Data already entered through the lower version.
 
Hi.
The rowid is the mechanism which Oracle uses to physically locate your records. So everything which physically moves your data (like export/import, alter table move,...) will change the rowids. Also RowIDs may look different in different versions (e.g. 7.3 and 9.2 look totally different)

Stefan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top