Help with the SQL*PLUS copy command

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Thu, 30 Jul 2009 11:06:48 -0500
Message-ID: <d7e2170907300906n45b1afcaq9e1147cffab20e4b_at_mail.gmail.com>



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 Received on Thu Jul 30 2009 - 11:06:48 CDT

Original text of this message