IMP-00003: ORACLE error 2248 encountered

[confident]

we have two database server one is oracle 9.2.0.4 and oracle 8.1.7.. iam doing the export of some tables from 9i database and trying to import in 8.1.7 database using 9.0.1 client, iam facing error

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)

IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION

IMP-00000: Import terminated unsuccessfully

is there any solution for this error...

[davey23uk]

you cant use the 9.0.1 client to import into an 8.1.7 database, you must use the 8.1.7 exp and imp

[TimHall]

Hi.

Take a look at this link:

http://download-west.oracle.com/docs...01.htm#1013195

It tells you the imp/exp versions you must use to convert between Oracle versions.

Cheers

Tim...

[pranavgovind]

Dav, I need your advise here. It looks like, i have similar problem in this thread.

Here is the scenario. My oracle client version is 10g. The import database version is 9.2.0.8.0. I got my dump file from one of my client. I do not have any info about the dump file(what db version etc). I need to import this dump file into my database. My import db version is 9.2.0.8.0.

Here is the below error message. What is the solution? Can't import the dump file into 9i database with 10g client version? If so, then would it resolve if i install 9i client in my local machine. Please let me know.



C:\Paul>imp userid=sytem/xxx@oracle9idb file=c:\paul\paul.dmp fromuser=GSC_PROD
touser=paulhodge log=c:/paul.log

Import: Release 10.1.0.2.0 - Production on Mon Jul 9 16:46:41 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.


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

Warning: the objects were exported by GSC_PROD, not by you

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
IMP-00003: ORACLE error 2248 encountered
ORA-02248: invalid option for ALTER SESSION
IMP-00000: Import terminated unsuccessfully

[davey23uk]

why on earth would you use 10g imp on a 9i db

[pranavgovind]

Dav, I installed oracle9i client and this error is fixed now. But i get the below error. Can you please tell me about this error?..

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing GSC_PROD's objects into PAULHODGE
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00000: Import terminated unsuccessfully

[davey23uk]

you need to work out where the export file came from i.e. what version

[pranavgovind]

Dav, Thanks. I will work on it. But here is the error message. The error message shows me that, export version is V09.02.00 . The import client version is 9.0.1.1.1 . The import database version is 9.2.0.8.0 . Do you think that this is inconsistent..



Import: Release 9.0.1.1.1 - Production on Mon Jul 9 21:26:51 2007

(c) Copyright 2001 Oracle Corporation. All rights reserved.


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
Warning: the objects were exported by GSC_PROD, not by you

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing GSC_PROD's objects into PAULHODGE
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00003: ORACLE error 3120 encountered
ORA-03120: two-task conversion routine: integer overflow
IMP-00000: Import terminated unsuccessfully