Can objects of the same Schema reside in different tablespaces.?

Yes.

  • Interview Candidate
  • 6
  • 4135

Showing Answers 1 - 6 of 6 Answers

matabrez

  • Jan 9th, 2011
 

Yes objects of the same schema can reside in different tablepaces. Becuase when we create any schema (user) we can assign many tablespaces to one shcema so objects (eg. tables) will create in different tablespaces.

  Was this answer useful?  Yes

mayur

  • Dec 24th, 2015
 

No, at a time only one tablespace as default can be allocate to any user. If we want to store objects of one user to multiple tablespace then assign that tablespaces as a default tablespace for user at a time

  Was this answer useful?  Yes

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