Re: Help with the SQL*PLUS copy command
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: gba.oraclel@xxxxxxxxx
- Date: Thu, 30 Jul 2009 19:47:55 +0200
afaik the syntax is:
copy from user/password@tns-alias to user/password@tns-alias insert
table_name using select * from table_name
On Thu, Jul 30, 2009 at 7:43 PM, GBA-DBA <gba.oraclel@xxxxxxxxx> wrote:
> 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
>
--
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13
Other related posts:
