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