Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: size of table increased with db link

    Could any one help in clarifying the below issue

    both DB are 9207
    in Database A ( char set We8dec)
    View attributes: SQL> desc V_PLAN

    Name Null? Type
    -------------------------------------------------------

    I_KEY NOT NULL VARCHAR2(10)
    NAME_WELL VARCHAR2(50)



    While creating / copying this view in Databse B ( char set UTF8):
    create or replace view mm as select substr(to_char(i_key),1,10) i_key
    ,substr(to_char(name_well),1,50) name_well
    from v_plan@dw
    where rownum < 11

    See the result!:

    SQL> desc dd
    Name Null? Type
    ----------------------------------------- -------- ------------------
    I_KEY VARCHAR2(30)
    NAME_WELL VARCHAR2(150)



    Any suggestion?
    Last edited by jundba; 05-06-07 at 07:13.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •