Re: ORA-00997: How to copy the data from a table to another using long type

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 22 Nov 2002 14:21:53 +0100
Message-ID: <3DDE2F71.5000102@science-computing.de>

Holger Baer wrote:
> I'm not sure if I missed something, but according to your original
> post you where trying to insert content.xml into content2.newfield.
>
> I think the two datatypes just don't mix. If you had used
> insert into content2 select id_content, data_contenuto, null, xml from
> content;
>
> this should have worked as well - but I might stand corrected there.
>
> Regards,
> Holger
>

Sorry,

your example put me on the wrong track - after sending my reply, I tested what I suggested, but that didn't work (on 9i). Not with the long column containing plain nulls.

Anyway, I still believe your example and your errormessage don't match.

Regards,

Holger Received on Fri Nov 22 2002 - 07:21:53 CST