Re: create cluster ... nologging

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 11 Jul 2002 20:34:53 +1000
Message-ID: <C4dX8.32952$Hj3.98771@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 - 05:34:53 CDT