The control_file entry in the pfile created from spfile looks like ?\oradata\MYDB\control01.ctl On 10/17/05, NEW pop.tiscali.de <http://pop.tiscali.de> < adolph.tony@xxxxxxxxxx> wrote: > > Hi Deepak, > RE 1: as a previous post just noted, in RAC configurations, the * is > replaced by the instance number for the database. > RE 2: the ? is ORACLE_HOME, not BASE > RE 3: looks dodgy to me, what's the control_files entry in the new pfile > that was just created from the spfile? > Tony > > ----- Original Message ----- > *From:* DBA Deepak <oracle.tutorials@xxxxxxxxx> > *To:* oracle-l@xxxxxxxxxxxxx > *Sent:* Monday, October 17, 2005 12:12 PM > *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 > > > -- Regards, Deepak Oracle DBA