Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Newbie: SQL*Loader, Direct Path, and Sequences.

Re: Newbie: SQL*Loader, Direct Path, and Sequences.

From: Robert Schöller <schoeller_at_inat.at>
Date: Thu, 15 Feb 2001 13:26:07 +0100
Message-ID: <9lbn8tgdsvqsn7k7n8dtnb64mc7jg44dfu@4ax.com>

On 14 Feb 2001 12:46:53 -0800, jeffb_at_halcyon.com (Jeffrey Mark Braun) wrote:

> NAMEID "NAMEID_SEQ.NEXTVAL"
Try
NAMEID SEQUENCE(MAX, 1) If it doesn't work (don't know the effects on the table-sequence), you will have to load the data to a temp table and import it with a little script (shouldn't be much work).

regard

Ing. Robert Schöller (schoeller_at_inat.at) Received on Thu Feb 15 2001 - 06:26:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US