Re: ORA-24810 during IMP

On Feb 4, 8:50 am, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> On Feb 4, 3:40 pm, gazzag <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 4 Feb, 14:02, 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
>
> > I agree with David Fitzjarrell.  Are you sure that you transferred the
> > dump file in its entirety?
>
> that was my first guess, and i've tryed to re-download but with same
> result. Then i've thought about a blob problem,
> maybe however that file has get currupted before. So i've asked to
> make me have another copy of
> the file.
>
> Thanks,
>   Cristian Cudizio
>
> http://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com- Hide quoted text -
>
> - Show quoted text -

If you're experiencing the same result downloading the file to the same location it may well be that you've consumed the available space before the file transferred completely. Have you tried using a different location for the file transfer?

David Fitzjarrell Received on Mon Feb 04 2008 - 08:55:46 CST