Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export Errors (TNS)
See if sqlplus can connect to the same database using the same connect
string (Username/passwprd service_name) which you are using for exp utility.
Most probably you won't and that indiates an alias problem.
Hope this helps
Reza
"Jason Rigsbee" <jrigsbee_at_rigsbee.net> wrote in message
news:OtaxxED#$GA.285_at_cpmsnbbsa09...
> When I run the export I receive the following error message:
>
> EXP-00056: ORACLE error 12154 encountered
> ORA-12154: TNS:could not resolve service name
> EXP-00000: Export terminated unsuccessfully
> Last Message:The job failed.
>
> Any help to resolve this would be appreciated.
>
> Also, when I export each table what happens to any triggers, views, etc.
> that users have created. What tables do I not want to export.
>
> jlr
>
>
Received on Fri Jul 28 2000 - 00:00:00 CDT