export and import oracle db

[yytan]

hi;

i am wonder whether is it possible to export db from the oracle 8i to oracle 8?

moreover, i am using TELNET to acces to the linux machine which already install the oracle 8i. i am having problem when doing export.

i have tried to use EXP system/manager@service_name and it gave me this error:

/home/kahoo/buynfly>exp system/manager@linuxmv

Export: Release 8.1.6.1.0 - Production on Thu Jun 13 16:43:07 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.


EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully

i am sure that the service name is correct because in the net8 assistant i have test the connection, it works and then i open the sql worksheet, i am using the same service name as well. may i know what is the reason?

 

[sem]

ORA-12154 means that your connect string is DEFINITELY wrong.
This may be due to the wrong environment settings: net8 assistant may be located in other home (machine?) than your exp utility. Tns alias is more client- than server-specific, so successful using it from one client does not affect others. If you're trying to connect to local database (I suppose you are, because both exp utility and database are located on the same linux box), try to do not use tns alias at all. This will work if
1. Both exp and database are installed in the same ORACEL_HOME
2. No LOCAL environment variable is defined or it does point to the local database.

In general, to connect to some database via sql*net your tns alias must be defined in APPROPRIATE (located at the same home in /network/admin or in other directory, defined by TNS_ADMIN environment variable) tnsnames.ora file.