| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Sequence too large
-----Original Message-----
From: Lucia DeMeester [mailto:ldemeester_at_nm2.com]
Sent: Wednesday, June 28, 2000 12:25 PM
To: 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
 |
 |