Oracle 8i Lite export/import problem

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 : TNS:protocol 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

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

Quote:

---

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