Re: SQL*Plus Copy Command Problem - Query length limitation

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Mon, 21 Feb 2005 14:51:42 GMT
Message-ID: <Xns960445CD16A13SunnySD@68.6.19.6>

"Layan" <muawiahk_at_gmail.com> wrote in
news:1108975618.909342.60330_at_c13g2000cwb.googlegroups.com:

> I'm trying to run a copy command with a very large query. The problem
> is that "COPY" command has a limitation of 2499 characters. Does
> anybody know how can I override this limitation?
>
> p.s. The solution of creating a view of the large query is a nice one
> but can't be adopted in my specific case.

SQL> SET LONG 32767 Received on Mon Feb 21 2005 - 08:51:42 CST