Hi,

I have a table in a data warehouse which has reached its limit for
autogenerated primary key - a signed 32 bit integer which can be a
decimal number from -2147483648 to 2147483647 (I use Informatica
PowerCenter, ETL tool, which creates it like that).

However, many rows are deleted from this table and because of that some
values of primary key are currently not used, so it looks like:
1,2,5,10, 24, 15, ..... and so on.

I have a question how Oracle sequence should look like when I would
like to generate primary keys in cycle, checking if the next value of
the PK is already used in the table (no insert/update) or not (insert).

I would be very grateful for answer.

Iza