Re: Critical Qs on materialized views

D'oh!

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@xxxxxxxxx> wrote:
> 
> On 30/08/05, Jared Still <jkstill@xxxxxxxxx> wrote:
> > comments inline
> >
> >
> > On 8/29/05, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> 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

Other related posts: