Re: ORA-24810 during IMP

On Feb 4, 8:02 am, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> 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.comhttp://cristiancudizio.wordpress.com

This appears to be the issue:

IMP-00009: abnormal end of export file

Are you certain you transferred the entire file to this system? It may be that you've filled a file system before the entire dmp file could be transferred.

David Fitzjarrell Received on Mon Feb 04 2008 - 08:05:17 CST