Sequences

• • Reply

  17 years ago

  by robinspa

  robinspa

  , United States

  Joined 17 years ago

  How do I get a sequence to work when loading data via sql loader?
  

  
  My current ctl file looks like this:
  

  
  LOAD DATA
  INFILE 'S:\Sop\Dev\EcsData.csv'
  BADFILE 'S:\Sop\DevEcsData.bad'
  DISCARDFILE 'S:\Sop\Dev\Ecs_Data.dsc'
  

  
  APPEND
  INTO TABLE TEST
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
  TRAILING NULLCOLS
  (SEQID,
  DATESENT,
  TIMESENT,
  BUYERNAME)
  

  
  Seq_id is the field I want to use the sequence.
  

  
  Thanks.

  Report abuse
• • Reply

  17 years ago

  by Sacko

  James Saxton

  Nottingham, England, United Kingdom

  Joined 18 years ago

  A sequence is supplied by Oracle, it isn't a changeable value. You cant just specify what you want the sequence to be. you need to set up the sequence then grab nextval from dual. If you dont understand this then I suggest you read a book before messing with them, because they are quite difficult things to maintain.
  

  
  

  Report abuse