COPY command returns ORA-0091

COPY command returns ORA-0091

 

  

Guys,

I am just copying a table from one schema to another and it returns
ORA-0091, I am using Oracle 9i 9.0.1.4.

I was doing this comfortably in 8.1.7


copy from health/[Email Address Removed] to trainee/[Email Address Removed] create org_loc
using select * from org_loc

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

ERROR:
ORA-00911: invalid character

Thanks & Regards,
A.Kishore

****************************************************************************
This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.
****************************************************************************
Oracle LazyDBA home page