Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can SYS_GUID() function generate same guid at another db

I am planning to use SYS_GUID() function to generate primary key in an existing table(Primary key does not exist in that table as of now)

I wanted to know if in certain case if we sync data from one database to another , is it possible that Oracle generate same guid at another db ?

Thank you

like image 983
Khushi Avatar asked Feb 18 '26 16:02

Khushi


1 Answers

No. GUID is Globally unique. See alsi the documentation https://docs.oracle.com/cd/B13789_01/server.101/b10759/functions153.htm

like image 100
Ghasem Naddaf Avatar answered Feb 21 '26 14:02

Ghasem Naddaf



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!