Foreign Key Index Tablespace

[Thiko]

When doing an alter table statement to add a foreign key is it possible to specify which tablespace you want the index to go into?

ALTER TABLE mediaitemrep
ADD CONSTRAINT mediaitemrep_mediaitem_fk FOREIGN KEY (mediaitemid)
REFERENCES mediaitem(mediaitemid)
/ Many Thanks.

Thiko!

 

[sem]

You may create index before creating constraint

 

[MikeJones]

Can you not do..

using tablespace <tablespace_name>

at the end of the statement?