Database Administration (MOSC)

MOSC Banner

Cloning a Remote PDB - skip PDB init parameters copying

Dear Oracle Community

In our environment we have case where we want to skip PDB level init parameters copying during hot clone of 19c PDBs. I searched on Oracle docs and couldn't find suitable option which can be used after "CREATE PLUGGABLE DATABASE FROM PDB1@PDB1_LINK" statement for this case.

For example, following init parameters are set on source PDB level which we want to skip during cloning and leave them to inherit CDB level values (or default), especially "optimizer_features_enable":

_b_tree_bitmap_plans=FALSE;

_fix_control='17376322:OFF';

_optimizer_aggr_groupby_elim=FALSE;

_optimizer_dsdir_usage_control=0;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center