ORACLE已安装组件版本信息 DBA_REGISTRY

青旅半醒 2023-10-18 21:09 15阅读 0赞

## DBA\_REGISTRY ##

`DBA_REGISTRY` displays information about the components loaded into the database.

Related View

`USER_REGISTRY` displays information about the components loaded into the database that are owned by the current user.

<table> 
 <thead> 
  <tr> 
   <th>Column</th> 
   <th>Datatype</th> 
   <th>NULL</th> 
   <th>Description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>COMP_ID</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Component identifier</td> 
  </tr> 
  <tr> 
   <td><code>COMP_NAME</code></td> 
   <td><code>VARCHAR2(255)</code></td> 
   <td>&nbsp;</td> 
   <td>Component name</td> 
  </tr> 
  <tr> 
   <td><code>VERSION</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td>&nbsp;</td> 
   <td>Component version loaded</td> 
  </tr> 
  <tr> 
   <td><code>STATUS</code></td> 
   <td><code>VARCHAR2(11)</code></td> 
   <td>&nbsp;</td> 
   <td>Component status: 
    <ul> 
     <li> <p><code>INVALID</code></p> </li> 
     <li> <p><code>VALID</code></p> </li> 
     <li> <p><code>LOADING</code></p> </li> 
     <li> <p><code>LOADED</code></p> </li> 
     <li> <p><code>UPGRADING</code></p> </li> 
     <li> <p><code>UPGRADED</code></p> </li> 
     <li> <p><code>DOWNGRADING</code></p> </li> 
     <li> <p><code>DOWNGRADED</code></p> </li> 
     <li> <p><code>REMOVING</code></p> </li> 
     <li> <p><code>REMOVED</code></p> </li> 
    </ul></td> 
  </tr> 
  <tr> 
   <td><code>MODIFIED</code></td> 
   <td><code>VARCHAR2(20)</code></td> 
   <td>&nbsp;</td> 
   <td>Time when the component was last modified</td> 
  </tr> 
  <tr> 
   <td><code>NAMESPACE</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>Component namespace</td> 
  </tr> 
  <tr> 
   <td><code>CONTROL</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>User that created the component entry</td> 
  </tr> 
  <tr> 
   <td><code>SCHEMA</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td><code>NOT NULL</code></td> 
   <td>User that contains the objects for the component</td> 
  </tr> 
  <tr> 
   <td><code>PROCEDURE</code></td> 
   <td><code>VARCHAR2(61)</code></td> 
   <td>&nbsp;</td> 
   <td>Validation procedure</td> 
  </tr> 
  <tr> 
   <td><code>STARTUP</code></td> 
   <td><code>VARCHAR2(8)</code></td> 
   <td>&nbsp;</td> 
   <td>Indicates whether the component requires a startup after the upgrade (<code>REQUIRED</code>) or not</td> 
  </tr> 
  <tr> 
   <td><code>PARENT_ID</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td>&nbsp;</td> 
   <td>Parent component identifier</td> 
  </tr> 
 </tbody> 
</table>