Home > database >  Can be difficult to great god? The two fields, one hundred million records of the CSV file, how to q
Can be difficult to great god? The two fields, one hundred million records of the CSV file, how to q

Time:09-24

I use PLSQL directly imported, 20 minutes to import the article 100 w, this is too slow, how to improve the efficiency of the import, please?

CodePudding user response:

It's almost half an hour

CodePudding user response:

More than half an hour

CodePudding user response:

Already more than half an hour, how can let him hurry,

CodePudding user response:

SQLLDR

CodePudding user response:

Try the SQLLDR should quickly several times,

CodePudding user response:

Well, recommend using SQLLDR, or try the external table

CodePudding user response:

Temporary use, it is recommended to use an external table;
A permanent use, it is recommended to use SQLLDR,