Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Can Missing Tempfiles be Simply ADDED back after eXtract of FULL Database Backup ?

Can Missing Tempfiles be Simply ADDED back after eXtract of FULL Database Backup ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 25 Oct 2006 17:34:54 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302001F3E4EC@BLRKECMSG11.ad.infosys.com>

Folks

Can Missing Tempfiles be Simply ADDED with the SAME NAME after eXtract of FULL Database Cold Backup?

NOTE - Realised that a few Tempfiles were Missing after a FEW Days of Database being UP.

If YES (to ADD), does the "REUSE" Clause need to be necessarily specified as follows?

SQL> ALTER TABLESPACE <Temp Tblspc> ADD TEMPFILE '<Temp File Name>' REUSE; Thanks indeed

Received on Wed Oct 25 2006 - 07:04:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US