返回数说广场 #吐槽大会#
0
CDB 库操作
在 CDB 数据库中执行 DBMS_PDB.CHECK_PLUG_COMPATIBILITY 包,检查 NON-CDB 数据库的兼容性:
-- 查看 CDB 数据库信息
set line2222
col name for a20
sys@oradb 2023-10-24 15:40:20> select name,cdb from v$database;
NAME CDB
-------------------- ---
ORCL YES
sys@oradb 2023-10-24 15:40:20> select name, open_mode, restricted, open_time, inst_id, con_id, dbid, con_uid from gv$pdbs;
NAME OPEN_MODE RES OPEN_TIME INST_ID CON_ID DBID CON_UID
-------------------- ---------- --- --------------------------------------------------------------------------- ---------- ---------- ---------- ----------
PDB$SEED READ ONLY NO 24-OCT-23 04.34.29.021 PM +08:00 1 2 4105319576 4105319576
sys@oradb 2023-10-24 15:40:41> select pdb_id, pdb_name, dbid, con_uid, con_id, status from cdb_pdbs;
PDB_ID PDB_NAME
0

353
分享
评论
热门数说