-
IMP-00003: ORACLE error 2248 encountered
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...
-
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
-
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...
-
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
-
why on earth would you use 10g imp on a 9i db
-
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
-
you need to work out where the export file came from i.e. what version
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|