| problem Import [message #613516] |
Wed, 07 May 2014 12:06  |
alijeyan
Messages: 184
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 #613523 is a reply to message #613522] |
Wed, 07 May 2014 12:24  |
alijeyan
Messages: 184
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 )
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
