My Oracle Support Banner

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

Last updated on MARCH 16, 2020

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.