RE: [SPAM] Re: shared database sequence.
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <JApplewhite@xxxxxxxxxxxxx>, <sjaffarhussain@xxxxxxxxx>
- Date: Mon, 26 Feb 2007 11:57:29 -0500
Yep, that will work too. But, consider performance implications if this
sequence is going to be hit very much at all.
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"Gentlemen, it is time to stop tuning SQL and start tuning users."
--Bill "Shrek" Thater, Oracle DBA
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
JApplewhite@xxxxxxxxxxxxx
Sent: Monday, February 26, 2007 11:13 AM
To: sjaffarhussain@xxxxxxxxx
Cc: oracle-l; oracle-l-bounce@xxxxxxxxxxxxx
Subject: [SPAM] Re: shared database sequence.
Importance: Low
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@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/26/2007 09:56 AM
Please respond to
sjaffarhussain@xxxxxxxxx
To
oracle-l <oracle-l@xxxxxxxxxxxxx>
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://jaffardba.blogspot.com/>
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
<http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
>
------------------------------------------------------------------------
----------
"Winners don't do different things. They do things differently."
Other related posts:
- » RE: [SPAM] Re: shared database sequence.
