DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to delete a datafile from temporary tablespace ?

Threaded View

  1. #1
    Join Date
    Sep 2004
    Posts
    54

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width