Re: ORA-12060: shape of prebuilt table does not match definition query

Thanks Jusung,
I read your older post about it and this was not the case.

I realised (after the post to the newsgroup), that we do not have the same DBs on both sides:

8.1.5.0.0 ----DB-Link------> 8.1.7

The solution was in:
drop table curr (on the 8.1.5.0.0) DB

and

create table curr
as select * from curr_at_eb_link;

and then

create snapshot curr

After this recreate of the table from 8.1.7, everything is working for me.

I think the problem could be in:
1. the DB do not have the same coding => 8.1.7 has UTF8, 8.1.5 has ISO??? 2. I have a feeling, that there is a bug in Oracle, if you have a column varchar2(80) and you have some special characters in it (as german ä, ö, ü), and if you have 80 chars in a record => the size of the entire string will be somehow bigger for Oracle....

Branislav Received on Sun Aug 03 2003 - 12:14:45 CDT