Need help to load 5 million + reords in database
Hello Everyone
I need help. I have a data file in csv format with over 5 million reords. there are 14 columns. I need to load the data into the table. but it is very teadiuos tak to load so many reords in one go.
Is there any command equivalent to PostGRESQl's copy command to load the data directly into database in very small time.
Please reply back as it is very important for me to load that much amount of data in small amount of time into the database.
Thanks and regards
Varun
Subject
Views
Written By
Posted
Need help to load 5 million + reords in database
5405
August 15, 2006 01:06PM
3511
August 15, 2006 01:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.