Thursday, January 17, 2008

Exporting sequences in RAC

Using exp on RAC can lead to inconsistencies when exporting sequences. This is because each instance cache number of values from the sequence locally and at the time of the exp the last value on the node used for the exp is considered.

To avoid this use statistics=compute in the exp command parameter list.

exp test/test file=test.dmp object_consistent=y consistent=y statistics=compute owner=test