Re: Error inserting into partition

#1 (**permalink**) 02-27-2008, 05:06 PM

there is a very long section in books on line regarding updateable
partitioned views, I suggest your start there and verify you meet the
requirements, OR, as an alternative, load the base tables directly.

"Rich" <rstoll@cadencenet.com> wrote in message
news:40b401c35601$d1dccb50$a001280a@phx.gbl...
> I'm testing a partitioned fact table but get the following
> error when I try to insert a record into the view:
>
> [ODBC SQL Server Driver] UNION ALL view 'VW_BILL_FACT' is
> not updateable because a partitioning column not found.
>
> The view does a UNION ALL on two underlying tables. The
> underlying tables(partitions) both have check constraints
> defined.
>
> Help!
>
> Thanks Rich

#2 (**permalink**) 02-27-2008, 05:06 PM

I found the answer to my problem in the Microsoft
Knowledge Base Article - 270013.

Thanks anyway!
>-----Original Message-----
>there is a very long section in books on line regarding
updateable
>partitioned views, I suggest your start there and verify
you meet the
>requirements, OR, as an alternative, load the base tables
directly.
>
>"Rich" <rstoll@cadencenet.com> wrote in message
>news:40b401c35601$d1dccb50$a001280a@phx.gbl...
>> I'm testing a partitioned fact table but get the
following
>> error when I try to insert a record into the view:
>>
>> [ODBC SQL Server Driver] UNION ALL view 'VW_BILL_FACT'
is
>> not updateable because a partitioning column not found.
>>
>> The view does a UNION ALL on two underlying tables. The
>> underlying tables(partitions) both have check
constraints
>> defined.
>>
>> Help!
>>
>> Thanks Rich
>
>
>.
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode