Skip to Main Content

How to auto update schema name from apex200200 to apex210200 in apex page items, regions etc?

Raj0509Oct 7 2022

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?

This post has been answered by Sylvain Martel on Oct 7 2022
Jump to Answer
Post Details
Added on Oct 7 2022