Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!agilent.com!sdd.hp.com!ihnp4.ucsd.edu!ucdavis!not-for-mail From: Richard Crawford Newsgroups: comp.databases.oracle.server Subject: Oracle equivalent to SS7 "uniqueidentifier"? Date: Mon, 02 Feb 2004 14:49:17 -0800 Organization: The Lair of Seamus the Miracle Penguin Lines: 14 Message-ID: Reply-To: rscrawford.penguin@mossroot.remove_waterfowl.com NNTP-Posting-Host: unexgal61.ucdmc.ucdavis.edu Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: woodrow.ucdavis.edu 1075762162 5828 152.79.198.61 (2 Feb 2004 22:49:22 GMT) X-Complaints-To: usenet@ucdavis.edu NNTP-Posting-Date: Mon, 2 Feb 2004 22:49:22 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253495 The database which I am migrating in our office from MS SQL Server 7 to Oracle has a table which includes a field of type "uniqueidentifier". As far as I can tell, the purpose of this type is to make a row in that table absolutely unique within the entire database and not just unique within the table. The field contains strings like, "B289DA02-B9B3-11D4-9DCD-00D0B79147DF". This wouldn't bother me ordinarily, but the values in this field are being used to key to other rows in other tables. When a new record is created in the database, it needs to have a field like this. I doubt that there's any equivalent to this field type in Oracle, and I can't see a need for it, but it's a big obstacle for me. Does anyone have any suggestions for how to get around this problem?