We have plaining to migrated Oracle database 10 g r2 32 bit 11gr2 64 bit . after successful done in impdp it will work well excepted thall all the sequences . is it any way can export full db and resetting the sequences ?
Would it not be incorrect be to reset the sequence after performing the migration? What if the sequence is used for some Primary/Unique key column?
WHat's wrong with the sequences?
Do you have gaps?
Are the sequence numbers lower than they should be?
Did you stop all access on the source system before the export?
Yes it s used for primary and unique key
In that case wouldn't resetting it cause problem?