Tag Archives: upgrade
Paying attention to Oracle sequences when upgrading / migrating
it would not be feasible to use the shiny, trusted front-end tool that the DBAs had to browse and navigate to each application schema and manually click on each sequence to reverse engineer it. We needed dynamic SQL to do them all in one shot but without all those those SYS, sample and unused schemas detailed in support docs 207560.1 and 270516.1
Posted in DBA tips
Also tagged dynamic SQL, migration, planning, rescue, reverse enginering, sequences
Leave a comment
