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.ora line > 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