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@xxxxxxxxxxx>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]@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