Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-12060: shape of prebuilt table does not match definition query

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

From: siarsky <siarsky_at_usa.com>
Date: 18 Jul 2003 06:17:17 -0700
Message-ID: <cf3f8310.0307180517.16b54e19@posting.google.com>


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 NUMBER
Received on Fri Jul 18 2003 - 08:17:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US