Help with the SQL*PLUS copy command

  • From: GBA-DBA <gba.oraclel@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Jul 2009 11:06:48 -0500

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: