📄 refrn.htm
字号:
<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="139458"></a><!--TOC=h2-"139458"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> ALL_XML_VIEWS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>ALL_XML_VIEWS</code> describes the XML views accessible to the current user.</p><a name="139461"></a><!--TOC=h3-"139461"--><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_VIEWS</code> describes all XML views the database.<p><li class="LB1" type="DISC"><a name="770"></a><code>USER_XML_VIEWS</code> describes the XML views 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="138952"></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="138965"></a><p class="TB"><code>OWNER</code> </td><td class="Informal"><a name="138967"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138969"></a><p class="TB"> </td><td class="Informal"><a name="138971"></a><p class="TB">Owner of the XML view </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138981"></a><p class="TB"><code>VIEW_NAME</code> </td><td class="Informal"><a name="138983"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="138985"></a><p class="TB"> </td><td class="Informal"><a name="138987"></a><p class="TB">Name of the XML view </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="138997"></a><p class="TB"><code>XMLSCHEMA</code> </td><td class="Informal"><a name="138999"></a><p class="TB"><code>VARCHAR2(700)</code> </td><td class="Informal"><a name="139001"></a><p class="TB"> </td><td class="Informal"><a name="139003"></a><p class="TB">Name of the XML Schema that is used for the view definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139013"></a><p class="TB"><code>SCHEMA_OWNER</code> </td><td class="Informal"><a name="139015"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="139017"></a><p class="TB"> </td><td class="Informal"><a name="139019"></a><p class="TB">Owner of the XML Schema that is used for the view definition </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="139029"></a><p class="TB"><code>ELEMENT_NAME</code> </td><td class="Informal"><a name="139031"></a><p class="TB"><code>VARCHAR2(256)</code> </td><td class="Informal"><a name="139033"></a><p class="TB"> </td><td class="Informal"><a name="139035"></a><p class="TB">Name of the XML Schema element that is used for the view </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="139467"></a><!--TOC=h2-"139467"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_CAPTURE</font></h3><!--/TOC=h2--><a name="139469"></a><p class="BP"><code>DBA_CAPTURE</code> displays information about all capture processes in the database.</p> <a name="139472"><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="603856"></a><font face="Arial, Helvetica, sans-serif"><strong><strong class="Bold">Column</strong></strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="603858"></a><font face="Arial, Helvetica, sans-serif"><strong>Datatype</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="603860"></a><font face="Arial, Helvetica, sans-serif"><strong>NULL</strong></font> </th><th class="Informal" align="left" valign="bottom" scope="col"><a name="603862"></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="603872"></a><p class="TB"><code>CAPTURE_NAME</code> </td><td class="Informal"><a name="603874"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="603876"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="603878"></a><p class="TB">Name of the capture process </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603888"></a><p class="TB"><code>QUEUE_NAME</code> </td><td class="Informal"><a name="603890"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="603892"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="603894"></a><p class="TB">Name of the queue used for holding captured changes </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603904"></a><p class="TB"><code>QUEUE_OWNER</code> </td><td class="Informal"><a name="603906"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="603908"></a><p class="TB"><code>NOT NULL</code> </td><td class="Informal"><a name="603910"></a><p class="TB">Owner of the queue used for holding captured changes </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603920"></a><p class="TB"><code>RULE_SET_NAME</code> </td><td class="Informal"><a name="603922"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="603924"></a><p class="TB"> </td><td class="Informal"><a name="603926"></a><p class="TB">Name of the rule set used by the capture process for filtering </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603936"></a><p class="TB"><code>RULE_SET_OWNER</code> </td><td class="Informal"><a name="603938"></a><p class="TB"><code>VARCHAR2(30)</code> </td><td class="Informal"><a name="603940"></a><p class="TB"> </td><td class="Informal"><a name="603942"></a><p class="TB">Owner of the rule set </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603952"></a><p class="TB"><code>START_SCN</code> </td><td class="Informal"><a name="603954"></a><p class="TB"><code>NUMBER</code> </td><td class="Informal"><a name="603956"></a><p class="TB"> </td><td class="Informal"><a name="603958"></a><p class="TB">System change number (SCN) from which capturing will be resumed </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603968"></a><p class="TB"><code>STATUS</code> </td><td class="Informal"><a name="603970"></a><p class="TB"><code>VARCHAR2(8)</code> </td><td class="Informal"><a name="603972"></a><p class="TB"> </td><td class="Informal"><a name="603974"></a><p class="TB">Status of the capture process (<code>DISABLED</code>, <code>ENABLED</code>, or <code>ABORTED</code>) </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603952"></a><p class="TB"><code>CAPTURED_SCN</code> </td><td class="Informal"><a name="603954"></a><p class="TB"><code>NUMBER</code> </td><td class="Informal"><a name="603956"></a><p class="TB"> </td><td class="Informal"><a name="603958"></a><p class="TB">System change number (SCN) of last captured message </td></tr><tr class="Informal" align="LEFT" valign="TOP"><td class="Informal"><a name="603952"></a><p class="TB"><code>APPLIED_SCN</code> </td><td class="Informal"><a name="603954"></a><p class="TB"><code>NUMBER</code> </td><td class="Informal"><a name="603956"></a><p class="TB"> </td><td class="Informal"><a name="603958"></a><p class="TB">System change number (SCN) of last applied message </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> <a name="139474"></a><!--TOC=h2-"139474"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_LOB_TEMPLATES</font></h3><!--/TOC=h2--><a name="139476"></a><p class="BP"><code>DBA_LOB_TEMPLATES</code> describes all LOB subpartition templates in the database.</p><a name="139478"></a><!--TOC=h2-"139478"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_SUBPARTITION_TEMPLATES</font></h3><!--/TOC=h2--><a name="139480"></a><p class="BP"><code>DBA_SUBPARTITION_TEMPLATES</code> describes all subpartition templates in the database.</p><a name="139482"></a><!--TOC=h2-"139482"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_XML_SCHEMAS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>DBA_XML_SCHEMAS</code> describes all registered XML schemas in the database. Its columns are the same as those in <code>ALL_XML_SCHEMAS</code>.</p><a name="139485"></a><!--TOC=h2-"139485"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_XML_TAB_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>DBA_XML_TAB_COLS</code> describes the columns of all XML tables in the database. Its columns are the same as those in <code>ALL_XML_TAB_COLS</code>.</p><a name="139488"></a><!--TOC=h2-"139488"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_XML_TABLES</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>DBA_XML_TABLES</code> describes all XML tables in the database. Its columns are the same as those in <code>ALL_XML_TABLES</code>.</p><a name="139491"></a><!--TOC=h2-"139491"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_XML_VIEW_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>DBA_XML_VIEW_COLS</code> describes the columns of all XML views in the database. Its columns are the same as those in <code>ALL_XML_VIEW_COLS</code>.</p><a name="139494"></a><!--TOC=h2-"139494"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> DBA_XML_VIEWS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>DBA_XML_VIEWS</code> describes all XML views in the database. Its columns are the same as those in <code>ALL_XML_VIEWS</code>.</p><a name="139497"></a><!--TOC=h2-"139497"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_LOB_TEMPLATES</font></h3><!--/TOC=h2--><a name="139499"></a><p class="BP"><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="139501"></a><!--TOC=h2-"139501"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_SUBPARTITION_TEMPLATES</font></h3><!--/TOC=h2--><a name="139503"></a><p class="BP"><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="139505"></a><!--TOC=h2-"139505"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_XML_SCHEMAS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>USER_XML_SCHEMAS</code> describes the registered XML schemas owned by the current user. Its columns (except for <code>OWNER</code>) are the same as those in <code>ALL_XML_SCHEMAS</code>.</p><a name="139508"></a><!--TOC=h2-"139508"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_XML_TAB_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>USER_XML_TAB_COLS</code> describes the columns of the XML tables owned by the current user. Its columns (except for <code>OWNER</code>) are the same as those in <code>ALL_XML_TAB_COLS</code>.</p><a name="139511"></a><!--TOC=h2-"139511"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_XML_TABLES</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>USER_XML_TABLES</code> describes the XML tables owned by the current user. Its columns (except for <code>OWNER</code>) are the same as those in <code>ALL_XML_TABLES</code>.</p><a name="139514"></a><!--TOC=h2-"139514"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_XML_VIEW_COLS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>USER_XML_VIEW_COLS</code> describes the columns of the XML views owned by the current user. Its columns (except for <code>OWNER</code>) are the same as those in <code>ALL_XML_VIEW_COLS</code>.</p><a name="139517"></a><!--TOC=h2-"139517"--><h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099"> USER_XML_VIEWS</font></h3><!--/TOC=h2--><a name="1002341"></a><p class="BP"><code>USER_XML_VIEWS</code> describes the XML views owned by the current user. Its columns (except for <code>OWNER</code>) are the same as those in <code>ALL_XML_VIEWS</code>.</p><!-- Start Footer --></div><div class="OUTD"><hr><table cellspacing="0" cellpadding="0" width="100%"><tr><td valign="BOTTOM" width="33%"><table cellspacing="0" cellpadding="0"><tr><td align="CENTER"><a href="migng.htm"><img src="larrow.gif" alt="Go to previous page" border="0" height="30" width="40"></a></td><td align="CENTER"><a href="sqlrf.htm"><img src="rarrow.gif" alt="Go to next page" border="0" height="30" width="40"></a></td> </tr></table></td><td align="CENTER" width="34%"><font size="-2">Copyright © 2002 Oracle Corporation.</font><br><font size="-2">All Rights Reserved.</font></td><td valign="BOTTOM" align="RIGHT" width="33%"> <table cellspacing="0" cellpadding="0" width="144"><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> </div></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -