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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PFILE from SPFILE

RE: PFILE from SPFILE

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 17 Oct 2005 13:26:30 +0200
Message-Id: <20051017112636.88CEF200E5B@turing.freelists.org>


Deepak,  

*. prefix means "for all instances"

? stands for the $ORACLE_HOME path prefix  

hope this helps,
kind regards,

Lex.



Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html> http://www.naturaljoin.nl/events/seminars.html
 

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DBA Deepak
Sent: Monday, October 17, 2005 13:13
To: oracle-l_at_freelists.org
Subject: PFILE from SPFILE

Hi All,  

When I created a pfile from spfile the pfile has lines like the following....  

*.background_dump_dest='?\admin\
 

I have a few doubts regarding that.  

1> Why *. is there before each line.  

2> Why the locations of the dumps as well as the control files have ?\ prefixed.  

3> Even when i use sho parameter control_file it shows the ?    

Please help me in understanding the above.

-- 
Regards,

Deepak
Oracle DBA 



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

Received on Mon Oct 17 2005 - 06:30:05 CDT

Original text of this message

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