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.
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.