This discussion is archived
2 Replies Latest reply: Jan 31, 2013 10:44 AM by Srini Chavali-Oracle RSS

Oracle 11g - Sequence Caching

RK334 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points