5.235 DBA_PDB_SAVED_STATES 5.236 DBA_PDB_SNAPSHOTFILE 5.237 DBA_PDB_SNAPSHOTS 5.238 DBA_PDBS 5.239 DBA_PENDING_CONV_TABLES 5.240 DBA_PENDING_TRANSACTIONS 5.241 DBA_PLSQL_COLL_TYPES 5.242 DBA_PLSQL_OBJECT_SETTINGS 5.243 DBA_PLSQL_TYPE_ATTRS ...
要查看Oracle数据库中DBA_PDBS视图以获取PDB(Pluggable Database)的状态信息,你可以按照以下步骤进行操作: 登录到Oracle数据库: 你需要使用具有足够权限的账户登录到Oracle数据库。通常,这需要DBA权限。你可以使用SQL*Plus、SQL Developer或其他数据库管理工具来连接数据库。 查询DBA_PDBS视图: 一旦登录到数据库,你可以...
Pluggable database altered. SQL> grant select_catalog_role to c##test; Grant succeeded. --修改container_data SQL> alter user c##test set container_data=all container=current; User altered. SQL> conn c##test/test Connected. SQL> select * from dba_pdbs; PDB_ID --- PDB_NAME --- DBID C...
In oracle 12c , when we startup the CDB, the PDBS will be in MOUNTED stage. We need to open them manually using alter pluggable PDB open. To make the PDBS open automatically, we can use the saved state option . This feature is available from Oracle 12.1.0.2 onwards For more information...
5.232 DBA_PDBS 5.233 DBA_PENDING_CONV_TABLES 5.234 DBA_PENDING_TRANSACTIONS 5.235 DBA_PLSQL_COLL_TYPES 5.236 DBA_PLSQL_OBJECT_SETTINGS 5.237 DBA_PLSQL_TYPE_ATTRS 5.238 DBA_PLSQL_TYPES 5.239 DBA_POLICIES 5.240 DBA_POLICY_ATTRIBUTES 5.241 DBA_POLICY_CONTEXTS 5.242 DBA_POLICY_GROUPS 5.243 DBA_PRIV...
SQL> select * from dba_pdbs; PDB_ID --- PDB_NAME --- DBID CON_UID GUID STATUS CREATION_SCN --- --- --- --- --- VSN LOGGING FOR FOR CON_ID --- --- --- --- ---