Recently, I add 4gig datafiles to the temp tablespace. Due the this increase in size, the backups are taking very long.
My question is how safe it is to delete a datafile(s) from temporary space. I will grateful if you also give some help with the sintax to remove datafile from temp tablespace. We are using Oracle 8i.
Should I take full back beforehand ?
Thanks in advance.