This was an interesting question I received from Alain Fuhrer a couple of weeks ago: “Why can’t I drop a tablespace in a PDB whit a Guaranteed Restore Point being active?”. It’s important to note that the GRP is not active in the same but in another PDB.
An SR resolved the issue. But in case you face the same situation, here’s the solution.
Drop a tablespace in a PDB with a Guaranteed Restore Point being active
Simple test scenario. These are my PDBs:
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
… Continue reading...
