Re: Metalink disaster

From: MBPP <mpacheco_brazil_at_hotmail.com>
Date: Sat, 14 Nov 2009 03:48:04 -0800 (PST)
Message-ID: <b2764ac2-6b0c-42f1-b717-37a1ca72a2e1_at_j24g2000yqa.googlegroups.com>

On Nov 14, 3:31 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> Mladen Gogala wrote,on my timestamp of 14/11/2009 4:57 PM:
>
> > biblical proportions. I tried to log into Metalink because I want to open
> > a TAR, but I can't get in.
>
> The problem is you're trying to create a TAR.
> Apparently, to "get out in front" they now create only a SR...
>
> :)
> (1K apologies: couldn't resist)
>
>
>
> > SQL> create cluster print_clu(active char(1))
> >   2  tablespace imi
> >   3  single table hashkeys 3;
>
> > Cluster created.
>
> > Elapsed: 00:00:00.12
> > SQL> create table print_tmp
> >   2  cluster print_clu(active)
> >   3  as select * from print where rownum<0;
> > create table print_tmp
> > *
> > ERROR at line 1:
> > ORA-03001: unimplemented feature
>
> Does it work without CTAS?
> As in: create table followed by insert ... select...?

Just a guess now, can it be because of some reserved word from the table "print"? Received on Sat Nov 14 2009 - 05:48:04 CST