Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to run copy … from the Enterprise Mgr's SQLWorksheet?
On Tue, 08 Feb 2000 02:29:07 GMT, Ken Sproule <kenmn_at_tds.net> wrote:
>I would like to thank everyone in advance for your help.
>
>Copy From user/password_at_xxxx TO user/password_at_yyyy REPLACE
> USING select * from A;
>
>Works in SQL*Plus, but gives me all sorts of errors when I try it from
>the SQLWorksheet. I know copy …. Is not a valid SQL syntax, but there
>must be a way to run the command from the SqlWorksheet.
>
>How can I do it?
>
>Best,
>
>Ken Sproule
>Kenmn_at_tds.net
>
COPY is a sql*plus specific command
Hth,
Sybrand Bakker, Oracle DBA Received on Tue Feb 08 2000 - 01:11:02 CST