Home » RDBMS Server » Server Utilities » ORA-03120: two-task conversion routine: integer overflow (oracle 9.2.0.1.0 Win XP)
ORA-03120: two-task conversion routine: integer overflow [message #459464] Sat, 05 June 2010 14:00 Go to next message
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 #459469 is a reply to message #459464] Sat, 05 June 2010 14:55 Go to previous messageGo to next message
alexaoracle
Messages: 36
Registered: October 2007
Member
So as one can read from above:

"Import terminated successfully without warnings."

but the same log says:

". . skipping table "TABLEA" "

which means no table has been imported.

So if after import I do:

select * from TABLEA 


I will get table TABLEA does not exist.
So the question again is,
how do I import TABLEA?
Re: ORA-03120: two-task conversion routine: integer overflow [message #459470 is a reply to message #459469] Sat, 05 June 2010 15:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>"Import terminated successfully without warnings."
above is from SHOW=YES that only displays DDL.

In most cases the advice would be to submit a Service Request,
but since V9 is obsoleted & unsupported, no advice is possible.

This error might be related to character set, then again it might not.

Can you import into a DB that is currently supported (like V11.2) as a test?
Re: ORA-03120: two-task conversion routine: integer overflow [message #459471 is a reply to message #459470] Sat, 05 June 2010 15:15 Go to previous messageGo to next message
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.
Re: ORA-03120: two-task conversion routine: integer overflow [message #459472 is a reply to message #459471] Sat, 05 June 2010 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>And also, I dont have version 11.2 to test it.

nothing stops you from downloading V11.2, installing & testing
Re: ORA-03120: two-task conversion routine: integer overflow [message #459473 is a reply to message #459472] Sat, 05 June 2010 15:27 Go to previous messageGo to next message
alexaoracle
Messages: 36
Registered: October 2007
Member
Ok
Re: ORA-03120: two-task conversion routine: integer overflow [message #459478 is a reply to message #459473] Sat, 05 June 2010 18:12 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suspect you are hitting an Oracle bug.
If this is correct, then nobody here can make this error go away.
Your V9 Oracle is obsoleted & unpatched while running on untested & unsupported OS.
You should be thankful is works as well as it has so far.
Previous Topic: performance diff in exp & expdp
Next Topic: Load Comma Delimited file having multiple datasets into multiple tables using a single CTL file (mer
Goto Forum:
  


Current Time: Sun Sep 19 21:11:07 CDT 2021