ORA-24810 during IMP

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Mon, 4 Feb 2008 06:02:14 -0800 (PST)
Message-ID: <2d123cd4-ed64-4e9c-be14-a2c2e0356c08@s19g2000prg.googlegroups.com>

Hello,
i'm trying to import an export file created with 9i (i don't know the exact version) into a 9.2.0.8 database . The file is about 660 MB and contains an export of a table with a blob column. I get the errror ORA-24810:

C:\maps>c:\oracle\product\9.2\bin\imp system/manager file=DUMP.dmp fromuser=XXX touser=YYYY tables=tablename ignore=yes

Import: Release 9.2.0.8.0 - Production on Mon Feb 4 14:26:04 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Release 9.2.0.8.0 - Production JServer Release 9.2.0.8.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by XXX, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing XXX's objects into YYYY
. . importing table "TABLENAME"

IMP-00009: abnormal end of export file
IMP-00058: ORACLE error 24810 encountered
ORA-24810: attempting to write more data than indicated
IMP-00028: partial import of previous table rolled back: 160 rows

rolled back
Import terminated successfully with warnings.

I've tried to use buffer parameter of imp but without effects. What is the problem and how can i solve it?

Thanks,

 Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Mon Feb 04 2008 - 08:02:14 CST