Oracle problem-ORA-14400: The inserted partition keyword is not mapped to any partition

When an SQL data import is executed: ORA-14400: The inserted partition keyword is not mapped to any partition

The details are as follows:

SQL> @ "C: \ Documents ents and Settings \ Administrator \ Desktop \ 0109 new V8BS deployment \ to su hong separately
Table SQL \ TBL_SERVICE_INFO. SQL"
PL/SQL Developer import file

Insert into TBL_SERVICE_INFO (xxx );
*
Row 3 has an error:
ORA-14400: The inserted partition keyword is not mapped to any partition

Analysis:

1, Baidu query to see the error code ORA-14400 problem is likely to be a table partition problem.

2. Use the following SQL:

Select *
From user_tab_partitions t
Where t. table_name = 'tbl _ SERVICE_INFO ';

If the time table partition is found to have expired, data in the SQL file cannot be imported after the date is greater than 2011.5 months.

Solution:

1. Expand the partitions of the table.

Alter table TBL_SERVICE_INFO add PARTITION P_SERV_START_TIME_1105 values less than ('2017-06-01 00:00:00 ') tablespace PATITION;

Alter table TBL_SERVICE_INFO add PARTITION P_SERV_START_TIME_1106 values less than ('2017-07-01 00:00:00 ') tablespace PATITION;

Alter table TBL_SERVICE_INFO add PARTITION P_SERV_START_TIME_1107 values less than ('2017-08-01 00:00:00 ') tablespace PATITION;

Alter table TBL_SERVICE_INFO add PARTITION P_SERV_START_TIME_1108 values less than ('2017-09-01 00:00:00 ') tablespace PATITION;

Alter table TBL_SERVICE_INFO add PARTITION P_SERV_START_TIME_1109 values less than ('2017-10-01 00:00:00 ') tablespace PATITION;

2. Data is imported successfully when the SQL file is imported again!

This is only a poor analysis and solves this problem, and will be further analyzed in the future.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12