Re: Using V$_SEQUENCES
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Fri, 6 Sep 2013 08:36:23 -0700 (PDT)
Message-ID: <1378481783.11319.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
My exact thought. Waiting as well for a response from the original poster.
From: Norman Dunbar <oracle_at_dunbar-it.co.uk> To: oracle-l_at_freelists.org
Sent: Friday, September 6, 2013 9:28 AM
Subject: Re: Using V$_SEQUENCES
Date: Fri, 6 Sep 2013 08:36:23 -0700 (PDT)
Message-ID: <1378481783.11319.YahooMailNeo_at_web121602.mail.ne1.yahoo.com>
My exact thought. Waiting as well for a response from the original poster.
David Fitzjarrell
From: Norman Dunbar <oracle_at_dunbar-it.co.uk> To: oracle-l_at_freelists.org
Sent: Friday, September 6, 2013 9:28 AM
Subject: Re: Using V$_SEQUENCES
Hi David,
On 06/09/13 16:22, David Fitzjarrell wrote:
> What sequence problem was introduced by moving to RAC, if I may ask? There may be another solution rather than granting select on a data dictionary view.
I was wondering that too. I am also wondering if all that is needed is to recreate the sequences (or alter them) to add order=y, which I believe is required for RAC.
Sits back and awaits corrections! ;-)
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 06 2013 - 17:36:23 CEST