Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

separate tablespace for primary key index

632121Jul 3 2008 — edited Jul 4 2008
The table creation script contains script for Primary key generation.
my script is like this:
create table tabx (
col1 varchar2(3),
col2 varchar2(3) ) ;

alter table tabx
add constraint pk_col1 primary key (col1)
using index tablespace s_indx ;

But when I run my script file all the tables and indexes including primary key will be created in the same tablespace.
I want all the tables should be created in one tablespace and all indexes which is created automatically when we define primary key should be in another tablespace.

How to create separate scripts for tables and other for indexes.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2008
Added on Jul 3 2008
14 comments
2,224 views