ORA-12754 when creating pdb snapshot

郑全

ORA-12754 when creating pdb snapshot (Doc ID 2684452.1)        To BottomTo Bottom       

In this Document
Symptoms
Changes
Cause
Solution

APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
When user want to create a pdb snapshot, he encountered the following error:


SQL> ALTER PLUGGABLE DATABASE SNAPSHOT testsnap;
ALTER PLUGGABLE DATABASE SNAPSHOT testsnap
*
An error occurred on line 1. :
ORA-12754: feature PDB SNAPSHOT CAROUSEL has been disabled because it has no feature
CHANGES


CAUSE
From the following manual,

The PDB Snapshot Carousel is feature is only available for EE-ES (Exadata with Extra cost option),
and Cloud Platform: DBCS EE, DBCS EE-HP, DBCS EE-EP, and ExaCS.

https://docs.oracle.com/en/datab ... 7-9008-DCC9EDA45AB4
DatabaseOracleOracle DatabaseRelease 19
Database Licensing Information User Manual
Table 1-2 Consolidation
PDB Snapshot Carousel

SOLUTION
If you don't have EE-ES or the above Cloud platform, please don't use this feature.