Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Updatable view - Please assist
icon5.gif  Regarding Updatable view - Please assist [message #674109] Fri, 04 January 2019 01:26 Go to next message
Messages: 1
Registered: January 2019
Junior Member
I have table called xtable. It has 100 million records(past 10 years data). Due to performance issue, We have created an updatable view called xview(It fetches last 5 years data). On xview, I have created two instead triggers(insert and update). When i try to update last 5 years data, update trigger is working fine. But for previous data, I am not able to update. Can any one help me how to update that. Please help me with solution
Re: Regarding Updatable view - Please assist [message #674111 is a reply to message #674109] Fri, 04 January 2019 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67880
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

If you don't show us what you did you can't tell you what you did wrong.

Note that creating a view (unless it is a materialized view) does not improve performances, a view is just a short-cut for a SQL statement string.

Re: Regarding Updatable view - Please assist [message #674112 is a reply to message #674111] Fri, 04 January 2019 03:53 Go to previous message
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You're trying to use an updateable view to update rows that aren't present in the view?
Previous Topic: filter based on extracting string
Next Topic: Login table connection to another table.
Goto Forum:

Current Time: Sun Jun 13 18:50:46 CDT 2021