Re: Help with the SQL*PLUS copy command

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Thu, 30 Jul 2009 12:47:31 -0500
Message-ID: <d7e2170907301047r13060926icf409f510cee1df3_at_mail.gmail.com>



Thanks a lot Brandon!!

That's all I needed... a new pair of eyes.

Looks like I won the 1st place for the stupid question of the day.

GBA On Thu, Jul 30, 2009 at 12:29 PM, Allen, Brandon <Brandon.Allen_at_oneneck.com>wrote:

> Iíve never used the COPY command before, but according to the doc (
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/apb.htm)
> your syntax looks wrong to me. Itís supposed to be:
>
>
>
> COPY FROM *database* INSERT . . . USING . . ;
>
> where *database* has the following syntax:
>
> username[/password]_at_connect_identifier
>
>
>
> It looks like youíve specified schema.table instead of username/password.
>
>
>
> Regards,
>
> Brandon
>
>
>
> ------------------------------
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>

-- 
Regards
GBA

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 30 2009 - 12:47:31 CDT

Original text of this message