I'd like to add Primary Keys to the newly created tables and also make sure the PKs are created in the index tablespace instead of the default one.

Can I achieve this 2 requirements in 1 sql statement?

I tried

Alter table xyz add constraint PK_xyz PRIMARY KEY (col_a)tablespace idx_tbs;

But the tablespace part is causing error. How should I modify it or I have to do it in a 2-step way?

Thanks!