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.
if you set CACHE 20 in a RAC environment each node will cache 20 number. In your case - cached numbers will be 21-40 and 41-60 and the dba_sequences.last_number=60.
If you do export/import all the cached numbers will be lost and your first number will be last_number+1.