Loading a large amount of data

[mewa]

Hello,
I have to populate a database with a large number of rows (approximately 20 000 000 of records) to run some performance tests on it.
The first step will be to generate random data in some C program and the second to load (preferably via named pipe) the data to the database.
Do I have any chance to succed?
Could you please give me any suggestions on how to load the data (sqlloader, pl/sql procedure or something)?
I'd like to do it in a reasonable amount of time...

Thank you and best regards,
Ewa

 

[carp]

I think I would look at SQL*Loader with the direct path option.