DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.WRM$_PDB_INSTANCE

Object Details
Object Name: WRM$_PDB_INSTANCE
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRM$_PDB_INSTANCE_PK
  1. ColumnDBID
  2. ColumnINSTANCE_NUMBER
  3. ColumnSTARTUP_TIME
  4. ColumnCON_DBID
  5. ColumnOPEN_TIME
Indexes
Index Type Uniqueness Tablespace Column
WRM$_PDB_INSTANCE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnDBID
ColumnINSTANCE_NUMBER
ColumnSTARTUP_TIME
ColumnCON_DBID
ColumnOPEN_TIME
Columns
Name Datatype Length Mandatory Comments
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
STARTUP_TIME TIMESTAMP(3) (11) Yes
CON_DBID NUMBER
Yes
OPEN_TIME TIMESTAMP(3) (11) Yes
OPEN_MODE VARCHAR2 (16)
PDB_NAME VARCHAR2 (128)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DBID
,      INSTANCE_NUMBER
,      STARTUP_TIME
,      CON_DBID
,      OPEN_TIME
,      OPEN_MODE
,      PDB_NAME
FROM SYS.WRM$_PDB_INSTANCE;

Dependencies

[top of page]

SYS.WRM$_PDB_INSTANCE does not reference any database object

SYS.WRM$_PDB_INSTANCE is referenced by following:

SchemaSYS
ViewINT$DBA_HIST_PDB_INSTANCE