Re: ORA-24810 during IMP

On Mon, 4 Feb 2008 06:50:22 -0800 (PST), Cristian Cudizio <cristian.cudizio_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.com
>http://cristiancudizio.wordpress.com

An added thought - if you transfer the file using ftp, make certain that you specify binary mode. Received on Mon Feb 04 2008 - 10:57:11 CST