Consulta sobre vistas particionadas

14/09/2005 - 23:20 por Jose Peñafiel T. | Informe spam
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

#1 Maxi
15/09/2005 - 13:49 | Informe spam
Hola, el error es claro, la columna no existe en la vista!! revisa ello


Salu2
Maxi


"Jose Peñafiel T." escribió en el mensaje
news:
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]


Preguntas similares