RE: Asterisks in init.ora parameters

This looks like an init.ora file that has been produced from an spfile (using strings or suchlike)
The * refers to sid as in an OPS setup

John

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: 27 September 2005 19:29
To: oracle-l_at_freelists.org
Subject: Asterisks in init.ora parameters

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?

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


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