Oracle 8i Lite export/import problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle 8i Lite export/import problem

  1. #1
    Join Date
    Mar 2002
    Posts
    29

    Question

    Hello,

    am working with Orale 8i, and i want to export all 500 tables from Oracle to Oracle 8i Lite (local Database).

    I can successefully export everything from Oracle 8i, but i cant import it to Lite. I try with command :

    Imp80 system/manager@odbc:test file=Export.dmp i get error :

    IMP-00058 : ORACLE error 3121 encounterd
    ORA-03121 : no interface driver connected - function not preformed
    IMP-00000 : Import terminated unseccessfully

    If i try with imp system/manager i get error :

    IMP-00058 : ORACLE error 12560 encounterd
    ORA-12560 : TNSrotocol adapter error
    IMP-00000 : Import terminated unseccessfully

    Thats it, can someone please explain what am i dooind wrong, or any tips on how to fix it?

    Thanks in advnaced

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    whats ur service name i.e is connect string.
    you have given system/manager@odbc:test.
    I guess oracle 8i and lite 8i libraries are not compatiable.
    There must be some version variation which must be causing this problem.

    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Imp80 system/manager@odbc:test file=Export.dmp i get error :
    It should be a proper service name from %ORACLE_HOME%\network\admin\tnsnames.ora

    Otherwise set the SID and use system/manager and don't specify the service name

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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