Re: Help with the SQL*PLUS copy command

Did you setup db link properly?

What do you get when you execute following?

Select sysdate from dual_at_server;

• Mayen

GBA-DBA <gba.oraclel_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org Jul 30 2009 12:06 PM
Please respond to
gba.oraclel_at_gmail.com

To
"Oracle Discussion List" <oracle-l_at_freelists.org> 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_at_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


--
http://www.freelists.org/webpage/oracle-l