Re: physical standby and temp datafiles

From: fmhabash <fmhabash@xxxxxxxxx>
To: stellr@xxxxxxxxxx
Date: Wed, 15 Jun 2011 13:00:10 -0400


- every file in v$tempfile must physically exist on disk
- If they are not, add them ...
ALTER TABLESPACE TEMP ADD TEMPFILE '/u03/ora_data/fred/fred/temp01.dbf'

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: physical standby and temp datafiles
  - From: Jorgensen, Finn
- Re: physical standby and temp datafiles
  - From: Ray Stell

References:
- physical standby and temp datafiles
  - From: Ray Stell

Other related posts:

» physical standby and temp datafiles- Ray Stell
» Re: physical standby and temp datafiles - fmhabash
» RE: physical standby and temp datafiles- Jorgensen, Finn
» Re: physical standby and temp datafiles- Ray Stell
» RE: physical standby and temp datafiles- Lange, Kevin G
» Re: physical standby and temp datafiles- Ray Stell
» RE: physical standby and temp datafiles- Lange, Kevin G
» Re: physical standby and temp datafiles- Kevin Lidh
» Re: physical standby and temp datafiles- Ray Stell
» Re: physical standby and temp datafiles- 'stellr@xxxxxxxxxx'