Editing pfile created from spfile 2006-04-05 - By David Sharples
the problem there is with the quotes, the whole thing needs to be wrapped up
in quotes
On 05/04/06, Michael Ray <topshot.rhit@(protected)> wrote:
>
> From my sql*plus session (this will likely wrap):
> SQL> ALTER SYSTEM SET
>
> LOG_FILE_NAME_CONVERT=('c:\oracle\product\10.2.0\oradata\cssprod','c:\oracle
\product\10.2.0\oradata\cssprod','e:\oracle\oradata\cssprod','e:\oracle\oradata
\cssprod')
> SCOPE=SPFILE;
> *
> ERROR at line 1:
> ORA-02095 (See ORA-02095.ora-code.com): specified initialization parameter cannot be modified
the problem there is with the quotes, the whole thing needs to be wrapped up in
quotes<br><br>
<div><span class="gmail_quote">On 05/04/06, <b class="gmail_sendername">Michael
Ray</b> <<a href="mailto:topshot.rhit@(protected)">topshot.rhit@(protected)</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">From my sql*plus session (this will likely
wrap):<br>SQL> ALTER SYSTEM SET<br>LOG_FILE_NAME_CONVERT=('c:\oracle\product
\10.2.0\oradata\cssprod','c:\oracle\product\10.2.0\oradata\cssprod','e:\oracle
\oradata\cssprod','e:\oracle\oradata\cssprod')
<br>SCOPE=SPFILE;<br>
*<br>ERROR at line 1:<br>ORA-02095 (See ORA-02095.ora-code.com):
specified initialization parameter cannot be modified</blockquote></div>
|
|
