Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Table Partition error

Re: Table Partition error

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 22 Aug 2000 12:19:26 -0400
Message-Id: <10597.115245@fatcity.com>


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



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com=20=

--=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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US