Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPORTIN ERROR

617891Mar 13 2008 — edited Mar 13 2008

Hi,
When i am importing partion tables i am getting this error. Actually i am importing 4 tables 2 or flat tables and 2 are partition tables .

I am getting the below error. This mean i need to create a partiton table on this or any other solution.

Please give me the solution

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. . importing table "CLICK_THRU_TBL"
IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key is beyond highest legal partition key
IMP-00018: partial import of previous table completed: 29129102 rows imported
. . importing table "GIFSPIT_TBL"
IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key is beyond highest legal partition key
IMP-00018: partial import of previous table completed: 80293773 rows imported

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. . importing table "CLICK_THRU_TBL"
IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key is beyond highest legal partition key
IMP-00018: partial import of previous table completed: 29129102 rows imported
. . importing table "GIFSPIT_TBL"
IMP-00058: ORACLE error 14400 encountered
ORA-14400: inserted partition key is beyond highest legal partition key
IMP-00018: partial import of previous table completed: 80293773 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P6" 87885 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P7" 20716 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P8" 33354 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P9" 11319 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P10" 24884 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P11" 35090 rows imported
. . importing partition "OPTOUT_TBL":"CLIPROD5_OPTOUT_TBL_P12" 36457 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P6" 288404 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P7" 94654 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P8" 131259 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P9" 106539 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P10" 76041 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P11" 90070 rows imported
. . importing partition "REPLY_TRCK_TBL":"CLIPROD5_REPLY_TRCK_TBL_P12" 125898 rows imported
IMP-00017: following statement failed with ORACLE error 2149:
"ANALYZE TABLE "OPTOUT_TBL" PARTITION ("CLIPROD5_OPTOUT_TBL_P6") ESTIMATE "
"STATISTICS "
IMP-00003: ORACLE error 2149 encountered
ORA-02149: Specified partition does not exist
IMP-00017: following statement failed with ORACLE error 2149:
"ANALYZE TABLE "REPLY_TRCK_TBL" PARTITION ("CLIPROD5_REPLY_TRCK_TBL_P6") E"
"STIMATE STATISTICS "
IMP-00003: ORACLE error 2149 encountered
ORA-02149: Specified partition does not exist
Import terminated successfully with warnings.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2008

Added on Mar 13 2008

#general-database-discussions

1 comment

1,586 views