Re: Update Japanese character without Exp/IMp and DB Link

Oracle DBA wrote:
>
> Hi List:
>
> I have
> Database DB1
> Table name T1
> Column Name C1
>
> C1 has some japanese character
>
> Database DB2
> Table name T2
> Column Name C2
>
> I want to update C2 column(only one record) with C1
> column value.
>
> Note:-
> Exp/Imp AND db_link is not possible
> ===================================
>
> Any help would be really appreciated.
>
> Thanks
> Sami
>
>

In one window connect to DB1

  select C1 from T1;

In a second window connect to DB2

  type

      update T2 set C2 = <painfully type what you see in the other window here>;

      commit;

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).