Re: Oracle LONG type

Ken.

For tables that contain the LONG datatype, try using the "copy" command. For your example, assume you are connected to the destination schema.

	copy from username/passwd_at_prod -
	insert bill_image_index using - 
	select * from bill_image_index
	where cust_id ='00002345';

Ken Geng <ken.geng_at_cbis.com> wrote in article <335B77B8.36F3_at_cbis.com>...
> All,
> Following is the SQL that we use to extract data from one table to
> another:
>
> INSERT INTO bill_image_index
> SELECT * FROM bill_image_index_at_prod
> WHERE cust_id = '00002345';
>
> This type of query works fine if there no LONG type in the table. If
> a column of the table is defined as LONG, the following error occurs:
>
> ORA-00997: illegal use of LONG datatype.
>
> Any suggestion how to get around this Oracle limitation?
>
> Thanks in advance for any help.
>
> Ken.
>
Received on Tue Apr 29 1997 - 00:00:00 CDT