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

Thread: IMP errors

  1. #1
    Join Date
    Dec 2005
    Posts
    195

    IMP errors

    Dear all,

    I am exported the schema and import into another schema on the same database. I get this error. Can any one tell me why is this error?


    Import: Release 9.2.0.1.0 - Production on Wed Mar 28 21:16:07 2007

    Copyright (c) 1982, 2002, 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
    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    . importing RAVENPRD's objects into RAVENTST
    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

    C:\>

  2. #2
    Join Date
    Jan 2007
    Posts
    231
    This can happen when an invalid buffer length or great a row count is specified.

    Check parameters.,Reduce all integer parameters, column values not included, to less than 32767.

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