How To Safely Revert Back Datafile Permissions For Source PDB After Removing All Snapshot Clones
(Doc ID 2627975.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
A PDB cannot be opened in read-write mode if we have previously created snapshot copy clones using that PDB even after the clones are dropped. This document explains how to ensure that all clones based on that PDB have been dropped and how to make the PDB read-write again.
When a snapshot copy PDB is created from a source PDB using create snapshot copy pdb, the permissions of datafiles of the source PDB are changed to read only mode.
Permissions before create snapshot copy pdb
Even if the user removes all the dependent snapshot PDBs the source cannot be opened read only.
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