Re: shared database sequence.

Yes, across Database Links. I just tested it. Syntax like this: Select <SequenceOwner>.<RemoteSegName>.NextVal@<DBLinkName> From Dual ;

Dual can have the @<DBLinkName> or not, didn't seem to make a difference. Don't know what the ramifications are for either.

BTW, I tested this in about 2 minutes. You could easily have done the same.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

 Same-Day Stump Grinding! Senior Discounts!

• Mike's Tree Service

"Syed Jaffar Hussain" <sjaffarhussain_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
02/26/2007 09:56 AM
Please respond to
sjaffarhussain_at_gmail.com

To
oracle-l <oracle-l_at_freelists.org>
cc

Subject
shared database sequence.

Hello List,  

Is it possible to share a database sequence between multiple databases? Not in RAC of course.
We are planning to have two databses exchanging information (replicating) using third party solution. But, stuck with the issues of sequences.  

Thanks

-- 
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------


"Winners don't do different things. They do things differently." 


--
http://www.freelists.org/webpage/oracle-l