You are absolutely correct. * means all instances instance_name.parameter means just the named instance. On 9/27/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> wrote: > > CREATE PFILE FROM SPFILE produces this format. I think the * is meaningful > in RAC systems where instances might share a pfile, and the * means the > value is valid for all instances. Correct me if I'm wrong, anyone! > > On 9/27/05, Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS@xxxxxx> > wrote: > > > > > > Anybody ever seen a init.ora file in an init.ora file that looks like > > > > *.db_block_size=8192 > > *.db_cache_size=256M > > > > etc? > > > > I've never seen an asterisk and period at the beginning of a init.oraline > > before. > > > > I know this is not a spfile, because 'alter system .... scope=spfile' > > command get ORA-32001 errors. > > > > What is the significance of the asterisk and period? > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > -- > Paul Baumgartel > paul.baumgartel@xxxxxxxxxxxx > > -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com