Re: create index when add primary key

Bob Yeh wrote:
>
> Hi,
>
> Oracle create a unique index when the primary key is created.
> Is there a way to tell Oracle to create this index in certain
> tablespace when creating primary key?
>
> Thanks. Bob

create table bart (

        field1                          number(7) not null,
        field2                          varchar2(20) not null,
        field3                          varchar2(10),
        field4                          varchar2(1),
                constraint bart_pk
                        primary key( field1 ),
                constraint bart_uk
                        unique( field3 )
) tablespace tbs_data
        initrans 5 maxtrans 255 pctfree 30 pctused 60
        storage( initial 10M next 5M
                minextents 1 maxextents 121 pctincrease 0)
        parallel(degree 2) nocache
  enable primary key using index
        tablespace tbs_idx
        initrans 2 maxtrans 255 pctfree 30
        storage( initial 6M next 3M
                minextents 1 maxextents 121 pctincrease 0)
  enable unique( field3 ) using index
        tablespace tbs_idx
        initrans 2 maxtrans 255 pctfree 30  
        storage( initial 6M next 3M
                minextents 1 maxextents 121 pctincrease 0);

brian.maclean_at_teldta.com Received on Wed Jun 26 1996 - 00:00:00 CEST