Re: primary key index on separate tablespace not possible?

Thanks. That worked fine. I am surprised that "alter table ..." syntax does not support this.

Regards

Richard

Kari Pannila wrote:
>
 

> Hi
>
 

> Create first the index and then the constraint:
>
 

> CREATE UNIQUE INDEX PK TABLE 1 ON TABLE 1
> ( ASNO ASC );
>
 

> ALTER TABLE TABLE 1
> ADD ( CONSTRAINT PK TABLE 1 PRIMARY KEY (ASNO) ) ;
>
 

> Regards Kari
>
 

> (Mr.) Kari Pannila
> Oracle DBA (OCP)
> --
>
 

> PS. Delete X from my mail address , it (X) is only for SPAMMERS.
> Poista X mail-osoitteen edest , se on SPAMmereita varten.
>
 

>
 

> Richard Chen wrote:
>
 

> > We generally have tables and indexes on separate tablespaces.
> > However, I find that the following does not work:
> >
> > alter table t name add constraint t name pk primary key (column name)
 

> > tablespace ts name;
> >
> > Without using "tablespace ts name" the above works except that
> > the index is created on the same tablespace as for the table itself.
> >
> > Can anyone confirm that this is true or my syntax is wrong.
> >
> > Thanks
> >
> > Richard
>
 

>
 

> Received on Wed Jun 07 2000 - 00:00:00 CDT