on 04-28-2009 10:06 AM
an earlywatch report tells me some parameter should not be setted, but I use "alter system reset "dml_locks" scope=spfile sid='DPJ' command ,it does not work, I get an error.
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE
show parameter , I can see dml_locks is 4000.
Could you give me some advices.
Edited by: victor on Apr 28, 2009 11:10 AM
Correct syntax is:
ALTER SYSTEM RESET <parameter_name> scope = spfile sid = '*';
It's '*', not 'DPJ' .
And I would leave out the "" around "dml_locks" (Not sure about that.)
Source: Sap note 601157.
Edited by: Joe Bo. on Apr 28, 2009 11:17 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.