Update Japanese character without Exp/IMp and DB Link

2003-10-08 Thread Oracle DBA 
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
 



__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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).

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

2003-10-08 Thread Stephane Faroult 
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).