Can objects of the same schema reside in different tablespaces

Yes, it can. For example if you specify a different tablespace (B) for indexes, the indexes of the tables that the user create would be residing in B, and the table would reside in the user's default tablespace A.

 

Yes: Schema objects can stored in different tablespace and a tablespace can contained one or more schema objects data.

1 comment: