Hi, can we add a new datafile to system tablespace when the database is up and running.
Why you want to do that?
A performance engineering forum
I forgot to answer.
Yes u can.
hi, the system tablespace datafile shows as 90% full. So i want to add a new datafile.
go for it