Hiiii, I get a problem when i try to copy the file from remote database to mydatabase.
I was connected to remote DB.
then i try to copy I get a error

SQL> COPY FROM SGHDEV/SGHDEV@SGH TO WEBDBDEV/WEBDBDEV@SGH.DIG
> CREATE RANG (FROM_MOBTEL,TO_MOBTEL) -
> USING SELECT * FROM PREPAID_RANGE;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-12154: TNS:could not resolve service name

any one can help me--
this one urgent
thanks
kavitha