...
Part of this will involve updating the master datasource. More on that is described in OLE Database Master Data Source Management Process. But, I will refer to that master datasource here as OLEDBA. (Happens to be the name of the Oracle database schema.)
...