Upgrade and materialized views
We are upgrading our 12C(12.1.0.2) databases to 19C.
We currently have a production database DBPROD and a reporting database DBREPT. They are both at 12.1.0.2. There are materialized views in place to copy data from DBPROD to DBREPT on a nightly basis.
My questions are:
- Can I upgrade DBPROD to 19C and leave DBREPT at 12C for a short period(i.e. a couple of weeks)?
- OR can I upgrade DBREPT to 19C and leave DBPROD at 12C for a short period?
- Will the materialized views work moving data from a 19C database to a 12C database or must both databases be upgraded at the same time to ensure the materialized views continue to work?
We currently have a production database DBPROD and a reporting database DBREPT. They are both at 12.1.0.2. There are materialized views in place to copy data from DBPROD to DBREPT on a nightly basis.
My questions are:
- Can I upgrade DBPROD to 19C and leave DBREPT at 12C for a short period(i.e. a couple of weeks)?
- OR can I upgrade DBREPT to 19C and leave DBPROD at 12C for a short period?
- Will the materialized views work moving data from a 19C database to a 12C database or must both databases be upgraded at the same time to ensure the materialized views continue to work?
0