Copy - why doesn't this work?

From: Shaw, John B <jbshaw_at_ingr.com>
Date: Tue, 11 Sep 2001 10:35:12 -0700
Message-ID: <F001.0038A353.20010911092040@fatcity.com>

SQL> copy from lea/lea_at_fog to lea/lea_at_fog create test3 using select * from test;

Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 10000. (long is 10000)

ERROR:
ORA-00911: invalid character

SQL> desc test

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 A                                                  CHAR(2)
 B                                                  LONG
 C                                                  CLOB

SQL> desc test3
ERROR:
ORA-04043: object test3 does not exist
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shaw, John B
  INET: jbshaw_at_ingr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 11 2001 - 12:35:12 CDT