Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: create cluster ... nologging
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
![]() |
![]() |