Re: loading test data using SQLLOADER

Solution 1.
Learn a scripting language like perl, AWK or even KSH. generate your data from one row template and vary the key.

Solution 2.
Use the same row 20,000 times for a file and drop all constraints. No key constraint problem. Using sqlldr or any loading, one key to performance is dropping constraints and indexes.

Solution 3.
If you can only point and click hire a consultant.

-- 


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

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.sofbot.com/


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