Oracle 12c character set AL32UTF8 - Create table from remote View creates table with different colum

Hi,

I am trying to create a table from a remote database using a Database link, however table is being created with columns of different size for VARCHAR columns. I need to have the table with same column sizes. Please advise.

Current database Version :

dw_swift_fin@dnrprd01.db17x> select * from V$version;

BANNER                                                                               CON_ID

-------------------------------------------------------------------------------- ----------

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production                0

PL/SQL Release 12.2.0.1.0 - Production                                                    0

CORE    12.2.0.1.0      Production                                                                0

TNS for Linux: Version 12.2.0.1.0 - Production                                            0

NLSRTL Version 12.2.0.1.0 - Production                                                    0

dw_swift_fin@dnrprd01.db17x>

Current Database parameters:

system@dnrprd01.db17x> show parameter NLS%;