Sequence too large

From: Lucia DeMeester <ldemeester_at_nm2.com>
Date: Wed, 28 Jun 2000 12:24:45 -0700
Message-Id: <10542.110701@fatcity.com>

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

---

3.0000E+13

Thanks in advance. Received on Wed Jun 28 2000 - 14:24:45 CDT