正德厚生,臻于至善

修改PDB默认Undo表空间

With Local Undo enabled, How To Set Specific Undo Tablespace For Each PDB Instance On RAC Node (Doc ID 2673826.1)

SOLUTION
As this database is enabled with LOCAL UNDO, assign specific Undo tablespace to each PDB on node-1 & node-2 by executing below commands.

On node-1:
alter session set container=BZPROD;
alter system set undo_tablespace=APPS_UNDOTS1 container=current sid='BZCDB1' scope=both;             >>>> sid=First Instance
On Node-2
alter session set container=BZPROD;
alter system set undo_tablespace=APPS_UNDOTS2 container=current sid='BZCDB2' scope=both;             >>>> sid=Second Instance

alter pluggable database BZPROD open;
alter pluggable database all save state;
赞(0) 打赏
未经允许不得转载:徐万新之路 » 修改PDB默认Undo表空间
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏