Re: Help with the SQL*PLUS copy command

Hi GBA,

Did you setup db link properly?

What do you get when you execute  following?

Select sysdate from dual@server; 

- Mayen






GBA-DBA <gba.oraclel@xxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Jul 30 2009 12:06 PM
Please respond to
gba.oraclel@xxxxxxxxx


To
"Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
cc

Subject
Help with the SQL*PLUS copy command


Hi list
 
I'm trying to copy some data from one of the servers to an oracle instance 
on my pc.
 
This is what i'm using
 
copy from schema.table@server insert local_table using select * from 
schema.table where ....
 
I'm getting a "ORA-01017: invalid username/password; logon denied". I'm 
sure the username and password are correct because I can log into the 
database using those credentials.
 
I'm using the same syntax to copy data between servers and it works fine, 
but when I try to do it with my pc ... it fails with that error.
Any clue about this?

-- 
Regards
GBA

Other related posts: