Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> CLUSTER syntax

CLUSTER syntax

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/01/20
Message-ID: <32E3E6F2.794B@garland.dnr.state.sc.us>#1/1

I am trying to figure out how to make the two tables below share the columns 'ucan_station_id' and 'station_sequence'.

I am able to create to create the following cluster with no errors. However, any operations on the tables are extremely slow.

What am I doing wrong?    

create cluster UCAN_NWS (jack number(10),jill number(2));

CREATE TABLE climate.ucan_stations (

  ucan_station_id        NUMBER(10,0) CONSTRAINT nn_ucan NOT NULL,
  station_sequence       NUMBER(2,0) CONSTRAINT nn_sequence NOT NULL,
  station_name           VARCHAR2(20))

 cluster UCAN_NWS (ucan_station_id,station_sequence);

CREATE TABLE climate.nws_stations (

  ucan_station_id        NUMBER(10,0) CONSTRAINT nn_nws not null,
  station_sequence       NUMBER(2,0) CONSTRAINT nn_nwssequence NOT NULL,
  nws_station_id     varchar2(16))
        cluster UCAN_NWS (ucan_station_id,station_sequence);


create index ucancluster on cluster UCAN_NWS; Received on Mon Jan 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US