Can we specify the tablespace for PK?

Since an unique index will be created for PK automatically, can we specify which tablespace that index/PK should go to?

I tried the syntax

Alter table xx add constraint pk_xx primary key (col_name) tablespace index_tblsp;

And got error over there.

If I don't specify the tablespace when I create PK, then it will go to user's default tablespace. If I create PK inside table creation, then it will go to table's tablespace. Neither of them is what I wanted.

Any idea?

TIA...

Hi,

You must add the 'STORAGE' keyword before each storage parameter...

Hope it helps

Cheers

Fabien

At least when you create tables and indexes, you can specify tablespace directly.

The question is still here. Anybody have an answer?

Yes u can:
Alter table xx add constraint pk_xx primary key (col_name)
using index
tablespace index_tblsp
pctfree 15
storage(...); --any needed storage parameters.

Shame on me...
Again too fast in answering.
Of course, you must set the 'using index ... ...'

...
...

It works now :-)