Re: Help with the SQL*PLUS copy command

From: <>
Date: Thu, 30 Jul 2009 13:29:36 -0400
Message-ID: <>


Did you setup db link properly?

What do you get when you execute following?

Select sysdate from dual_at_server;

  • Mayen

Sent by: Jul 30 2009 12:06 PM
Please respond to

"Oracle Discussion List" <> cc

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?


Received on Thu Jul 30 2009 - 12:29:36 CDT

Original text of this message