Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus Copy Command Problem - Query length limitation

SQL*Plus Copy Command Problem - Query length limitation

From: Layan <muawiahk_at_gmail.com>
Date: 21 Feb 2005 00:46:58 -0800
Message-ID: <1108975618.909342.60330@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.
Received on Mon Feb 21 2005 - 02:46:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US