| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sequence too large
Grant permissions on the sequence directly to the owner of the function;
i.e., not through a role.
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
From: Lucia DeMeester [mailto:ldemeester_at_nm2.com]
Sent: Wednesday, June 28, 2000 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Sequence too large
I am migrating Sybase into Oracle. There is a column called id in Sybase table that was generated by identify (like the sequence in Oracle). I queried the Sybase table to get the max (id) in the table ( 14 digits long, ex. 30000000018080) then created a sequence in Oracle and started the sequence at 30000000018081.
The owner of the sequence items_status_id_seq is MAIN. If I select the sequence from Oracle as main or use the main. qualifier, it display the scientific exp. value.
However, if I log on as the function user to query the
item_status_id_seq.nextval from dual, it gives me ORA-02289: sequence does
not exist.
(P.S. The function user has private synonym points to the sequence and was
granted a role that has select privilege to the sequence prior to query the
sequence.)
Does any one know why? Is this because the sequence too large? We need to store the sequence as the unique key and be able to display.
SQL> select main.items_status_id_seq.nextval from dual;
NEXTVAL
Thanks in advance.
Lucia
-- Author: Lucia DeMeester INET: ldemeester_at_nm2.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jun 28 2000 - 17:29:35 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |