Re: Last Row Inserted

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Sep 2005 18:04:28 -0700
Message-ID: <1125968633.12527@yasure>

at"@ wrote:
> DA Morgan wrote:
>

>>So why would a materialized view not be a good solution? Looks like a
>>reasonable solution to me.

>
>
> Can you elaborate please. I need to perform inserts on Table2.
>
> I can imagine that I could do something like:
> db1 is production box.
> db2 is new research box.
>
> Table1 exists on db1.
> I create Table2 on db2, identical to Table1.
>
> I create a materialized view MView1 which is a union of Table1 and Table2.
>
> Now MView1 is the table I'm striving to get.

Nothing prevents you from loading Table2 with the query of your choice. Nothing prevents you from doing an insert into Table2.

What do you see as being the issue(s)?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Sep 05 2005 - 20:04:28 CDT