We use tables and views that are under apex200200 schema a lot in most of our apex applications. Recently, we did an upgrade where the schema name changed from apex200200 to apex210200 where it was a hassle to search the whole application, and individually replacing the schema name. We did do synonym and on each upgrade we created new synonym that points to new schema. Does anybody have any much better way of replacing the schema name in case of an upgrade?