We perform weekly table moves between several schema using expdp and impdp. Some tables have sequences associated with the ID columns and I'd like to ensure that the sequences are always up to date on the destination table after a load.
Is the following sequence of events a safe and acceptable way of handling this?
Backup sequence properties to a table
Drop sequences
Load tables (with metadata)
Find which has the greatest last cached value, backup sequence table or new imported sequence.
Update accordingly
Are there any pitfalls with this method, and if so are there tried and tested methods?