Locked multiple sequencer hits.

This is a repost - since it doesn't seem to have made it to the list. Please excuse the duplication.

I'm inserting literally millions of rows. The Sequencer is set to increment by one - but since the rows are interdependent I need the id numbers BEFORE I insert. I want to make a call to pull off all 1,549,326 ids from a sequence at once. I also prefer the numbers to be sequential - and can not guarantee others will not try to access the sequencer. How do I do this.....

I could do it with by locking the sequence table, altering the increment_by on the sequence, increment once and alter back.

Problem, my process has privilege to lock the table, but not alter it. I'd rather not make 1,549,326 nextval calls and then do an equal number of inserts.

How do I accomplish this. I'm new to the Oracle and db worlds - so I might not have some of my terminology right - please forgive.

                   enough from this mooncalf - Steven

Steven Ross Weintraub                        | 
First Choice Software                        | O Lord, 
4412 Spicewood Springs Rd. Suite 701         |    let me talk gently, 
Austin, Texas 78759                          | for I might have to eat 
Phone: 512-418-2905 x100   Fax: 512-418-2983 |   my words tomorrow. 
external Email: stevenw_at_fchoice.com          | 


-----------------------------------------------------------------------


          The unexamined life is not worth living - Socrates
          The unlived life is not worth examining - Weintraub


-----------------------------------------------------------------------