ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

Situation:

We created an interval partition table structure only, then try to import the data from exported dump file. It causes ORA-14300 error. The same error occures when insert records from another online backup table:

SQL> insert into tbl_test select * from tbl_test_old;
insert into tbl_test select * from tbl_test_old;
*
ERROR at line 1:
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

 Cause:

There are NULL values in partition key column.

 

Solutions:

Update NULL values of  partition key column to right values, or remove those invalid records from source data.

Please note there are possible 1048575 partitions or subpartitions for the partition key:

$ oerr ora 14300
14300, 00000, “partitioning key maps to a partition outside maximum permitted number of partitions”
// *Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575
// *Action Ensure that the partitioning key falls within 1048575 partitions or subpartitions.

Advertisements
This entry was posted in Oracle DBA Practice, Partitioning and tagged , . Bookmark the permalink.

2 Responses to ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions

  1. siva says:

    thanx

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s