Now I want to import a TXT to oracle, approximately 20 million records, set the rows=5000, in the process of execution to lookup table, I don't see any data, will have to wait for all performed just have data, under the great god, please give directions

CodePudding user response:

Theoretically as long as the first load in 5000, you can find the 5000 records in the database, if not, may be your table has clob fields or other flow fields, specific to the log, actual analysis table structure, the original poster is little known information given

CodePudding user response:

Write midway can query, you take a look at your SQLLDR import logs,

CodePudding user response:

refer to the second floor baidu_36457652 response:

write midway can query, you see you SQLLDR import logs,

Insert now unable to query on the way to the data, basically see which piece of content in the log?

CodePudding user response:

reference zzlzt9 reply: 3/f

Quote: refer to the second floor baidu_36457652 response:

Write midway can query, you take a look at your SQLLDR import logs,

Insert now unable to query on the way to the data, basically see which piece of content in the log?

You specify log in SQLLLDR import and bad to see the two files