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

Home -> Community -> Mailing Lists -> Oracle-L -> export (7.3.2) and import (9.2.0.4)

export (7.3.2) and import (9.2.0.4)

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Thu, 16 Dec 2004 10:04:35 -0500
Message-ID: <BAY19-F75EC387158E6587C3EC57D3AE0@phx.gbl>


Hi,
I have been getting error during export(Oracle 7.3.2) and Import on (9.2.0.4).
When I used DIRECT=Y & recordlength export on 7.3.2 version works fine.But when I'm using same export file to import on Linux 9.2.0.4 it's showing following error
IMP-00020: long column too large for column buffer size (7) IMP-00018: partial import of previous table completed: 40500 rows imported
. . importing table "M_REPORT" 0 rows imported
. . importing table "APP_END_USER" 43683 rows imported
. . importing table "LI_APPLICATION"
IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 595 rows imported

When I selecting that table on oracle 7.3.2 version with SUBMISSION_date COLUMN its showing error after 40500 rows. "RROR:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []" No trace file generated.
ANALYZE works fine,dbv runs fine on those datafiles. I have tested all combination of DIRECT=Y ,COMPRESS=N & recordlength option but ONLY this options work fine during export but when I was importing noticed same error on same table.
the table select on source database on that table works fine without ONE columns SUBMISSION_DATE.Even select work fine uptol 40500 rows with submission_date.Noticed error after 40500 rows. RROR:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

please advice.
thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 16 2004 - 09:09:23 CST

Original text of this message

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