<HTML><HEAD>
 <title>Constraint: OFFR_U1 on table OFFR</title>
<LINK REL="stylesheet" TYPE="text/css" HREF="./../../style/style.css">
<SCRIPT SRC="./../../style/vs70.js"></SCRIPT>
<SCRIPT SRC="./../../style/vs70link.js"></SCRIPT>
</HEAD><BODY id='bodyID'>
<div id="nsbanner">
<div id="bannerrow1">
<P CLASS="page-header">&nbsp;
<img src="./../../style/constraint.ico">Constraint: OFFR_U1 on table OFFR</P></div></div>
<DIV id="nstext" valign="bottom">
<p class='page-sub-header'><a name="_Toc1844149430" > Properties</a></p>
<table  border=1 cellpadding=1 cellspacing=1 >
<tr>
  <td valign=top nowrap class='td_header_min'>Name:</td>
  <td>OFFR_U1&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Type:</td>
  <td>Unique Key&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Status:</td>
  <td>Enabled&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Delete rule:</td>
  <td>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Defferable:</td>
  <td>Not Deferrable&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>Deffered:</td>
  <td>Immediate&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>R Owner:</td>
  <td>&nbsp;</td>
</tr>
<tr>
  <td valign=top nowrap class='td_header_min'>R Constraint:</td>
  <td>&nbsp;</td>
</tr>
 </table>
<p class='page-sub-header'><a name="_Toc1237260985" > Columns</a></p>
<table border=1 class='table_list' >
<tr class='tr_header' width='1'>
<td valign=top nowrap><b></b></td>
<td valign=top nowrap><b>Name</b></td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
DBINC_KEY&nbsp;</td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
OFFR_RECID&nbsp;</td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
OFFR_STAMP&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 3 column(s)</span>
<p class='page-sub-header'><a name="_Toc1844149430" > DDL</a></p>
<p class="pre">
<br>&nbsp;&nbsp;<span class=keyword>ALTER</span> <span class=keyword>TABLE</span> <span class=string>"RMAN"</span>.<span class=string>"OFFR"</span> <span class=keyword>ADD</span> <span class=keyword>CONSTRAINT</span> <span class=string>"OFFR_U1"</span> <span class=keyword>UNIQUE</span> (<span class=string>"DBINC_KEY"</span>, <span class=string>"OFFR_RECID"</span>, <span class=string>"OFFR_STAMP"</span>)<br>&nbsp;&nbsp;<span class=keyword>USING</span> <span class=keyword>INDEX</span> PCTFREE 10 INITRANS 2 MAXTRANS 255 <br>&nbsp;&nbsp;STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645<br>&nbsp;&nbsp;PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL <span class=keyword>DEFAULT</span>)<br>&nbsp;&nbsp;TABLESPACE <span class=string>"TOOLS"</span>&nbsp;&nbsp;ENABLE<br> 
</p>
<p class="page-sub-header">See Also</p>
<a class="see_also_href" href="./../../table_constraints_list/main/810879536.html">List of constraints</a><br>
<a class="see_also_href" href="./../../table/main/2082757352.html">Table [OFFR]</a><br>
<br>
<br>
</div>
</body>
</html>