Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table Partition error
Sounds like the data in the import file is beyond the range of the table =
patrition. As an example: the table patrition is set for the dates less =
than=20
01-01-2000 and you are trying to import the date of 01-02-2000.
see METALINK 1060902.6
HTH
ROR
>>> arun_k_c_at_hotmail.com 08/22/00 11:24AM >>>
Hello All,
I am trying to import a 7.3.4 table data into a 8.0.6.1 partitioned table =
I=20
have created range partition on a column which has DATE as datatype.
After inserting few million rows I am getting the following error.
ORA-14400: inserted partition key is beyond highest legal partition key
IMP-00018: partial import of previous table completed: 5742441 rows =
imported
IMP-00041: Warning: object created with compilation warnings
Can somebody please let me know what this means and how I can solve =
this=20
issue.
Thanks in advance
--=20
Author: ARUN K C
INET: arun_k_c_at_hotmail.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 22 2000 - 11:19:26 CDT