Oracle will return ORA-01031 (insufficient privileges). Hi Tom, I have a related question for an UPDATE - that takes unexpected long time. You said to use Oracle9I Merge statement when inserting or updating the data from a stagging table to history table. I this updation I want to find the equalent date/day in previous year corresponding to current year date and update the amount.I am using Table T1 to insert or update the data inthe Table T2 (which has a unique key column -c1 c2) in oracle 8.1.7. COM merge into t1 2 using t2 3 on ( t2.object_id = t1.object_id ) 4 when matched then 5 update set t1.object_name = t2.object_name 6 when not matched then 7 insert (object_id, object_name) values( t2.object_id, t2.object_name); 29317 rows merged. In my case Table T1 (staging table with 300 columns) will have 200 thousand rows every day for insert or update to the history table T2 ( 280 columns) that has 10 Million historical rows. For this I am using another table to find previous year dates for current year dates.w=300" data-large-file="https://suvendugiri.files.wordpress.com/2012/01/001.png? w=443" class="size-full wp-image-106 aligncenter" title="Table2" src="https://suvendugiri.files.wordpress.com/2012/01/002.png? w=869" alt="Table2" / We need to update the values of column ‘T2Description’ of table T2 which currently have null values ,with the values from table T1(field- T1Description). w=545" class="alignleft size-full wp-image-110" title="Result" src="https://suvendugiri.files.wordpress.com/2012/01/003.png? w=869" alt="Result" srcset="https://suvendugiri.files.wordpress.com/2012/01/003545w, https://suvendugiri.files.wordpress.com/2012/01/003.png? w=150 150w, https://suvendugiri.files.wordpress.com/2012/01/003.png? Note that, here we have 2 common field types i.e, Category and Description. The update script will look like- Result : Result " data-medium-file="https://suvendugiri.files.wordpress.com/2012/01/003.png? w=300" data-large-file="https://suvendugiri.files.wordpress.com/2012/01/003.png? Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause. When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.