RE: Oracle bug or I miss something
- From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2004 01:31:42 +0800
yes same user, by the way I just leave it with dba_sequences for the =
moment
I find no problem with all_triggers and all_synonyms
1:30 am already I want to go home, thanks all I am very tired....
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sharples
Sent: Thursday, December 02, 2004 1:10 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle bug or I miss something
are they run as the same user - if you dont have select privelege on
the seuqnce then you wont see it in all_sequences
On Thu, 2 Dec 2004 00:59:11 +0800, Sinardy Xing=20
oracle-l@xxxxxxxxxxxxx
> Select count(*) from all_sequences=3D20
>=20
> return 0
>=20
> Select count(*) from dba_sequences=3D20
>=20
> return correct # of sequence
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
