Alguién tiene alguna idea sobre este error??
Server: Msg 4436, Level 16, State 12, Line 1
UNION ALL view 'plant_data' is not updatable because a partitioning column
was not found.
Esto me sucede al tratar de insertar sobre una vista particionada.
insert into PLANT_DATA
SELECT '09/16/2005',1,10004,500,0,0,0,0,0 FROM PDA09
Este es el scripts de las tablas
CREATE TABLE [dbo].[PDA09] (
[timestamp] [datetime] NOT NULL ,
[location_ptr] [decimal](5, 0) NOT NULL ,
[data_no] [decimal](5, 0) NOT NULL ,
[value] [decimal](18, 8) NOT NULL ,
[attribute_1] [decimal](5, 0) NOT NULL ,
[attribute_2] [decimal](5, 0) NOT NULL ,
[attribute_3] [decimal](5, 0) NOT NULL ,
[attribute_4] [decimal](5, 0) NOT NULL ,
[time_off] [datetime] NULL
) ON [PDA09]
GO
CREATE UNIQUE CLUSTERED INDEX [PDA09_Idx] ON [dbo].[PDA09]([timestamp],
[location_ptr], [data_no], [value], [attribute_1], [attribute_2],
[attribute_3], [attribute_4]) ON [PDA09]
GO
ALTER TABLE [dbo].[PDA09] ADD
CONSTRAINT [PK_PDA09_NEW] PRIMARY KEY NONCLUSTERED
(
[timestamp],
[location_ptr],
[data_no],
[value],
[attribute_1],
[attribute_2],
[attribute_3],
[attribute_4]
) ON [PDA09]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[PDHIST]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PDHIST]
GO
CREATE TABLE [dbo].[PDHIST] (
[TIMESTAMP] [datetime] NOT NULL ,
[LOCATION_PTR] [decimal](5, 0) NOT NULL ,
[DATA_NO] [decimal](5, 0) NOT NULL ,
[VALUE] [decimal](18, 8) NOT NULL ,
[ATTRIBUTE_1] [decimal](5, 0) NOT NULL ,
[ATTRIBUTE_2] [decimal](5, 0) NOT NULL ,
[ATTRIBUTE_3] [decimal](5, 0) NOT NULL ,
[ATTRIBUTE_4] [decimal](5, 0) NOT NULL ,
[TIME_OFF] [datetime] NULL
) ON [PDHIST]
GO
ALTER TABLE [dbo].[PDHIST] ADD
CONSTRAINT [PKey_PDHIST] PRIMARY KEY NONCLUSTERED
(
[TIMESTAMP],
[LOCATION_PTR],
[DATA_NO],
[VALUE],
[ATTRIBUTE_1],
[ATTRIBUTE_2],
[ATTRIBUTE_3],
[ATTRIBUTE_4]
) ON [PDHIST]
Leer las respuestas