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_at_gmail.com> wrote:
>
> On 30/08/05, Jared Still <jkstill_at_gmail.com> wrote:
> > comments inline
> >
> >
> > On 8/29/05, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> 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

--
http://www.freelists.org/webpage/oracle-l