Can objects of the same schema reside in different tablespaces

Showing Answers 1 - 2 of 2 Answers

sandeep

  • Jul 4th, 2005
 

Yes , it can .  
for example if you specify a different tablepace (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. 
Rgds 
Sandeep Kurian

  Was this answer useful?  Yes

Shrikant Pande

  • Aug 24th, 2005
 

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions