Re: System Tablespace

Having the system tablespace as the default for each user is not advisable since if a user created a table and doesn't specify a tablespace for the new object , then the default location will be the system tablespace . If these non system objects grows affecting the other objects on the system tablespace , this may cause your database to crash ....

The worst thing is to actually have users have the SYSTEM tablespace as their temporary tablespace , since this will cause fragmentation on the last place where you wanted it .

I hope this helps !

S Metro wrote:
>
> An application was just installed on our database that requires all users to
> have the SYSTEM tablespace as their default and temporary tablespaces.
> Apparently, their application cannot point users to other tablespaces.
>
> I've heard this might be bad, but wanted to know why.
>
> Any input would be greatly appreciated.
>
> Thanks,
>
> Scott
>
> (take out nospam if replying via email)

-- 
================================================================
============================
| Joseph Sumalbag                                                                           
|
| Oracle DBA                                                                                
|
|                                                                                           
|
| The opinions expressed above are my own and doesn't 
 necessarily                           |
|reflect the opinion of any of my client company or my employer.                            
|
================================================================
============================