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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
