Log in multi-byte character errors,
Record 1: rejected - table of passenger flow information _0420 column BUS_ID errors,
Multi-byte character errors,
Record 2: rejected - table passenger information _0420 column PASSENGER_SUM_ID errors,
Multi-byte character errors,
Record 3: rejected - table passenger information _0420 column PASSENGER_SUM_ID errors,
Multi-byte character errors,
Record 4: rejected - table of passenger flow information _0420 column OBU_ID errors,
Multi-byte character errors,
Record 5: rejected - table passenger information _0420 column PASSENGER_SUM_ID errors,
Multi-byte character errors,
Record 6: be rejected - table of passenger flow information _0420 column VERSION there is an error,
Multi-byte character errors,
Record 7: rejected - table of passenger flow information _0420 column VERSION there is an error,
Multi-byte character errors,
Record 8: rejected - table of passenger flow information _0420 column DATA_SERIAL errors,
Multi-byte character errors,
Record 9: rejected - table of passenger flow information _0420 column DATA_SERIAL errors,
Multi-byte character errors,
Record 10: rejected - table of passenger flow information _0420 column VERSION there is an error,
Multi-byte character errors,
Record 13: rejected - table of passenger flow information _0420 column ORDER_NUMBER errors,
Multi-byte character errors,
Record 15: rejected - table of passenger flow information _0420 column BUS_ID errors,
Multi-byte character errors,
Record 17: rejected - table of passenger flow information _0420 column REDIS_TIME errors,
Multi-byte character errors,
Record 18: rejected - table of passenger flow information _0420 column BUS_ID errors,
Multi-byte character errors,
Record 19: rejected - table of passenger flow information _0420 column ROUTE_SUB_ID errors,
Multi-byte character errors,
Record 20: rejected - table of passenger flow information _0420 column VERSION there is an error,
Multi-byte character errors,
Records of 21: rejected - table passenger information _0420 column PASSENGER_SUM_ID errors,
Multi-byte character errors,
Record 22: rejected - table of passenger flow information _0420 column PASSENGER_SUM_ID errors,
Multi-byte character errors,
Table _0420 traffic information:
Has been successfully loaded row 0,
Due to data error, 52 lines without load,
Since all the WHEN clause failure, zero line no load,
Because all of the fields are null values, zero line without load,


And all the data in the logging data type is a CHARACTER, and to import table structure has many types

CodePudding user response:

Our bosses do me a favor, was so sick of this several days, you want to import the dat file come from 10 g database, I want to import to 12 c, know table structure, the method of using SQLLDR appears the question

CodePudding user response:

The control of the import file set character format to try varchar2

CodePudding user response:

Is solved, please, also encountered this problem, the problem solved, solve, thank you very much!!!!!!

CodePudding user response:

Software written sqluldr2 tools suggest try civilians, billed as the world is with super fast Oracle text export tool, easily and efficiently for large data migration!


SQLULDR2

CodePudding user response:

Advice to see the common writing reference:
https://www.cnblogs.com/twyth/articles/1547138.html