Can we specify the tablespace for PK?

[elaine3839]

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...

[shadow21]

Hi,

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

Hope it helps

Cheers

Fabien

[elaine3839]

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

The question is still here. Anybody have an answer?

[Shestakov]

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.

[shadow21]

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

...
...

[elaine3839]

It works now :-)