<HTML><HEAD>
 <title>Constraint: CKP_U1 on table CKP</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: CKP_U1 on table CKP</P></div></div>
<DIV id="nstext" valign="bottom">
<p class='page-sub-header'><a name="_Toc1129673071" > Properties</a></p>
<table  border=1 cellpadding=1 cellspacing=1 >
<tr>
  <td valign=top nowrap class='td_header_min'>Name:</td>
  <td>CKP_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="_Toc741459816" > 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>
CKP_SCN&nbsp;</td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
CKP_TYPE&nbsp;</td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
CKP_CF_SEQ&nbsp;</td>
</tr>
<tr>
<td valign="top" class="td_min">
<img src="./../../style/column.ico">&nbsp;</td>
<td valign=top>
CF_CREATE_TIME&nbsp;</td>
</tr>
    </table>
<span class="objects_number">Total: 5 column(s)</span>
<p class='page-sub-header'><a name="_Toc1129673071" > 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>"CKP"</span> <span class=keyword>ADD</span> <span class=keyword>CONSTRAINT</span> <span class=string>"CKP_U1"</span> <span class=keyword>UNIQUE</span> (<span class=string>"DBINC_KEY"</span>, <span class=string>"CKP_SCN"</span>, <span class=string>"CKP_TYPE"</span>, <span class=string>"CKP_CF_SEQ"</span>, <span class=string>"CF_CREATE_TIME"</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/2052929795.html">List of constraints</a><br>
<a class="see_also_href" href="./../../table/main/908880325.html">Table [CKP]</a><br>
<br>
<br>
</div>
</body>
</html>