I have databases in two locations.
in db 'A' I have a table called PEOPLE
in db 'B' I have a materialized view called PEOPLE which is selecting rows from PEOPLE@'A'
I added a column to the PEOPLE table in db 'A'. I need the materialized view to reckognize this column.
What would be the best approach?