Background of : the teacher, I am not professional development or database, just work recently need to use ORACLE database to do some analysis, can use a little PLSQL tools,

Problem of : the recent need to import about 200 million text format file (TXT), mainly involving the accounting data (such as account name, amount, date, etc.), the field structure is simpler (about 6 fields), I started using PLSQL import, 50000 data about took five minutes, if follow the linear time complexity, 200 million pieces of data about nine days nine night!
The time consumption for too long, I don't know is there a way to optimize? Please supervise your expert teacher guide, be obliged!

CodePudding user response:

SQLLDR, this is just for you now,

CodePudding user response:

Through SQLLDR data load

CodePudding user response:

reference 1st floor selling fruit net reply:

SQLLDR, this is just for you now,

Thank the moderator,

CodePudding user response:

refer to the second floor jyongj response:

by SQLLDR data load

Thank you to reassure ~

CodePudding user response:

Through SQLLDR data loading