Home Code Snippets Oracle Reference Oracle Functions Oracle Error Codes Forum Oracle Jobs Oracle Blogs

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 , , , , , Leave a comment