ORA-03120: two-task conversion routine: integer overflow [message #459464] |
Sat, 05 June 2010 14:00 |
alexaoracle
Messages: 36 Registered: October 2007
|
Member |
|
|
Hi,
I am doing an import:
imp user/pwd@instance fromuser=a touser=b buffer=5000000 commit=yes ignore=y recordlength=65535 file=d:\aN.dmp log=d:\aE1.log
and this is what I get:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8DEC character set (possible charset conversion)
. . importing table "TABLEA" 1 rows imported
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00000: Import terminated unsuccessfully
with show=yes:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8DEC character set (possible charset conversion)
"CREATE TABLE "TABLEA" ("ID_DOC" NUMBER(8, 0), "DOC_ABSTRACT_ENG""
" NCLOB) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 6553"
"6 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "n" LOGGING NOCO"
"MPRESS LOB ("DOC_ABSTRACT_ENG") STORE AS (TABLESPACE "n" EN"
"ABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1))"
. . skipping table "TABLEA"
"CREATE UNIQUE INDEX "PK9" ON "TABLEA" ("ID_DOC" ) P"
"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIS"
"T GROUPS 1) TABLESPACE "n" LOGGING"
"ALTER TABLE "TABLEA" ADD CONSTRAINT "PK9" PRIMARY K"
"EY ("ID_DOC") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIA"
"L 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "n" LOGGIN"
"G ENABLE "
Import terminated successfully without warnings.
How can I import successfully the table?
|
|
|
|
|
Re: ORA-03120: two-task conversion routine: integer overflow [message #459471 is a reply to message #459470] |
Sat, 05 June 2010 15:15 |
alexaoracle
Messages: 36 Registered: October 2007
|
Member |
|
|
Well, you might be right about character set. I have to import this table to 2 different users. Each one, is in a different Database.
The first which import the table successfully was:
Import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
And the second one, that it was not imported:
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8DEC character set (possible charset conversion)
the problem, is that there are many applications where the second user is, and there is no way to change the character set because it does not depend on my decision. So what other way is there to do this? help is greatly appreciated
And also, I dont have version 11.2 to test it.
|
|
|
|
|
|