How to delete a datafile from temporary tablespace ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to delete a datafile from temporary tablespace ?

  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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    no need to back up temp files, they arent needed in a backup. If you are using rman they wont be backed up.

    And you can't delete files from a tablespace, you will have to create a new temp tablespace and then delete the old one

  3. #3
    Join Date
    Sep 2004
    Posts
    54
    Thanks Davey23UK.

    We are using OMNI-BACK for backups. I think behind the secene it uses RMAN for the backups.

    am I correct to assume, in case of a failure, can we create the temp tablespace ourselves and database won't look for old temp data file as it does for nornal tablespaces.

    Thanks

    Quote Originally Posted by davey23uk
    no need to back up temp files, they arent needed in a backup. If you are using rman they wont be backed up.

    And you can't delete files from a tablespace, you will have to create a new temp tablespace and then delete the old one

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    if you are using rman, then it wont backup tempfiles (if they truly are tempfile) after a restore you would re-add the tempfiles

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    Did you create the temp tablespace as a TEMPORARY or PERMANENT tablespace? If it's created as a PERMANENT, then you may want to include this in your backup process.

    If you want to drop the newly added datafiles, then you'll have to create a new TEMP tablespace. If it was created as PERMANENT before, you should take this time to create a truly TEMPORARY TABLESPACE with tempfiles. As davey indicated, these won't be included in you backup.

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