How To Increase the Maximum Value Of QP_QUALIFIERS_S (Doc ID 1341819.1)

Last updated on APRIL 08, 2025

Applies to:

Goal

QP_QUALIFIERS_S max value is 2,147,483,647 and current(2011/06/07) value is
1,019,548,076.
The sequence is growing so rapidly that we can calculate the expected sequence
value in one years.
The QP_QUALIFIERS_S will reach to max size in one year.

To prevent from occurring any issues due to this max sequence value we need
to increase max value or need to get the another solution.


Run the following sql to get the problematic sequence information.

Solution

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