Necessary to me to increase datafile SYSTEM

[Tatyana]

Hi all! Help me please.
It is necessary to me to increase a size of datafile SYSTEM.
I changed a size of another datafiles. Whether there are any differences
in this case? Should i do it when DB is open or only mounted?
Thank you in advance.

[rcaballe]

Don't worry.
You can resize the datafile for SYSTEM or create another datafile to increase size.

[aracnid]

absolutly db opened, alter tablespace system add datafile '****' size ****

[pwoneill]

Do you know the reason the tablespace has to be resized? Are you sure nobody has system as their temp tablespace or default tablespace?

[Halo]

Either resize the dbf or set AUTOEXTEND ON for the system dbf.

[Tatyana]

I know the reason the tablespace has to be resized .
The former dba created some users which had system both default
and temp. I changed their default and temp tablespaces but they
have some tables there which grows and grows...
I can't add datafile as number of datafiles=db_files in init.ora.
I'll do as you wrote.
Thank you.

[drishti]

hello,
I have a question,if by resizing any tbsp,fragmentation occur?I always prefered to add datafiles rather than resizing as I thought it would fragment the tbsp more.am I right?

[drishti]

hello,
I have a question,if by resizing any tbsp,fragmentation occur?I always prefered to add datafiles rather than resizing as I thought it would fragment the tbsp more.am I right?

also tatyana can't U alter those fast increasing tables default and temp tbsp to other tbsp.except datadictionary nothing is required to stay in system tbsp,especially user tables should not.

[TerryD]

Yes, if you resize a datafile then it's possible that it could fragment the file on the disk.

[Tatyana]

I resized system .
Thanks to all.
drishti, now nobody have system as default or temp but
i can't move existing tables to another tbs.