Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create cluster ... nologging
Having just read Jonathan's post (which made absolute perfect sense) I was
really confused so (now the Footy Show has finished) I thought I better look
at it again.
Now please note the error I made was of course *totally intentional* and was designed to make the casual observer take note (you believe me now don't you :).
See if you can spot it (it's not that hard :(
And yes, you can't have nologging set for any clusters for the reasons already explained by Jonathan.
Live and learn.
Richard
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:C4dX8.32952$Hj3.98771_at_newsfeeds.bigpond.com...
> Hi Marcin,
>
> I had no idea there was such a restriction so I gave it a go.
>
> SQL> create cluster jobs_cluster (job_id varchar2(10))
> 2 size 512
> 3 STORAGE (initial 100K next 50K);
>
> Cluster created.
>
> SQL> create index jobs_indx on cluster jobs_cluster;
>
> Index created.
>
> SQL> create table clust_tab
> 2 cluster jobs_cluster (job_id)
> 3 as select * from jobs
> 4 nologging;
>
> Table created.
>
> This is creating an index cluster on my 9.0.1.1.1 DB so I guess I need
more
> info regarding your DB version, type of cluster, error message etc. to be
of
> help.
>
> Footy Show is on soon so you need to be quick :)
>
> Regards
>
> Richard
>
> "Marcin Buchwald" <Marcin.Buchwald_at_agora.pl> wrote in message
> news:3D2D57D7.DEC62D10_at_agora.pl...
> > Is it possible to create a cluster with nologging tables?
> > It seems it is not.
> >
> > What's the reason for this?
> >
> > Regards,
> >
> > Marcin
> >
>
>
Received on Thu Jul 11 2002 - 08:49:01 CDT