BHowie

 Profile Answers by BHowie Questions by BHowie

• Feb 17th, 2006

 

Normally a SYSTEM tablespace datafile.

Culver_lake

 Profile Answers by Culver_lake 

• Mar 23rd, 2006

 

It depends on the product you are using. For instance, DB2 doesn't require that a user be defined (to DB2).

In a relational system it is only required that a relational catalog/data dictionary exists.  What it looks like and how it's designed is up to the designers.

And please, in a relational system, data values are stored in TABLES, not datafiles, just tables.

cmanne

 Profile Answers by cmanne 

• Mar 25th, 2007

 

It depends how the user created, While creating the user if a specific tablespaces is mentioned as the default tablespace, then the user will be created in that tablespace's datafile. If no default tablespace is mentioned while creating the user, then the users default tablespace will be "system" and all the object pertaining to that user will be created in the SYSTEM tablespace which will result in defragmentation with the lapse of time due to various DDL, DML, DCL and DTL statements. It always a good practice to assign a default tablespace for a user other than the  SYSTEM tablespace.

Sundar

• Oct 25th, 2007

 

In MS SQL Server it gets stored in master db.

gbansal4

 Profile Answers by gbansal4 Questions by gbansal4

• Dec 17th, 2007

 

When the user is created without mentioning default tablespace, then it will be created in SYSTEM tablespace.  If Temporary tablespace is also not mentioned then it will automatically take the default temporary tablespace mentioned by the DBA.