Re: update a LONG column HOWTO
- From: Thomas Day <tomday2@xxxxxxxxx>
- To: oracleMail List <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2005 10:45:06 -0400
Use the sqlplus "copy" command.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/apb.htm#634269
COPY {FROM database | TO database | FROM database TO database}
{APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column,
column, ...)]
USING query
where database has the following syntax:
username[/password]@connect_identifier
Copies data from a query to a table in a local or remote database.
COPY supports the following datatypes:
CHAR
DATE
LONG
NUMBER
VARCHAR2
On 6/30/05, sarath kumar <sarath_kumar0@xxxxxxxxx> wrote:
> I have LONG column in 9.2.0.3 database, i am updating
> as follows thru database link, i Could update them if
> the column size is small, The column might be some kb
> not MB, how to specify the size of LONG Column
> SQL> set LONG 320000
> SQL> l
> 1 declare
> 2 l_str LONG;
> 3 begin
> 4 select content into l_str from tos@devvdv where
> tos_id = 2012;
> 5* end;
> SQL> /
> declare
> *
> ERROR at line 1:
> ORA-01406: fetched column value was truncated
>
> ANY SUGGESTIONS
> -sarath
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
