Of course it works. I misunderstood that question. Reading too fast, too much going on.
I saw 'PRE' and thought he was still talking about PREbuilt table.
That has worked for as long as I can recall, sometime in Version 7, maybe from the beginning.
Jared
On 8/31/05, Phil Jones <phillipjones@(protected)> wrote: > > On 30/08/05, Jared Still <jkstill@(protected)> wrote: > > comments inline > > > > > > On 8/29/05, VIVEK_SHARMA <VIVEK_SHARMA@(protected)> wrote: > > > > > > > > > Jared, Folks > > > > > > Qs 1 Can the PK constraint be created on a PRE-Created (already > existing) > > Unique index in ver 8i too? > > > > Check the docs. I don't think this option existed in 8i. You won't know > > for sure until you check the docs > > and/or try it. > > Looks like it works ok: > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production > With the Partitioning option > JServer Release 8.1.7.4.0 - 64bit Production > > SQL> create table pktest ( i int,j int ); > > Table created. > > SQL> create unique index pktest_pk on pktest ( i, j ); > > Index created. > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
<br> D'oh!<br> <br> Of course it works. I misunderstood that question. Reading too <br> fast, too much going on.<br> <br> I saw 'PRE' and thought he was still talking about PREbuilt table.<br> <br> That has worked for as long as I can recall, sometime in Version 7, maybe<br> from the beginning.<br> <br> Jared<br> <br> <br><div><span class="gmail_quote">On 8/31/05, <b class="gmail_sendername">Phil Jones</b> <<a href="mailto:phillipjones@(protected)">phillipjones@(protected)</a >> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> On 30/08/05, Jared Still <<a href="mailto:jkstill@(protected)">jkstill@(protected) .com</a>> wrote:<br>> comments inline<br>><br>><br>> On 8/29/05, VIVEK_SHARMA <<a href="mailto:VIVEK_SHARMA@(protected)">VIVEK_SHARMA@(protected) .com </a>> wrote:<br>> ><br>> ><br>> > Jared, Folks<br>> > ;<br>> > Qs 1 Can the PK constraint be created on a PRE-Created (already existing)<br>> Unique index in ver 8i too?<br>><br>> Check the docs. I don't think this option existed in 8i. You won't know <br>> for sure until you check the docs<br>> and/or try it.<br ><br>Looks like it works ok:<br><br>Connected to:<br>Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production<br>With the Partitioning option<br> JServer Release 8.1.7.4.0 - 64bit Production<br><br>SQL> create table pktest ( i int,j int );<br><br>Table created.<br><br>SQL> create unique index pktest_pk on pktest ( i, j );<br><br>Index created.<br><br></blockquote> </div>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br><br>
