ORA-02097: parameter cannot be modified because specified
value is invalid



ORA-02097: parameter cannot be modified because specified value is invalid..

Answer / guest

Cause: Though the initialization parameter is modifiable,
the modified value is not acceptable to the parameter.

Action: Check the DBA guide for range of acceptable values
for this parameter.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08113: composite partition index may not be compressed

1 Answers  


TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


TNS-00225: Unable to bequeath connection to pump

1 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


NNO-00051: domain count number exceeds maximum of number, first number will be loaded

1 Answers  






ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

1 Answers  


TNS-00086: * reload - ask the Navigator to reload TNSNET.ORA

1 Answers  


ORA-30726: cannot specify referenced column list here

1 Answers  


ORA-31609: error loading file "string" from file system directory "string"

1 Answers  


NNL-00250: DEFAULT-FORWARDERS-ONLY mode is currently disabled

1 Answers  


PLS-00647: attribute by name "string" conflicts with method by same name

1 Answers  


ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


Categories