Yes, the multitenant architecture allows this.
SQL>select name, value , ISPDB_MODIFIABLE from V$parameter where name = 'recyclebin';
NAME VALUE ISPDB
------------------------------ -------------------- -----
recyclebin OFF TRUE
Switch container to a PDB:
SQL>alter session set container=veg7;
Session altered.
SQL>show con_name
CON_NAME
------------------------------
VEG7
SQL>select name, value , ISPDB_MODIFIABLE from V$parameter where name = 'recyclebin';
NAME VALUE ISPDB
------------------------------ -------------------- -----
recyclebin ON TRUE
Remember that the pluggable database must be closed and reopened if you toggle the recyclebin on/off:
SQL>alter session set container=veg7;
Session altered.
SQL>alter system set recyclebin=on container=current scope=spfile;
System altered.
SQL>alter pluggable database close;
Pluggable database altered.
cdb>SQL>alter pluggable database open;
Pluggable database altered.
If you want to toggle the recyclebin on/off for the container database, the procedure is the same except that the entire instance will have to be bounced.
No comments:
Post a Comment