Re: Help with the SQL*PLUS copy command
- From: GBA-DBA <gba.oraclel@xxxxxxxxx>
- To: Mayen.Shah@xxxxxxxxxx
- Date: Thu, 30 Jul 2009 12:43:54 -0500
I'm not using db links. AFAIK is not needed.
GBA
On Thu, Jul 30, 2009 at 12:29 PM, <Mayen.Shah@xxxxxxxxxx> wrote:
>
> 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* <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
>
--
Regards
GBA
Other related posts:
