Skip to Main Content

SQL & PL/SQL

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!

Foreign key in specific tablespace

548849Jan 16 2007 — edited Jan 16 2007
Hello,

For creating primary key in a specific tablespace:

SQL>alter table TBLCOLUMNS add PRIMARY KEY (ID) using index tablespace my_tablespace;

Any Similar Command for Foreign key in specific tablespace.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2007
Added on Jan 16 2007
4 comments
4,993 views