In other words sequences are not tied by Oracle to a specific table.
Sequences are independent objects. However, you can often tie a
sequence to a table by looking at its name, but the surest way is to
check the insert statements and before insert trigger(s), if any, on
the table in question. One sequences can be used to populate several
different tables. having low insert rate tables share a sequence can
greatly reduce the need to define sequences on a system.
HTH -- Mark D Powell --
Received on Wed Mar 01 2006 - 13:15:20 CST
