911- Please Help Me
From: <azhan98_at_tm.net.my>
Date: Mon, 12 Oct 1998 10:44:53 GMT
Message-ID: <6vsmj5$n7h$1_at_nnrp1.dejanews.com>
I have 2 sequence.
I remember I created it the same way.
Somehow, one of it give me a compilation error when I refer the value from Oracle Application (Oracle Manufacturing). I also have granted both to public.
Date: Mon, 12 Oct 1998 10:44:53 GMT
Message-ID: <6vsmj5$n7h$1_at_nnrp1.dejanews.com>
I have 2 sequence.
I remember I created it the same way.
Somehow, one of it give me a compilation error when I refer the value from Oracle Application (Oracle Manufacturing). I also have granted both to public.
What is the SQL command I can use to see the sequence info (to see the difference between that two sequence). Something like:
who have the privillege on it, the source script. I mean all info on the sequence, because there must be something that different that cause on of it failed during compilation.Because of privillege etc.
Can I copy a sequence and give a new sequence name to make a new sequence.Is it possible?
Please...
Norazman
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 12:44:53 CEST