From: "Niall Litchfield" Newsgroups: comp.databases.oracle.misc References: <3B1E2826.CAA5648A@wp-sa.pl> Subject: Re: Log Column Update 7.3 Date: Wed, 6 Jun 2001 15:42:38 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Lines: 31 Message-ID: <3b1e4166$0$15027$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 991838566 reading.news.pipex.net 15027 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Unfortunately the subject line states that this is on 7.3. There are some interesting pages on using the sqlplus copy command for longs on thomas kytes pages. Otherwise use your favourite programming language to manipulate the data programmatically. 7.3 is long since desupported and , as you are finding 8i has some nice features which address some of its shortcomings. -- Niall Litchfield Oracle DBA Audit Commission UK "Rafal Jank" wrote in message news:3B1E2826.CAA5648A@wp-sa.pl... > sam pal wrote: > > > > Hi > > How can I update the Long Column?. The data is more than 32k. > > > By changing them to clob columns, and then using functions from dbms_lob > package. > Rafal > -- > _/ _/ _/_/_/ ----- Rafa³ Jank yankee@wp.pl ----- > _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl > _/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 > _/ _/ _/ --------==* http://szukaj.wp.pl *==----------