SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys_guid() using a object identifer primary key column

699403May 8 2010 — edited May 8 2010

Hi there,

I intend to use the oracle supplied sys_guid() function to generate unique object identifiers for the primary key columns of different tables in my database. the following is oracle supplied documentation: http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/functions153.htm

I have read the documentation and this sys_guid() function is based upon the host process nd thread and timestamp..My question is will it ever run out of unique numbers and the example is using raw(32) field size, will it always be able to generate unique global identifier which is exactly 32 in length???

Many thanks.
Rohan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2010

Added on May 8 2010

1 comment

920 views