export (7.3.2) and import (9.2.0.4)
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Dec 2004 10:04:35 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
