返回数说广场 #日有所学#
2
--CDB启动自动打开pdb
--方法一: save state
alter pluggable database pdb2 open save state;
select con_name,instance_name,state from cdb_pdb_saved_state;
--取消状态恢复默认
alter pluggable database pdb2 discard state;
--方法二, 使用触发器
create or replace trigger open_all_pdbs
after startup on database
begin
execute immediate 'alter pluggable database all open instances=all';
end;
0
2 433
分享
评论
热门数说


