Tuesday, February 12, 2013

ORA-00097 Use of Oracle SQL feature not in SQL92 string Level

Error Code
ORA-00097
Description
Use of Oracle SQL feature not in SQL92 string Level.

Cause
Possible cause of this error is, usage of Oracle's SQL extensions.

Action
none

reference

Tuesday, February 5, 2013

ORA-00096 Invalid Value String for Parameter String, must be from among String

Error Code
ORA-00096

Description
Invalid value string for parameter string, must be from among string.

Cause
Possible cause of this error is, the value for the initialization parameter is invalid.

Action
To fix this error, choose a value as indicated by the message.

reference

ORA-00094 %s Requires an Integer Value

Error Code
ORA-00094

Description
%s requires an integer value.

Cause
Possible cause of this error is, the parameter value is not an integer.


Action
To fix this error, modify the parameter value to be an integer.

reference

ORA-00093 %s must be between String and String

Error Code
ORA-00093

Description
%s must be between string and string.

Cause
Possible cause of this error is, the parameter value is not in a valid range.

Action
To fix this error, modify the parameter value to be within the specified range.

reference

ORA-00092 LARGE_POOL_SIZE must be Greater than LARGE_POOL_MIN_ALLOC

Error Code
ORA-00092

Description
LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

Cause
Possible cause of this error is, the value of LARGE_POOL_SIZE is less than the value of LARGE_POOL_MIN_ALLOC.

Action
To fix this error, increase the value of LARGE_POOL_SIZE past the value of LARGE_POOL_MIN_ALLOC.

reference