Hello,

I have two same tables in Oracle 8.1.5.0.0, but the command

create snapshot curr
on prebuilt table
refresh complete
as
select *
from curr@eb_link;

returns

ERROR at line 8:
ORA-12060: shape of prebuilt table does not match definition query

I try to make a snapshot over DB-Link eb_link. This snapshot worked
till I added a new column orun_id_real. To make so, I dropped
snapshot, change source and target table definition. After this
I can not get the snapshot to work.

If I try

create snapshot curr
on prebuilt table
refresh complete
as
select
id
,orun_id
,cd
,mnemonic
,exchange_factor
,iso_code
,decimal_places
,euro
,pt_valid
,uc
,dc
,um
,dm
,orun_id_real
from curr@eb_link

(so without *) Oracle tells me:

,cd
*
ERROR at line 8:
ORA-12060: shape of prebuilt table does not match definition query

but I see no difference in the column type "cd".

Could you please help me?

Thanks a lot
Branislav

PS:
desc curr
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(38)
ORUN_ID NOT NULL NUMBER(5)
CD NOT NULL VARCHAR2(20)
MNEMONIC NOT NULL VARCHAR2(20)
EXCHANGE_FACTOR NOT NULL NUMBER(5,2)
ISO_CODE NOT NULL VARCHAR2(3)
DECIMAL_PLACES NOT NULL NUMBER(2)
EURO NOT NULL VARCHAR2(1)
PT_VALID NOT NULL VARCHAR2(1)
UC NOT NULL VARCHAR2(120)
DC NOT NULL DATE
UM VARCHAR2(120)
DM DATE
ORUN_ID_REAL NOT NULL NUMBER


desc curr@eb_link
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(38)
ORUN_ID NOT NULL NUMBER(5)
CD NOT NULL VARCHAR2(20)
MNEMONIC NOT NULL VARCHAR2(20)
EXCHANGE_FACTOR NOT NULL NUMBER(5,2)
ISO_CODE NOT NULL VARCHAR2(3)
DECIMAL_PLACES NOT NULL NUMBER(2)
EURO NOT NULL VARCHAR2(1)
PT_VALID NOT NULL VARCHAR2(1)
UC NOT NULL VARCHAR2(120)
DC NOT NULL DATE
UM VARCHAR2(120)
DM DATE
ORUN_ID_REAL NOT NULL NUMBER