Home » RDBMS Server » Server Utilities » problem Import (Oracle Database 9i)
problem Import [message #613516] Wed, 07 May 2014 12:06 Go to next message
alijeyan
Messages: 173
Registered: January 2007
Location: IRAN
Senior Member
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:

Quote:

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: 1046 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,
Re: problem Import [message #613517 is a reply to message #613516] Wed, 07 May 2014 12:10 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
Was the line below actually produced by the imp command?
>Export file created by EXPORT:V09.02.00 via conventional path
"V09.02.00" looks strange to me.
Re: problem Import [message #613520 is a reply to message #613517] Wed, 07 May 2014 12:14 Go to previous messageGo to next message
alijeyan
Messages: 173
Registered: January 2007
Location: IRAN
Senior Member
Yes .
please : What is the problem and how can i solve it?
Re: problem Import [message #613522 is a reply to message #613516] Wed, 07 May 2014 12:16 Go to previous messageGo to next message
John Watson
Messages: 4672
Registered: January 2010
Location: Global Village
Senior Member
This is a copy of a problem that was reported on other web sites several years ago.

http://dbaspot.com/oracle-server/367939-ora-24810-during-imp-print.html
http://compgroups.net/comp.databases.oracle.server/ora-24810-during-imp/1515855

What is the purpose of posting this?

Re: problem Import [message #613523 is a reply to message #613522] Wed, 07 May 2014 12:24 Go to previous messageGo to next message
alijeyan
Messages: 173
Registered: January 2007
Location: IRAN
Senior Member
My problem is a copy of that post .
I search for My problem But I can not slove My problem ..... and I want answare from My Favorait Site ( www.ORAFAQ.com )
Re: problem Import [message #613525 is a reply to message #613522] Wed, 07 May 2014 12:52 Go to previous message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Note that OP's location is Iran and so his use of Oracle is most likely illegal and so maybe this is the root of his problem.

As Ed already showed in http://www.orafaq.com/forum/mv/msg/192278/611696/#msg_611696

[Updated on: Wed, 07 May 2014 12:54]

Report message to a moderator

Previous Topic: schema import using impdp
Next Topic: xml file with same segment name loading into database
Goto Forum:
  


Current Time: Tue Oct 21 00:35:56 CDT 2014

Total time taken to generate the page: 0.05678 seconds