📄 refrn.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><html lang="en.us"><head><meta name="Generator" content="Quadralay WebWorks Publisher 5.0.4"><meta name="Page" content="DefaultSingle"><meta name="Title" content=" Oracle9i Database Reference"><title> Oracle9i Database Reference</title> <link rel="home" href="../../products.htm" title="Library"><link rel="toc" href="toc.htm" title="Contents"><link rel="index" href="index.htm" title="Index"><link rel="copyright" href="../common/html/cpyr.htm" title="Copyright"><link rel="up" href="toc.htm" title="Up"><link rel="next" href="sqlrf.htm" title="Next"><link rel="previous" href="migng.htm" title="Previous"></head> <body bgcolor="#ffffff"><a name="top"></a><table cellspacing="0" cellpadding="0" width="100%"><tr> <td align="LEFT" valign="TOP"><font color="#330099" face="Helvetica, Arial, sans-serif"><b>Oracle9<i>i</i> Database Generic Documentation Addendum<br>Release 2 (9.2)</b><br>Part Number A97283-01</font></B></td><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><tr><td align="CENTER" valign="TOP" width="25%"><a href="toc.htm"><img src="conticon.gif" alt="Go To Table Of Contents" border="0" height="30"width="30"><br><font size="-2">Contents</font></a></td><td align="CENTER" valign="TOP" width="25%"><a href="index.htm"><img src="indxicon.gif" alt="Go To Index" border="0" height="30"width="30"><br><font size="-2">Index</font></a></td></tr></table></td></tr></table><hr><p><a href="migng.htm"><img src="larrow.gif" alt="Go to previous page" border="0" height="30" width="40"></a><a href="sqlrf.htm"><img src="rarrow.gif" alt="Go to next page" border="0" height="30" width="40"></a> <div class="IND"><!-- End Header --><a name="1081559"></a><!--TOC=Title-"1081559"--><h1 class="Title"><font face="Arial, Helvetica, sans-serif" color="#330099">8<br> Oracle9<em class="Italic">i</em> Database Reference</font></h1><!--/TOC=Title--><a name="1081563"></a><p class="BP">This chapter lists additions and corrections to <em class="Italic">Oracle9i Database Reference</em>, Release 2 (9.2).</p><a name="1081572"></a><p class="BP">This chapter contains the following topic:</p><ul class="LB1"><li class="LB1" type="DISC"><a name="1081567"></a><a href="refrn.htm#139394">Static Data Dictionary View Corrections</a><p></ul><a name="139394"></a><!--TOC=h1-"139394"--><h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099"> Static Data Dictionary View Corrections</font></h2><!--/TOC=h1--><a name="139400"></a><p class="BP">The following sections describe additional static data dictionary views that were not documented in <em class="Italic">Oracle9i Database Reference</em>.</p><a name="139402"></a><!--TOC=h2-"139402"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_LOB_TEMPLATES</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_LOB_TEMPLATES</code> describes the LOB subpartition templates accessible to the current user.</p><a name="139405"></a><!--TOC=h3-"139405"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="139407"></a><code>DBA_LOB_TEMPLATES</code> describes all LOB subpartition templates in the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_LOB_TEMPLATES</code> describes the LOB subpartition templates owned by the current user. This view does not display the <code>USER_NAME</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="139046"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139059"></a><p class="TB"><code>USER_NAME</code> </td><td class="Informal"><a name="139061"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139063"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139065"></a><p class="TB">Owner of the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139075"></a><p class="TB"><code>TABLE_NAME</code> </td><td class="Informal"><a name="139077"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139079"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139081"></a><p class="TB">Name of the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139091"></a><p class="TB"><code>LOB_COL_NAME</code> </td><td class="Informal"><a name="139093"></a><p class="TB"><code>VARCHAR2(4000)</code> </td><td class="Informal"><a name="139095"></a><p class="TB"> </td><td class="Informal"><a name="139097"></a><p class="TB">Name of the LOB column </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139107"></a><p class="TB"><code>SUBPARTITION_NAME</code> </td><td class="Informal"><a name="139109"></a><p class="TB"><code>VARCHAR2(34)</code> </td><td class="Informal"><a name="139111"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139113"></a><p class="TB">Name of the subpartition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139123"></a><p class="TB"><code>LOB_SEGMENT_NAME</code> </td><td class="Informal"><a name="139125"></a><p class="TB"><code>VARCHAR2(34)</code> </td><td class="Informal"><a name="139127"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139129"></a><p class="TB">Name of the LOB segment </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139139"></a><p class="TB"><code>TABLESPACE_NAME</code> </td><td class="Informal"><a name="139141"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139143"></a><p class="TB"> </td><td class="Informal"><a name="139145"></a><p class="TB">Tablespace name of the subpartition </td></tr></table><table class="TableNote" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><tr class="TableNote" align=LEFT valign=TOP><td class="TableNote"></td></tr></table></a> </ul><a name="139412"></a><!--TOC=h2-"139412"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_SUBPARTITION_TEMPLATES</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_SUBPARTITION_TEMPLATES</code> describes the subpartition templates accessible to the current user.</p><a name="139415"></a><!--TOC=h3-"139415"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="768"></a><code>DBA_SUBPARTITION_TEMPLATES</code> describes all subpartition templates in the database.<p><li class="LB1" type="DISC"><a name="139418"></a><code>USER_SUBPARTITION_TEMPLATES</code> describes the subpartition templates owned by the current user. This view does not display the <code>USER_NAME</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="139156"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139169"></a><p class="TB"><code>USER_NAME</code> </td><td class="Informal"><a name="139171"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139173"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139175"></a><p class="TB">Owner of the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139185"></a><p class="TB"><code>TABLE_NAME</code> </td><td class="Informal"><a name="139187"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139189"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139191"></a><p class="TB">Name of the table </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139201"></a><p class="TB"><code>SUBPARTITION_NAME</code> </td><td class="Informal"><a name="139203"></a><p class="TB"><code>VARCHAR2(34)</code> </td><td class="Informal"><a name="139205"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="139207"></a><p class="TB">Name of the subpartition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139217"></a><p class="TB"><code>SUBPARTITION_POSITION</code> </td><td class="Informal"><a name="139219"></a><p class="TB"><code>NUMBER</code> </td><td class="Informal"><a name="139221"></a><p class="TB"> </td><td class="Informal"><a name="139223"></a><p class="TB">Position of the subpartition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139233"></a><p class="TB"><code>TABLESPACE_NAME</code> </td><td class="Informal"><a name="139235"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139237"></a><p class="TB"> </td><td class="Informal"><a name="139239"></a><p class="TB">Tablespace name of the subpartition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139249"></a><p class="TB"><code>HIGH_BOUND</code> </td><td class="Informal"><a name="139251"></a><p class="TB"><code>LONG</code> </td><td class="Informal"><a name="139253"></a><p class="TB"> </td><td class="Informal"><a name="139255"></a><p class="TB">Literal list values of the subpartition </td></tr></table><table class="TableNote" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><tr class="TableNote" align=LEFT valign=TOP><td class="TableNote"></td></tr></table></a> </ul><a name="139422"></a><!--TOC=h2-"139422"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_XML_SCHEMAS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_XML_SCHEMAS</code> describes the registered XML schemas accessible to the current user.</p><a name="139425"></a><!--TOC=h3-"139425"--><h4 class="H3"><font face="Arial, Helvetica, sans-serif" color="#330099"> Related Views</font></h4><!--/TOC=h3--><ul class="LB1"><li class="LB1" type="DISC"><a name="768"></a><code>DBA_XML_SCHEMAS</code> describes all registered XML schemas in the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_XML_SCHEMAS</code> describes the registered XML schemas owned by the current user. This view does not display the <code>OWNER</code> column.<p> <a name="773"><p><table class="InformalWide" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr"><thead><tr class="Informal"><th class="Informal" align="left" valign="bottom" scope="col"><a name="138496"></a><font face="Arial, Helvetica, sans-serif"><strong>Column</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081490"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081492"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="1081494"></a><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font> </th></tr><tbody><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138509"></a><p class="TB"><code>OWNER</code> </td><td class="Informal"><a name="138511"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138513"></a><p class="TB"> </td><td class="Informal"><a name="138515"></a><p class="TB">Owner of the XML schema </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138525"></a><p class="TB"><code>SCHEMA_URL</code> </td><td class="Informal"><a name="138527"></a><p class="TB"><code>VARCHAR2(700)</code> </td><td class="Informal"><a name="138529"></a><p class="TB"> </td><td class="Informal"><a name="138531"></a><p class="TB">Schema URL of the XML schema </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138541"></a><p class="TB"><code>LOCAL</code> </td><td class="Informal"><a name="138543"></a><p class="TB"><code>VARCHAR2(3)</code> </td><td class="Informal"><a name="138545"></a><p class="TB"> </td><td class="Informal"><a name="138547"></a><p class="TB">Indicates whether this XML schema is local (<code>YES</code>) or global (<code>NO</code>) </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138557"></a><p class="TB"><code>SCHEMA</code> </td><td class="Informal"><a name="138559"></a><p class="TB"><code>XMLTYPE</code> </td><td class="Informal"><a name="138561"></a><p class="TB"> </td>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -