Thanks Sam,

I did tnsping dbname- it shows the connection which is correct.

I am exporting like-

C:\>exp userid=bonny/testb@testb file=c:\temp\
sttb.dmp log=c:\temp\sttb.log buffer=1000000 compress=N consistent=Y rows=Y tables= 'bonny.stats_tb'

Export: Release 9.2.0.1.0 - Production on Thu Aug 12 08:24:07 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
JServer Release 9.0.1.4.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

I did try using= exp userid=bonny@testb file=......
password was applied.But still has either tnsname error or table or view does not exist.

Any further suggestion.

Thanks