www.1q.co.kr(park1q.com)

ID :  Password : Auto  

   ȸ¿ø:0¸í / ¼Õ´Ô:0¸í
 

 

Technote

ÀÚ·á ¹× °ü¸®ÆÁ

  • DBA Notes
  • Q & A

    ºÏ¸¶Å©
  • Asktom
       (Oracle ÀÇ ´ëÇ¥ Forum)
  • Technical Bulltin(KR)
       (±â¼úÁö¿ø°Ô½ÃÆÇ)
  • Dbazine

  •  

     


     KO16KSC5601 to WE8DEC
    park1q  2017-07-22 17:48:46, Á¶È¸ : 5,354, Ãßõ : 1313


    ¤± KO16KSC5601 À» WE8DEC ·Î Àüȯ ¶Ç´Â VIEW ¸¦ »ç¿ëÇؼ­ µ¥ÀÌŸ Á¶È¸ ÇÏ´Â ¹æ¹ý
    ¿©·¯ ¹æ¹ýÀ» ã¾Æ º¸¾ÒÁö¸¸ Á÷Á¢ÀûÀ¸·Î MIGRATION ÇÒ¼ö ÀÖ´Â ¹æ¹ýÀº ¾ø´Ù.
    Å×½ºÆ®¸¦ À§ÇØ ADM9I DB ´Â KO16KSC5601 ·Î »ý¼º, WE8DEC DB ´Â WE8DEC ·Î »ý¼ºÇÏ¿´´Ù.

    ÀÏ´Ü ¸ñÇ¥°¡ KO16KSC5601 ¸¦ WE8DEC ·Î ÀüȯÇÏ´Â °ÍÀ̱⠶§¹®¿¡ ¿µÇâµµ°¡ ÀÖ´Â Å×À̺íÀ» SCAN ÇÏ¿©¾ß ÇÑ´Ù.
    KO16KSC5601 ¿¡¼­ csminst.sql ¸¦ ¼öÇàÇÑ´Ù.
    SQL> @?/rdsbm/admin/csminst.sql

    ±×´ÙÀ½¿¡ csscan system/park1q USER=scott TOCHAR=WE8DEC ¸¦ ¼öÇàÇÑ´Ù.
    csscan ÀÇ Á¤È®ÇÑ »ç¿ë¹ýÀº csscan help=y ¸¦ ÂüÁ¶ÇÑ´Ù.
    scan À» ÇÏ´Â ¸ñÀûÀº migration ¿¡¼­ error °¡ ³¯ Å×ÀÌºí ¹× row ¸¦ È®ÀÎÇϱâ À§ÇÔÀÌ´Ù.
    ¿Ï·áÈÄ ´ÙÀ½ È­ÀÏÀÌ »ý¼ºµÈ´Ù.

    scan.txt
    scan.out
    scan.err

    scan.txt ¸¦ ¿­¾î º¸¸é Convertible  °ú Exceptional ÀÌ Àִµ¥, ÀÌÁß Exceptional ¿¡ ÇØ´çÇÏ´Â column Àº conversion ºÒ°¡´ÉÇÏ´Ù.
    ¤± ÀÌ°ÍÀ» ÇØ°áÇÒ¼ö ÀÖ´Â ¹æ¹ý(À¯ÀÏ)
    ¿¹¸¦ µé¾î csscan À¸·Î 100°³ÀÇ Å×À̺íÀ» °Ë»ç Çߴµ¥, 10°³¸¸ exceptional ¿¡ °É¸±¼ö ÀÖ´Ù.
    ÀÌ Å×À̺í10°³¿¡´Â Áï, ÇѱÛÀÌ ÀÖ´Ù´Â ¾ê±âÀε¥, ÀÌ·¯ÇÑ Å×ÀÌºí¸¸ insert into ~ select @link ·Î ÇØ°áÇÏ´Â ¹æ¹ýÀÌ´Ù.


    ############### AT KO16KSC5601
    ÀÏ´Ü KO16KSC5601 ¿¡ ÇѱÛÀÌ Æ÷ÇÔµÈ Å×À̺íÀ» TLANG À̶ó°í ÇÏ°í COLUMN Àº 2°³ COL01, COL02 °¡ Á¸ÀçÇÑ´Ù.

    ¿©±â¼­ VI_TLANG VIEW ¸¦ »ý¼ºÇÑ´Ù.
    CREATE VIEW VI_TLANG      AS
    SELECT UTL_RAW.CAST_TO_RAW(COL01) col01 , UTL_RAW.CAST_TO_RAW(COL02) col02
      FROM TLANG ;

    ############### AT WE8DEC
    KO16KSC5601 ·ÎÀÇ DB LINK ¸¦ »ý¼ºÇÑ´Ù.
    CREATE DATABASE LINK LN_KOR CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'KOR' ;
    TEST :
    SQL> SELECT SYSDATE FROM
    DUAL@LN_KOR ;
    Á¤»óÀûÀ̶ó¸é ½Ã°£ÀÌ ³ª¿Ã°ÍÀÌ´Ù.
    ±×·±ÈÄ¿¡
    SELECT * FROM
    VI_TLANG@LN_KOR  ;
    °á°ú´Â ´ÙÀ½°ú °°´Ù.
    COL01                COL02
    -------------------- --------------------
    BEC8B3E7C7CFBCBCBFE4 B6C7B8B8B3B5B1BABFE4
    2E2E                 2E2E

    A3BFBCA5A3BF         A3BFBCA5A3BF
    B9DABFF8B1D4         C8ABB1E6B5BF


    ´Ù½Ã
    ¾Æ±î  AT KO16KSC5601 ¿¡¼­ ¸¸µé¾ú´ø VIEW ÀÇ ¿ªÀ¸·Î SELECT ¹®À» ¸¸µç´Ù.
    SQL> SELECT UTL_RAW.CAST_TO_VARCHAR2(COL01) COL01 , UTL_RAW.CAST_TO_VARCHAR2(COL02) COL02   FROM
    VI_TLANG@ln_KOR;
    °á°ú´Â ¾Æ·¡¿Í °°´Ù. ¿©±â¼­ ?·Î ³ª¿À´Â°ÍÀº Ç¥ÁØ ¿Ï¼ºÇü ÇѱÛÀÌ ÇÏ´Ñ [뿀]°ú [샾]À̶ó´Â ±ÛÀÚÀÌ´Ù.
    COL01                COL02
    -------------------- --------------------
    ¾È³çÇϼ¼¿ä..         ¶Ç¸¸³µ±º¿ä..
    £¿¼¥£¿               £¿¼¥£¿
    ¹Ú¿ø±Ô               È«±æµ¿


      ÃßõÇϱâ ÇÁ¸°Æ®   ¸ñ·Ïº¸±â

    Copyright 1999-2025 Zeroboard

     

     
     
    [Today:3 / Total:172120]    Design by p@rk1q