DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL*Loader generating Data

  1. 03-03-2004, 09:19 AM #1
    citldba
    citldba is offline Junior Member
    Join Date
    Feb 2004
    Location
    UK
    Posts
    56

    SQL*Loader generating Data

    I am trying to use SQL*Loader to generate data. In the Oracle 9I Utilities manual it says 'SQL*Loader inserts as many records as are specified by the LOAD statement'....but how do I specify how many records to create. I can't seem to find the parameter to use for this and there are no examples ?
    Reply With Quote Reply With Quote
  2. 03-03-2004, 10:27 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    In command line, when you invoke sqlldr, specify the parameter LOAD=n, where n is the number of records you want to load. For example
    Code:
    sqlldr scott/tiger my_ctl.ctl file=my_file.txt LOAD=100 ....
    will load just the first 100 records from your file myfile.txt.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
  3. 03-03-2004, 10:45 AM #3
    citldba
    citldba is offline Junior Member
    Join Date
    Feb 2004
    Location
    UK
    Posts
    56
    Great that works - thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width