System TableSpace and Default TableSpace

Explain what are system tablespace and default tablespace? How do they differ from one another?

Questions by talk to senthil

Showing Answers 1 - 2 of 2 Answers

Punithavel

  • Mar 3rd, 2009
 

System Tablespace is the default tablespace for Oracle Database where it will store all the database dictionaries and DB related Tables

Whereas Default tablespace is the tablespace created for each user.

  Was this answer useful?  Yes

taraldesai

  • Mar 4th, 2009
 

System for oracle oracle metadata and default for when you create any user without providing any default tablespace clause will use this tablespace for objects

  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