Updated Views

miiclaudia

Hi All
I have an issue in the views when i trying to do an updated in one view. My wish is include two columns more in one view but is too impossible and the data point send me error.

Thanks in advanced

SruthiA

@miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.

Jim_Knicely

Can't you do a CREATE OR REPLACE VIEW?

miiclaudia

Dear Jim, the case is not permit include the new two fields in Create or replace view. =(

Jim_Knicely

@miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?