I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
I'm assuming you're not using
Either set the current datafile to
Or, add a new datafile:
Obviously, alter the numbers and path as needed.
Adding a datafile impacts your backups. Take a full backup immediately after adding it - this is the only thing you really have to worry about.
4Gb is HUGE for a
Also, note that you cannot remove a datafile once it has been added to the