Oracle Migration Assistant cuts column names after 26 chars

From: <sergei_at_accordnet.com>
Date: Mon, 28 Dec 1998 11:46:32 GMT
Message-ID: <767r2n$arq$1@nnrp1.dejanews.com>

Hello All,

When I ran the Oracle Migration Assistant for Access it cut all the long table column names to 26 chars. Our database has several columns with names between 27 and 30 chars. I can run

ALTER TABLE Test
ADD SomeColumnWith30CharInItsName VARCHAR(20)

And it adds a column with 30 chars long name, but if I try to change the column name from the Migration Assistant it gives error that the Column Name must be no longer than 26 chars.

Does anybody have a clue? Is this a Migration Assistant limitation or is there some meaning to this?

Thanks for your help!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 28 1998 - 05:46:32 CST