Hello,

I have been contemplating moving tables to different tablespaces, and obviously will be sorting out the matching indexes to their relevant tablespaces.

I have been informed via the Oracle forum that the primary key goes with the table when I move. Can anyone shed light on why the primary key is treated differently? Should we have them stored in a different fashion to our regular indexes? Basically what is the difference between how Oracle keeps our indexes compared to primary keys?

Thanks in advance,
Nirasha