Re: Help with the SQL*PLUS copy command
- From: Mayen.Shah@xxxxxxxxxx
- To: gba.oraclel@xxxxxxxxx
- Date: Thu, 30 Jul 2009 13:29:36 -0400
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:
