Database Administration (MOSC)

MOSC Banner

CTAS creates 3 x column size if source is 8i 4 x if source is 10g. Why?

edited Aug 20, 2009 5:00PM in Database Administration (MOSC) 1 commentAnswered
CTAS creates 3 x column size if source is 8i 4 x if source is 10g. Why?
CASE1:
local  database etfat: AL32UTF8
remote database eguat: 10g WE8ISO8859P15: nls_length_semantics=char

    desc gua_owner.VGUA_TFA01_BANK_INFO@eguat;

     Name               Null?    Type
     ------------------ -------- ------------------
     BANK_ID            NOT NULL CHAR(6 CHAR)
     OFFICIAL_NAME               VARCHAR2(70 CHAR)
     COUNTRY_NAME                VARCHAR2(42 CHAR)

     create table tim as select * from gua_owner.VGUA_TFA01_BANK_INFO@eguat;

     select char_length, data_length, column_name, data_type from dba_tab_columns
     where table_name ='TIM';
        
    CHAR_LENGTH DATA_LENGTH COLUMN_NAME                    DATA_TYPE
    ----------- ----------- ------------------------------ ------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center