exp:

SQL> select * from T_TEMP_LZY_QYDJ_1;

ORA-29913: an error occurred when calling out ODCIEXTTABLEFETCH ORA-30653: the
rejection limit has been reached
ORA-06512: in “SYS.ORACLE_LOADER”, line 14
ORA-06512: in line 1

Check the external table log T_TEMP_LZY_QYDJ_1_2696_1384.log, which indicates an error:

error processing column ZCLX in row 63 for datafile e: mplsbd.txt
ORA-01401: inserted value too large for column

It turns out that the column width of the table is insufficient!!

Read More:

• Solve MySQL table can not query, modify, delete and other operations and appear stuck
• [Mybatis] How to Solve the problem of Oracle query processing more than 1000 in conditions
• [Solved] Error Code: 2013. Lost connection to MySQL server during query
• MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
• [Solved] Error response from daemon: driver failed programming external connectivity on endpoint mysql
• postgresql-Database query problem-ERROR: column “t.domainid“ must appear in the GROUP BY clause or be used in an a
• [Solved] Pyodbc.ProgrammingError: No results. Previous SQL was not a query.
• MySQL | ERROR : Every derived table must have its own alias [Solved]
• [Solved] Error response from daemon: driver failed programming external connectivity on endpoint mysql
• SQL Server Deletes a table foreign key constraint Error [Solved]
• How to release Oracle PLSQL data lock table
• (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
• How to Fix MySQL error 1005: can’t create table (errno: 150)
• [SQL ERROR] SQL Error: could not execute statement & query did not return a unique result: 2； nested excepti
• ERROR 1075 (42000) Incorrect table definition; there can be only one auto column and it must be defi
• [Solved] flicksql cdc mysql to kafka Connect Error: org.apache.flink.table.api.ValidationException…
• How to Solve MYSQL ERROR: relation “table_name” does not exist
• [Solved] Error: read ECONNRESET at TCP.onStreamRead Cannot enqueue Query after fatal error
• C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
• [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata