Try specifying precision for the NUMBER data type. There is a bug in
8.1.5 with using the "float" data type in a mterilaized view. This is
probably due to the same bug. BTW, try to move off 8.1.5 as soon as
you can. This is a much maligned release, and for good reasons.
siarsky_at_usa.com (siarsky) wrote in message news:<cf3f8310.0307180517.16b54e19_at_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 - 13:11:57 CDT
