-
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
-
That is not true...
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 ... ...'
...
...
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|