DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: IMP-00003: ORACLE error 2248 encountered

  1. #1
    Join Date
    Mar 2005
    Posts
    26

    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...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  4. #4
    Join Date
    Dec 2005
    Posts
    195
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why on earth would you use 10g imp on a 9i db

  6. #6
    Join Date
    Dec 2005
    Posts
    195
    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

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to work out where the export file came from i.e. what version

  8. #8
    Join Date
    Dec 2005
    Posts
    195
    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
  •  


Click Here to Expand Forum to Full Width