How to delete a datafile from temporary tablespace ?
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.
Last edited by avion1; 06-12-2006 at 05:35 AM.
Click Here to Expand Forum to Full Width