Questions On Updating Maxvalue Of Sequence WSH.WSH_EXCEPTIONS_S To 9999999999. (Doc ID 2648610.1)

Last updated on NOVEMBER 04, 2022

Applies to:

Oracle Shipping Execution - Version 12.2.8 and later
Information in this document applies to any platform.

Goal

Would like to update the maxvalue of sequence WSH.WSH_EXCEPTIONS_S to 9999999999.
Currently it is having a value of 2147483647.

Questions:

1) Please confirm whether there is any negative impact in doing this?

2) We will update the max value using the following alter sequence statement:

Please advise if there is any other recommended way.

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Questions On Updating Maxvalue Of Sequence WSH.WSH_EXCEPTIONS_S To 9999999999. (Doc ID 2648610.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!