Monday, November 14, 2005

Triple size as the source table after copying tables through database links

Today I find out an interesting symptom. After copying tables from the source database in 9.2.0.5 to the target database in 10.1.0.2 via a database link, the size of every column related to CHAR including CHAR and VARCHAR2 in the target database is three times as large as the their source. There is no problem while using exp/imp to clone the tables from the source to the target. I suspect the different character sets in the 2 databases affect the result. It's UTF8 in the source DB as it's AL32UTF8 in the target DB.

5 comments:

Anonymous said...

TrediaSarce, clomid online PraineefaxSix, [url=http://www.webjam.com/clomidonline]buy clomid[/url] Bruispops
23

Anonymous said...

chararorylarp, buy zyrtec, Carardykats, [url=http://www.webjam.com/zyrteconline]zyrtec[/url], Glaccerve

Anonymous said...

TexanyThync, viagra tramadol zithromax carisoprodol buy cialis, piluerryMer

Anonymous said...

Verduekssem, propecia online, spancenus, [url=http://virb.com/propeciaonline]propecia[/url]

Anonymous said...

estaliBriesty, cheapest tramadol, bealiaVet, cheap tramadol, Hifavamom, order tramadol, dofafforp, tramadol online, MatBultapetle