My Oracle Support Banner

How to Handle Materialized Views When You Upgrade or Clone a Database (Doc ID 1406586.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Goal

There are several ways by which to upgrade or clone a database.  For example, (1) the Database Upgrade Assistant (DBUA), (2) RMAN clone to auxiliary database, (3) copying files from a cold/hot backup, (4) export/import, or (5) export/import with transportable tablespaces (TTS).  Your materialized views should still be fast refreshable after one of these operations, provided you follow the actions given below for your particular case.

This note is applicable only to read-only materialized views; updatable materialized views are not covered here.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Read This First 
 Important Information
 General Actions before the Upgrade/clone/copy of the Database
 General Actions after the Upgrade/clone/copy of the Database
 Case 1: Upgrade the Master or Mview Database in Place with DBUA
 Method: Database Upgrade Assistant (DBUA).
 Result
 Actions to take before the upgrade
 Actions to take after the upgrade
 
Case 2: Clone/copy the Master Database to a New Database Using the Same SYSTEM Tablespace
 Method: RMAN clone database, or restore of all database files from cold/hot backup to new server.
 Result
 Take these actions before the clone/copy
 Take these actions after the clone/copy
 Case 3: Clone/copy the Mview Database to a New Database Using the Same SYSTEM Tablespace
 Method: RMAN clone database, or restore of all database files from cold/hot backup to new server.
 Result
 Take these actions before the clone/copy
 Take these actions after the clone/copy
 Case 4: Upgrade/clone the Master Database to a New Database Using a New SYSTEM Tablespace
 Method: Standard export/import in schema or full database mode, datapump, or TTS
 Results
 Take these actions before the upgrade/clone
 Take these actions after the upgrade/clone
 Case 5: Upgrade/clone the Mview Database to a New Database Using a New SYSTEM Tablespace
 Method: Standard export/import in schema or full database mode, datapump, or TTS
 Results
 Take these actions before the upgrade/clone
 Take these actions after the upgrade/clone
 If all else fails . . .
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.