2 Replies Latest reply: Jan 31, 2013 12:44 PM by Srini Chavali-Oracle RSS

    Oracle 11g - Sequence Caching

      From the oracle documentation, http://docs.oracle.com/cd/E11882_01/server.112/e10701/original_export.htm#BABJHCDH
      it says that sequence numbers that have been allocated are available for use in the current database.

      I have a table Test which has a column test_id having a sequence test_sequence.

      Max value in the test_id is 20 and assume if test_sequence is cached for 20 in a 2 RAC node with each node caching numbers from 20-30 and 30-40.

      If I do an export and import the sequences to a new database, will my next sequence number in the new database be 41 ?

      If so, what will be the LAST_NUMBER in the dba_Sequences table in the source database.

      Thanks in advance.