Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-12060: shape of prebuilt table does not match definition query
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_at_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_at_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_at_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 NUMBERReceived on Fri Jul 18 2003 - 08:17:17 CDT
![]() |
![]() |